Excel - Power Query

Finally, after all that, welcome to Excel clever

This ain't no ordinary Excel this. Let's start with Power view, and then Power Pivots and moving onto Power Query.


Let's kick it up a notch, R and Data Analysis

Where it all began

Way back in the 1990's, rather watch the video


Quality is only 480, and back then it was a huge jump.


Power View

Power View is a data visualization technology that lets you create interactive charts, graphs, maps, and other visuals that bring your data to life.


Power View is an interactive data exploration and visualization tool in Excel. Power View supports various visualizations such as Tables, Matrices, Cards, Charts such as Bar, Column, Scatter, Line, Pie and Bubble Charts and Maps.

Power Pivot Tables

Power Pivot is an Excel add-in you can use to perform powerful data analysis and create sophisticated data models. With Power Pivot, you can mash up large volumes of data from various sources, perform information analysis rapidly, and share insights easily.


In Power Pivot, there is no limit on the number of lines (as in Excel).

Power Query - PQE

With Power Query (known as Get & Transform in Excel), you can import or connect to external data, and then shape that data, for example remove a column, change a data type, or merge tables, in ways that meet your needs. Then, you can load your query into Excel to create charts and reports.

Popular posts

Excel Pivot Tables

Realy this is the next logical step from Advanced and once completed to move to Power User.

Excel Advanced Charts

Easily my most favourite skill. Why, simple because most people skipp this one. Being able to go from simple to calculated dynamic charts is next level.

Killer Reports and Dashboards

Interactive reports using Dashboards in Excel is hands down the reason why Excel even exists.

Excel Power Query

Imagine huge amounts of data, too large for Excelo to handle, yet you need answers.

Excel Financial Modelling

Just for all you Accountants out there. Excel for Accountants is the number one skill to have when attemting Accounts without a proper payed solution.

Unleash the Power of you Laptop with Excel VBA

VBA allows use the ability to automate work and workflows, online or onsite.

About this blog

Learning in 2022 should be easy and accessible accross all mediums.


SImple to understand and easy to apply.

Preview Workshop

The proof is in the pudding as they say, have a look, and if you likey like then upgrade

NEWSLETTER

Join our newsletter and support our kickstarter campaing

Created with © systeme.io