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.
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 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).
This will save so much time I am quite a heavy user of PowerPoint Online 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.
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.
with exact strategies and techniques used in this course