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
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.
- 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
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
Average service rating: 4.6, based on
10709 reviews
5
1
ServiceReview