Power Query and Power Pivot for Accountants
Importing, cleaning and merging data automatically, then building and analysing a data model.
Course contents
- 1Importing data from several sources
- 2Cleaning and transforming data
- 3Merging and appending tables
- 4The data model and relationships
- 5Basic DAX measures
What you gain from the course
You can automate monthly data preparation and analyse files larger than ordinary sheets can handle.
Other courses in the same track
Advanced level and automation
Automating Accounting Tasks with Macros and VBA
Recording macros and writing simple VBA code to cut down repetitive tasks.
30 training hours