Microsoft Certified Trainer with over 20 Years of Training Experience, and over 35 years in IT overall
About this course
CPA Alberta
CPA British Columbia
CPA Manitoba
CPA New Brunswick
CPA Nova Scotia
CPA Ontario
CPA Prince Edward Island
CPA Saskatchewan
CPA Newfoundland & Labrador
CPA Quebec Order
These days, there is tons of data coming in from many sources. You are expected to import all of that data, and then get meaningful results from that data.
This course will help you do that.
Topics include:
Normal Pivot Table Formulas
Sorting & Filtering the Pivot Table
Calculated Items
Calculated Fields
Conditional Formatting in the Pivot Table
Consolidated Pivot Tables
Importing data from Excel into PowerQuery – normal data
Splitting & Merging Columns in the PowerQuery
Calculate age in the PowerQuery
Adding Custom Calculations in PowerQuery
Importing data from a website into the PowerQuery
Refreshing the data in PowerQuery
Importing data from Excel into PowerQuery – formatted tables
Importing Access, SQL Server, and text files into PowerQuery
Append Queries
GroupBy Queries
Merge Queries
More Calculations including a conditional column in PowerQuery
Activating PowerPivot
Exploring the PowerPivot menus
Starting the Pivot Table from PowerPivot
Managing Table Relationships
Slicers & Timelines in PowerPivot
Using Sets in PowerPivot
Importing Data directly into the PowerPivot
Measures & KPI’s in PowerPivot