In this module, you will learn the basics of how to work with structured data and how to combine data from different sources in order to generate comprehensive, efficient and automatic reports. You will learn how important Power Query is, not only for acquiring, preparing and manipulating data, but also for solving a range of Excel problems that might not seem obviously data-related.
Having learnt how to beat your data into the shape you need for reporting, you will see how to use PivotTables to move from data to a dashboard, driven by interactive slicers. You will see how macros and scripts can automate spreadsheet processes but that they need to be used with care.
To finish the entire set of course steps, you will learn some important techniques for dealing with common spreadsheet problems as well as helping to avoid them in the first place.