This comprehensive 2 day Microsoft Excel course is designed for those looking to extend their Excel knowledge and add Power Pivot and Power Queries to their skillset. This course will introduce what both of these features are and then, using working examples, will get you familiar with the concepts in practice.
To truly get the most out of analysing your data within Excel, you need a practical knowledge of using power queries, lookup functions, DAX and power pivots. Our trainers will guide you through the process and show you some of the tricks of the trade to get where you need to faster.
By the end of this course, you will be able to use the Power Query and Power Pivot tools to retrieve, shape, analyse and report on the data within your spreadsheet.