What's the course about?

Power View is a data visualization tool that enables the creation of interactive charts, maps and other visuals that bring your data to life in stunning reports.

Power Query is an intuitive tool that lets you manipulate, transform, consolidate, enrich, merge and do much more with your data.

Power Query acts as an "ETL" tool which means it Extracts data from almost any data source, Transforms that data and then Loads it - in our case that's either an Excel worksheet, Power View report or Power Pivot data model.

Here's what other thought about the course:

"Very enjoyable course with many real world examples. Gilly's enthusiasm for the Microsoft Wizardry is wonderful and spurs you on to master it. I look forward to more courses by Gilly!"

- Douglas Paterson

"Very easy to understand"

- Dale Pierce

Who is this course for?

Excel Users

Users that employ Excel 2016 on a daily basis and want to exploit the full power of the new Excel Business Intelligence tools in to improve their reporting and data crunching capabilities HAVE TO TAKE THIS COURSE!

IT & BI Specialists

Professionals that are in charge of the data warehouse management of their company and need to understand how to provide support to analysts who need to extract data from different analytical and relational sources HAVE TO TAKE THIS COURSE!

What's in it for me?

As a Microsoft Excel trainer, I understand that the value of a training course is in making sure students learn skills that they can apply in their daily jobs.

My goal - with every course I create and deliver - is to ensure that all students learn practical skills that can be applied in the real world. To maximize learning, I provide:

• Solid instruction
• Follow along downloadable files
• Practice exercises and solutions
• Supporting pdf user guide

Topics Covered

Power View

• Discover the Canvas & Visualizations
• Switch to Matrix, Cards, Callouts or Charts
• Learn how Power View filters data
• To Slice or TILE BY - decisions, decisions....

• Work with multiple tables and create relationships

• Create stunning reports with images and interactive maps

Power Query

• Ladies and gentlemen, may I present the Query Editor
• Learn how to transform messy data into useful data sets
• Append multiple file types together into a single data set
• Merge tables - if you like VLookup - you're gonna love this!
• Combine multiple Excel files
• Create your own custom columns with Power Query “M” language expression builder

Throughout the course we work together building Power View reports and transforming data with Power Query. At the end of each step you have an opportunity to practice creating your own Queries and Reports to help you consolidate, embed and reinforce everything you have learned. I provide a solutions video lecture before moving on to ensure you’re on track and ready to move on.

I provide all the files you need to follow along and a fully supporting pdf user guide detailing all the steps and practice exercises with solutions.

Thanks for taking the time to check out my course. I can't wait to help you take the next step in developing your Microsoft Excel skills. I have used Excel 2016 to demonstrate this fantastic tool and you’ll need Power Pivot installed ready to go.

If you have any questions about the course, feel free to message me here or check out the FREE preview lectures to learn more.

Take the first steps to a new and rewarding future by clicking on the TAKE THIS COURSE button, located on the top right corner of the page.