Get Started with Power BI

OL1440  |  On Demand Course  |  Update  |  Self-Study

Description

In the ever-evolving world of data analysis and office productivity, Microsoft Excel remains at the forefront, continuously introducing new and powerful features. "The Latest and Greatest Excel Features" is a comprehensive 2-hour course designed to familiarize participants with the most recent and significant updates in Excel as well as some old favorites. This course offers an in-depth exploration of these features, ensuring learners can harness their full potential for efficient and innovative use of Excel.

Credits

Number of Credits Type of Credits
2.00 Computer Software & Applications

Designed For

Anyone who wants to enhance their analytical skills and embrace the advanced capabilities of Power BI, setting them apart in a data-driven business environment.

Highlights

The major topics that will be covered in this class include:

  • Overview of the Power BI Tools: Introduction to the Power BI ecosystem, including Excel's Power BI features (Power Pivot and Power Query) and standalone tools (Power BI Desktop, Power BI Service, Power BI Report Builder and Power BI Report Server).
  • Tour of the Tools: Introduction to the interfaces of Power Pivot, Power Query, Power BI Desktop and Power BI Services.
  • Comparative Analysis:
  1. Understand the strengths and limitations of Excel's Power BI features versus standalone Power BI tools.
  2. Strategic decision-making on when to use each tool for optimal efficiency and accuracy in data analysis tasks.

Objectives

After attending this presentation, you will be able to...

  • Identify the key updates and enhancements in the latest version of Excel, including their specific functionalities and how they contribute to improved efficiency and productivity in Excel.
  • Recognize the capabilities of new automation tools in Excel, particularly those that are designed to streamline repetitive tasks and complex data analysis.
  • Recall how the Fuzzy Lookup Add-In can be used for textual data matching in Excel.

Prices

Member (Early Bird)
$89.00
Non-Member (Early Bird)
$129.00
Member
$89.00
Non-Member
$129.00
Your Price: $129.00

This is your base price and does not reflect any additional session fees, optional add-ons, or guest registrations.

Members log in and save $40.00 on this event. Not a member? join today.

Instructors

Bryan L. Smith, CPA, CITP, CISA

Bryan serves as a trusted adviser to CPAs in public accounting, as well as business and industry, on all aspects of information technology. Bryan's expertise includes in-depth knowledge of paperless work flow solutions, the impact of technology on internal controls, strategic IT infrastructure design and information security best practices. As a nationally recognized author and presenter on information technology issues impacting CPAs, Bryan is passionate about the opportunities for CPAs to benefit from safe and secure computing.

Back to Instructors
Return to Events