Setting Up of Business, Industrial & Labour Laws
Accounting
Financial Management
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)
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, 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
Average service rating: 4.6, based on
10685 reviews
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 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 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 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 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 Shukla
- Best suited for slow Internet connection.
- Videos can be viewed depending on validity of the subject.
- Videos can viewed even while you are offline.
- Videos can be viewed on website for 30hrs also(updates will be provided online).
- Pen drive available for additional Rs 1000 for each subject.
- Pen Drive will be shipped in 3-4 working days.
- Pen Drives can used for personal purpose after expiry of subject or after viewing of stipulated hours (which ever is earlier).
- Runs just on one PC.
- Refund Policy.
- Video will self expire as per the subject expiry.
- Minimum 2GB free space required in C: Drive
- Supported OS : Windows 7 & above.
- Windows Media Player & .NET Framework 3.5 or higher must be pre installed.
- Antivirus software must be pre installed.
- Genuine Windows recommended for Win XP users. One time internet connection is required for activation.
- Interaction with teacher via click to call and email service.
- 5% extra discount for existing enrolled students. Final Price visible in checkout page.
CAclubindia
