Author(s)
Bryan Smith; CPA Crossings

Publisher:
AICPA

    Credit Info
  • NASBA Field of Study

  • Format

    On demand

  • Level

  • CPE Credit

    0

  • Course acronym

  • Prerequisites

  • Course duration

    4 Hours

Microsoft Power BI – Analyze Your Data with Excel Pivot Tables

This course is designed to teach participants the importance of the PivotTable tool. This course demonstrates how to create pivot tables to make data analysis an easy task for all accountants. Participants will learn, step-by-step, the process for creating pivot tables and pivot charts for reporting. Set-up options will also be covered. This session is presented using Excel 2019/Office 365. Regardless of the version you are using, most concepts covered in this course apply to all versions of Excel.
$95.00
Hurry up, special offer for a limited time only.
Topics discussed

Pivot tables for data analysis
Pivot table creation
Pivot charts

Learning objectives

Determine the advantages of using PivotTables to analyze data from multiple dimensions
Apply the step-by-step process to create PivotTables
Choose the PivotTable options that best fit your needs
Use Pivot Charts to present your data graphically for the most effective analysis

Who will it benefit?

Data analyst and data scientists.
Anyone who wants to analyze data in Excel.