Excel for Accountants: Power Query
In this month’s Excel topic podcast episode, Neale Blackwood CPA will discuss Power Query and why accountants should be using it. Neale will cover topics that all Excel users should know relating to Power Query such as mapping tables, unpivot, merging, appending and budgeting among others.
- Why you need to get your data right in Excel (1:40)
- Mapping Tables is an important part of Power Query (5:56)
- What the unpivot feature is and how it works (10:49)
- Merging and appending data (13:18)
- Budgeting with Power Query (15:02)