This one-hour course will provide users with hands-on practice using PivotTables and Excel. Users will learn and apply skills to create, structure, and analyze data using PivotTables. The benefits and limitations of PivotTables will be discussed. Users will be introduced to Power Pivot and Online Analytics Processing within it.
This course is one in a ten-part certification series, Core Data Analytics: Excel and Power BI Skills for Accounting and Finance Professionals, by Surgent IQ.
Accountants who want to transition to data analysis and have a basic knowledge of Excel and Excel formulas
Intermediate knowledge of Excel
Install Power Pivot and Data Analysis ToolPak