Excel - Pro User
Nesting VlookUps
How to nest or combine multiple vlookups into a single answer. This is a highly sought after skill.
Index and Match - Next Level
A Data Model is a new approach for integrating data from multiple tables, effectively building a relational data source inside the Excel workbook.
Power Automate
Power Automate, formerly Microsoft Flow, is an online tool within the Microsoft 365 applications and add-ins, used for the creation of automated workflows between apps and services to synchronize files, get notifications, and collect data.
DAX
Data Expression Analysis, don't even try this if Excel formulas scare you. Defenitely not if you do not understand IF statements. DAX is advanced and requires a certain skill to extract and manipulate data.
Some would call this the language of Excel. ps: it aint!
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