Let’s divide the skill levels into: Beginner (L1), Intermediate (L2), Advanced (L3) & Automation (L4)
This understanding (L1 to L4) is important to be able to set learner expectations and match them with the training’s offering
You who are using Sort, Filter, copy-paste techniques to make reports. Their work mostly involves data entry. They doubt their formula writing abilities. They rarely use functions beyond SUM, MAX, and AVERAGE etc
You have begun using basic VLOOKUP and IF. However, if VLOOKUP shows #N/A error, you revert to find, copy, paste and double-checking every entry. You have a limited clarity on using the functions correctly. You would have infrequently used Pivot Table, Charts. You need to Learn Excel’s advanced techniques
You who are proficient in Pivot Table, inter-sheet and inter-workbook VLOOKUPs, basics of SUMIF, COUNTIF, and data cleaning tricks. You are looking to learn time saver tricks, expand possibilities, and perform complex calculations. E.g. topics such as Macros, 2-D lookup, reverse lookup, multi-criteria SUMIFS and COUNTIFS, advanced Pivot Table features will be interest to them. They will be keen to learn advanced functions such as OFFSET, INDIRECT, Array formulas, multi-dimensional what-if analysis, advanced charts, dashboard, Macros coding, Power Query, formula based Conditional Formatting etc.
Recommended Course: Excel Ninja, Dashboard and Excel Modelling
You are the Go-To person in the organization for Excel Automation problem solving. They learn faster and wish to keep themselves updated about better ways of problem solving. You will know: How to communicate with other applications to automate task, optimizing code efficiency, userforms, user defined functions.
I would like to tell you that I am very impressed with your courses so far – I particularly like the short videos that allow me to get to a topic quickly and then move on (your competitors mostly offer 20-30 min videos which is a bit much to keep one’s attention span). The other gem in your training are the shortcuts, I found no other course with the same insights.
The courses are really helpful whether regarding saving time, improving your presentation skills or getting to learn new features. The videos give you the feeling of one to one attention. Moreover, their constant attachment by emailing new tricks is highly appreciating. #thankyouteamyoda
This will save so much time I am quite a heavy user of PowerPoint but have never formally learned how to use it properly This course has shown me how incredibly time consuming my ways of using it are.
Far far away, behind the word mountains, far from the countries Vokalia and Consonantia, there live the blind texts. Separated they live in Bookmarksgrove right at the coast of the Semantics, a large language ocean. A small river named Dud