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
Realy this is the next logical step from Advanced and once completed to move to Power User.
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.
Interactive reports using Dashboards in Excel is hands down the reason why Excel even exists.
Imagine huge amounts of data, too large for Excelo to handle, yet you need answers.
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
Created with © systeme.io