Excel - Power User
Excel Clever..
Now the real corporate side of work starts. Linking Excel to variuos data sources or even reading data from an alternate Data source.
Tools Like Power View, Power Pivots and Power Query stand out here.
Remember DSUM
Adds the numbers in a field (column) of records in a list or database that match conditions that you specify.
Indirect - Expert
Excel INDIRECT is used to indirectly reference cells, ranges, other sheets, or workbooks. It lets you return the reference to a cell, based on its string representation. As a result, you can change a cell reference within a formula without changing the formula itself.
Combine everything you have learnt so far
Now the real corporate side of work starts. Linking Excel to variuos data sources or even reading data from an alternate Data source.
Tools Like Power View, Power Pivots and Power Query stand out here.
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