This one-hour course will focus on the use of Excel with Power BI and Power Query to organize and analyze data. Users will primarily work with calculated columns generated from existing data. They will walk through hands-on exercises to create calculated columns, add dimensions to existing data tables, and create hierarchies within the data tables. Special attention will be paid to Star Schema analytical modelling. To explore practical applications, users will apply the skills to journal entry testing.
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
2+ years of experience working with Excel
Install Power Pivot and Data Analysis ToolPak