Excel Masterclass Skills
4.5 (202 ratings) 2,144 students enrolled
Users and Learners who are proficient in Pivot Table, inter-sheet and inter-workbook VLOOKUPs, basics of SUMIF, COUNTIF, data cleaning tricks and are looking to learn time saver tricks, gain productivity out of possibilities, and do all the complex calculations. E.g. topics such as Macros, 2-D lookup, reverse lookup, multi-criteria SUMIFS and COUNTIFS, the advanced Pivot Table features will be of 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. This Masterclass is exclusively designed for such users who’ll be keen to learn these functions based on the Advanced Learning Techniques.
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.
Thank you. I love your website (I use it daily to answer questions) Thanks for providing such a valuable resource
Excellent course. I’ve taken several courses on pivot table before and I can say that this has been the best. Very engaging instructor. The whole concept of data table has become clear to me. I’d highly recommend this course. Looking forward to taking other courses from the same instructor
I recommend this course. You will learn a lot of time savers tricks, and a way of giving your reports and business documents a very professional look. Rishabh goes straight to the point and will help you to increase your productivity with this software.
We’ve helped these Companies
with exact strategies and techniques used in this course
For Enquiry About Courses? Contact Us:
Feel free to call us for any query related to courses. Our support team will resolve your issue.