This course introduces you to Power Query, the easy way to import data in to Excel. Discover how to fix common data issues with dates, missing entries and added spaces.
You will learn how to handle single files plus how to bring in multiple files and combine them.
Budget Example
Discover how to use Power Query to solve two major issues in multi file budget systems. Example uses a P&L budget.
These techniques have been applied to a budget, but could also be used for forecasting and reporting.
Learn how to
- quickly create a budget template to speed up development time
- link all budget files to central tables that expand
- create dynamic drop down lists
- compile multiple Excel budget files into a single budget layout
- create a normalised budget listing ready for use in pivottables and formula-based reports
- how to use folders for versions and easily update the folder in your compilation file.
This is a practical, hands-on application of Power Query in a budgeting setting.
Level: Intermediate
Duration: 3 hours
Price: AU$39