Brief Summary
Join our awesome Excel course to learn everything from the basics to advanced tricks, packed with tips and support, all in Hindi!
Key Points
-
18 tutorial videos covering beginner to advanced tricks
-
Lifetime access and updates included
-
Learn in Hindi with support and guided practice
Learning Outcomes
-
Master crucial Excel functions like VLOOKUP and SUMIFS
-
Utilize advanced tricks to save time and improve presentations
-
Gain lifetime access to resources and continuous updates
About This Course
Learn Beginner to Advanced tricks on VLOOKUP, INDEX, MATCH, SUMIFS, COUNTIFS, Text formulas and more in Hindi
"Microsoft Excel for Professionals" is a comprehensive online training program. It is divided in 3 Levels and covers exhaustive list of topics. There are 18 tutorial videos and the duration is 1.5 hrs. Topics often ignored in other intermediate/advanced online programs have been included. Watch Demo Preview Lectures to find the difference.
VLOOKUP() with MATCH()
HLOOKUP() with MATCH()
INDEX() with multiple arrays & two MATCH()
SUMIF() vs. SUMIFS()
SUM() vs. SUBTOTAL() while using Filter
Hidden Text-to-Columns tricks
Applications of INDIRECT() and OFFSET()
Pivot Table tricks on calculating automatic sum, count, percentage and generating grouped data headings
Power of "GO TO - Special" along with Ctrl+Enter
Using "Find and Replace" with wildcard characters
Combo techniques for Data cleaning
Formula-based Conditional formatting
Inserting Picture in Comments... and the list of such tricks is very long
Instructor: CA. Rishabh Pugalia, Founder, Excel Next
So if you intend to take your Excel application skills multiple notches higher, gain from the experience of a training instructor who -
Is a qualified Chartered Accountant
Has worked with KPMG and J.P. Morgan
Has trained 5,500+ professionals (Apr 2010 - June 2014) in face-to-face training programs
Has incorporated in this online program 100s of tip-n-tricks, which he has acquired over the years through various forums, experimentation, problem solving challenges and training interaction
And by the way he has conducted more than 100 (hundred) workshops for one of the Big Four firms, where the participants are from numerous departments and domains. The insights acquired have been meticulously incorporated in to the program.
-------------------------------------------------------------------------------------------------------------------
"The courses are really helpful whether in terms of 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" by Arundhati Raychaudhuri, Finance Professional, India
-------------------------------------------------------------------------------------------------------------------
Important information before you join:
It's in HINDI language
Once enrolled, you have unlimited, lifetime access to the course!
You will have instant and free access to any updates I'll add to the course.
I will give you my full support regarding any issues or suggestions related to the course.
Guided practice - over worksheets included for immediate practice
Access to all videos 24 x 7 - learn online from anywhere
A 30-day money back guarantee (we want you to be 100% satisfied)
-----------------------------------------------------------------------------------------------------------------
If you have read this far, next action is JOINING this course. Invest 1.5 hrs. for a benefit of lifetime Ninja status on Microsoft Excel!
Learn Beginner to Advanced tricks on Excel Formulas in Hindi
Get Downloadable Case Studies + Picture based eBook [mapped to the Lectures]
Get Course Completion Certificate
Jayant D.
Simple and easy to use