Online Excel Course - Excel Mastery Program





Price Rs. 2,999.00
Offer Price 1999.00
(Inclusive of Registration and Tax)

  • Video Duration: 19 Hours (220+ Videos)
  • Along with the Course : Excel Mastery E-Book and Practical Files
  • Language: Hindi
  • E-Certificate (On completion: issued by CAclubindia)
Buy now
Course Pack

What will you learn ?

  • It’s simple - you will learn to make your work stand out.
  • In today’s times, deep diving in a subject pays off. No one wants a mediocre professional on his team.
  • That is why I bring to you, the "Excel Mastery Program"

You will learn those topics and methods which others don’t teach. For example:

  • Uses of complex Lookup Formulas such as OFFSET, INDIRECT in a simplified fashion with multiple application
  • Hidden Tricks & Settings – Compare 2 Excel files, Split Text to Rows, Unpivot Columns
  • Projects for Finance, and Sales
  • Use of Cell Referencing ($) in formulas
  • Fill intermittent black cells using Go To special
  • The common mistake of Vlookup users
  • Using SUMIFS to find the sum of values between two dates
  • A hidden trick of COUNTIFS to do VLOOKUP for duplicate values
  • A hidden trick of Consolidation using SUM for multiple sheets
  • Fuzzy Lookup can do what VLOOKUP can't
  • Hide a sheet so that no one can unhide easily?
  • Why does a Date in Excel look like a random number?
  • Rectify dates format using Text to Columns
  • TRIM formula to remove excess spaces in a sentence
  • Use SUMIFS & COUNTIFS with 3 criteria
  • Basics of Macro etc.

Detailed Content List : Click here to downlaod

Why is this course different? What separates this course from the rest?

CA Rishabh Pugalia's education, job experience, training experience, and his passion will make this course different and separate from the rest

He is a Chartered Accountant and has worked with companies such as KPMG (Audit) and J.P. Morgan (Debt Capital Markets). He has trained professionals from 50+ companies such as PwC, EY, Flipkart, ITC, etc. Now he's training the Trainers to train on his behalf. His video courses are used in top blue-chip companies.

He's not just a “YouTuber” who records courses. He creates courses with a very strong emphasis on two things: (a) Logics, including why and what not to do, and (b) Case Studies that reflect use cases.

Requirements

  • Excel 2007 & above
  • Your hunger to succeed

Who this course is for

Every professional who uses Excel has a different career goal. For example:

  • Analyze data: MBA, Engineers, Analysts
  • Work faster & Automate reports: Accountants
  • Become an Excel Expert: Consultant, Freelancers

Audience


  • Students
  • Executives
  • Managers
  • Practitioners
  • Chartered Accountants
  • Entrepreneurs/Businessmen
  • Anyone who wants to use the tool to master organisational skills at work

So, do not spend so much time thinking, go ahead and enroll for this course! We at Caclubindia are very much concerned about your future. Let's learn together.


Buy now


About the Training Instructor

Rishabh Pugalia

Rishabh Pugalia, Founder, Yoda Learning Solutions has trained more than 9,000 professionals on Advanced Excel Ninja across 15+ cities since 2010.


  • He is a Chartered Accountant and has graduated from St. Xavier's College, Kolkata.)
  • He has worked with KPMG (Assurance), Futures First (Proprietary Trading - Interest Rate Futures & Options) & J.P. Morgan (Debt Capital Markets - Investment Grade). He has 10.0+ yrs. of work experience including 5.5 yrs. in Training.
  • He has co-authored a Technical Guide on how to use Excel for "Continuous Controls Monitoring" - it was published by the Institute of Chartered Accountants of India (ICAI).
  • He has conducted 100s of LIVE workshop for corporate clients from diverse industries and vertical - Big Four Accounting firms, Power, Cement, Metals & Mining, FMCG, Telecom, BFSI, Investment Banking, Engineering, Automotive & Ancillaries, Chemical, Real Estate, IT & ITeS etc.
  • His clientele pool includes prestigious names such as PwC, E&Y, ITC, Tata Sky, Tata Power, Birla Cements, Gulf Oil (Hinduja Group), J.M. Financials.
  • He is a Visiting Faculty, Financial Modeling, Great Lakes Institute of Management, Chennai.
  • He likes playing Badminton, Bowling and 1st person shooter game - Counter Strike.


Terms and Conditions:

  • Viewers will need Microsoft Excel 2007, 2010 or 2013
  • Total Length of Videos: 19 Hours (220+ Videos)
  • Expiry: 1.0 Year (Unlimited viewing) from the date of registration
  • Videos are meant for web viewing only and cannot be downloaded. Videos are available in Full Screen viewing
  • Subject purchased once cannot be cancelled

Buy now

FAQ on Excel Training

Where can we find excel course syllabus?

You can visit our website www.caclubindia.com. Check online certification courses, there you can find full details regarding the syllabus that will be covered in the course.

Is it a certification course?

Yes, we will be providing you a certificate on the completion of the course.

Is it a basic excel course?

The course will help you develop both basic as well as advanced skills. It is for beginners, intermediate users as well as advanced users.

Is it a free online course?

We charge a very nominal amount of fees from our users.

How to study excel?

The best way to learn is by getting a hands-on-experience on the software coupled with online coaching which helps to guide around the tool better.

How to master Microsoft excel?

Mastering Microsoft Excel needs in-depth knowledge of the tool along with hands-on experience.

How to learn Excel formulas?

Basic formulas are easy to memorize. However, you don't have to learn the formula, understanding the function of the formula can help you find the formula from the list

How to get good at Excel?

Consistent learning and experimentation with new and advanced features of the tool helps to get better at it.


CAClubIndia Service Rating

CAClubIndia
Average service rating: 4.6, based on 10438 reviews 5 1 ServiceReview

What our subscribers have to say


This is my first online course and I had a great experience! This covers just about everything in excel. well explained by faculty, i had cleared lots of doubts. Thanks to CAclubindia!

Rahul
    
Rahul Jain

Highly recommended!! Very good course for all. A really impressive start-up training, throughout this I have gained so much understanding about Excel.

Amit
    
Amit Malhotra

Thank you Sir for your course! This is the best Excel course I have ever taken! I would recommend this to everyone who wants to learn Excel. Thanks once a again!!

surubhi
    
Surubhi Sharma

This course has been a good start for all excel learners. As it is designed from the basic functions to the advanced level. Highly recommended to all basic to advance learners.

Aditi
    
Aditi Chopra

Wonderful online course! The best Excel instruction I have ever received. Thanks, for your help and I will keep practicing what I have learned!

Sudip
    
Sudip Shukla

Other recommended course