-
Untitled Section
14 Lessons-
StartHow to become Faster using the Excel Shortcuts?
-
StartHow to Navigate the Large Files?
-
StartHow to use group?, to declutter your data
-
StartHow to create Timeline for Project using Advanced DATE function in Excel?
-
StartWhat types of Errors comes in Excel ? and how to deal with them.
-
StartHow to do data Validations ? (Start your E Forms Journey)
-
StartHow to Dynamically use Vlookup and Hlookup
-
StartHow to easily add exceptions to your sum, average, count function by using sumifS, averageifS and countifS
-
StartHow to use sumif, averageif and countif to get the same result of sumifS, averageifS and countifS
-
StartHow to cleanup your description dynamically by using the most useful TEXT function (Basic)
-
StartHow to cleanup your description dynamically by using the most useful TEXT function (Advanced))
-
StartHow to overcome the weakness of vlookup by using Index and Match function
-
StartHow to organize and Rank using Frequency, Large, Small, Max and Min
-
StartHow to use SumProduct to forget other commands
-
This course is not open for enrollment
Advance Excel : (Top Excel Tips & Formulas)
Master Advanced Excel Formulas. Solve Complex Problems. Learn Advanced Excel Skills to Save Time & Impress others
Course Summary
If you're a business professional, who uses Excel on a daily basis, this is the course for you! The Course will Help You Build a Strong Foundation in Excel & Solve Complex Problems Fast - Use my top tips to save time Learn the top formulas for quick and dynamic analysis These will increase your awareness of the most useful Excel features to work faster and smarter. Only when you know the extent and possibilities Excel offers you, only then you are able to handle them with the best analysis.
Course Curriculum
Pankaj Dhingra
CMA Pankaj Dhingra,
With 30+ Years of experience in Accounts, Costing and Controlling, Pankaj has mastered the Costing and Controlling. He is Founder Member of the Saurabh System Development Network LLP, a software company which provides solutions for Costing and Controlling.