Online Excel Course for Beginners to Advanced Learners






Price Rs. 3,990.00
Offer Price 1990.00
(Inclusive of Registration and Tax)

Enroll Now

Course Pack

Microsoft excel skills are one of the most valued skills in any organization these days, mastering this skills can enhance an individual’s job prospects and provide better career options. It helps in performing job tasks more efficiently and effectively. It’s very easy for an expert in excel to build a career in corporate finance. With advancements in technology taking place at a rapid pace access to online tutorial in excel has become very easy.

So why wait when Caclubindia is introducing online tutorials for its users. This online tutorial is for beginners, intermediate, and even advanced users. A mastery in excel gives you a better analysis of data, whereas advanced excel takes your skills to another level. If you enrol for this course, we will help you grow faster. In this, you'll learn to use keyboard shortcuts. You'll also learn how to use advanced formulas and functions and formulas to perform a quality financial analysis and financial modelling.

What you’ll learn?

  • How to manipulate data with calculations
  • How to unlock the power of dynamic formulas
  • How to use pivot tables
  • How to reduce complexity of spreadsheets
  • How to make custom formulas/functions
  • How to master unique tips

Contents

Beginner

Easy to learn

  • Easy to learn and Apply
  • Data basics (Best usage of Shortcuts, Formatting tricks, cell referencing)
  • Simple problem solving (Sort and Filter basics)
  • Learn Essential Business Math (Formula Warm up, Pivot table overview

Intermediate Skills

Able to implement techniques in your office

  • Build simple models (Combo Formulas, 3-dimensional lookups, Date formulas)
  • Error-handling to avoid humiliation (data validation, auditing, track variables)
  • Learn Data Cleaning Techniques (Go-to-Special, Text formulas, Flash fill)

Advanced Skills

Ninja-Level Skills

  • Slide-ready output (Charts and Graphs, Printing techniques)
  • Dynamic Dashboards (Get Pivot data, Learn Reverse lookups, conditional calculations)
  • Managing Data Security (Passwords, sheet protection)

Enroll now

Features

The course is a combination of high quality video lectures, which can be watched multiple number of times, notes, demo lectures, query sessions and much more.

  • It is mainly designed for students who want to develop skills for worksheet analysis, use advanced excel formulas, use pivot tables, create macros, and much more.
  • We have an experienced faculty, which makes it much easier to learn.
  • We provide high definition videos.
  • We focus on concept building and promise completion on time.
  • Some advanced techniques are- using table for presentation of reports, array formulae, superior range names, etc.
  • Caclubindia will also give you a certificate of completion.

Advantage of taking this course

After taking this you will,
  • There is a huge demand for advanced excel executive in the market.
  • A combination of the power of Excel with flexibility of other applications like MS Access, Outlook or PowerPoint, promises career advancement opportunities.
  • Advanced excel users can complete their task faster and quickly.
  • This course provides information regarding technical areas Such as
  • Statistical functions, mathematical, Data, time and year role, logical and looping functions, chart/graph techniques and so.
  • Learn Creating, editing, saving and printing spreadsheets
  • Know about Working with functions & formulae
  • Learn representing data graphically.
  • Learn, how to simplify complex spreadsheets
  • Learn to work with templates, charts, graphics, and formulas and streamline operational work.
  • Learn to use advanced functions to increase productivity
  • You will also learn how to automate common tasks, apply advanced analysis techniques to more complex data sets, and be able to collaborate with the team on worksheets.
  • Have a skill upgrade
  • Have Better organisational skill leading to increased efficiency at work.
  • Build resume with advanced skill for better job opportunities
  • This Course is specially made to help learners with career-building skills. It will help you become better and efficient at your job

Enroll now

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.


Topics


Enroll 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: 11 hrs. (177+ Videos)
  • Expiry: 6.0 months (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
  • Case Studies (XLSX) for every Video - available for download
  • Picture based eBook (PDF) - available for download
  • Subject purchased once cannot be cancelled

Enroll 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.5, based on 5876 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 certification course


GST Training & Certification Course
IFRS 16 – Leases
Transfer Pricing
Course Pack



Speak to the Counselor

088803-20003,
1800-3000-0505 (Toll Free)


  Request a Callback


×

  CCI MENU