Analytical Excel - Certification Course by Grant Thornton in India and CCI Online Learning






Price 2,499.00
Price 1799.00
(Inclusive of Registration and Tax)

  • Video Duration: 8.45 Hours
  • Language: English
  • E-Certificate: Joint Certificate by CAclubindia and Grant Thornton in India
Enroll Now

About the Course :

Excel is more than a tool to make spreadsheets. It is a skill that can work wonders for all. Why we say all, is because Excel teaches how to simplify and organise your work in the most efficient manner. Having an organisational skill that maximises your efficiency, who wouldn't want that?

For students, businessmen, practitioners, or to say people who deal with large amounts of data everyday and have to make sense out of those numbers, Excel is a must-have tool.

If you are a beginner to excel who knows how to put basic numbers into it, then after taking this course you will be able to unleash yours and Excel's true potential.

This course is designed keeping every kind of user in mind, it starts from the basics and then takes you through the intermediate and advanced stages of excel. The instructor from Grant Thronton India, will take you for a ride with funny examples, beautiful charts and simple shortcuts.

Here's take a sneak peak of the course with the demo videos.


Demo Video :


What’s included in the purchase?

  • Complete online access to the course
  • Certificate of Participation
  • E-book, as a supporting material.

Objectives of Excel Training

  • Participants will learn to how to simplify complex spreadsheets
  • Enhance spreadsheets with templates, charts, graphics, and excel formulas and streamline their operational work
  • Use advanced functions of MS Excel to improve productivity,
  • They will apply visual elements and advanced formulas to a worksheet to display data in various formats.
  • Participants will also learn how to automate common tasks, apply advanced analysis techniques to more complex data sets, collaborate on worksheets with others

What's inside the course?

Basic

  • Introduction to the Excel Interface
  • Performing calculations
  • Formatting
  • Images and Shapes
  • Printing

Intermediate

  • Charts
  • Working with Multiple Workbooks & Worksheets
  • Text & Date Functions
  • Named Ranges
  • Summarizing Data
  • Tables
  • Pivot table, Charts & Slicers
  • Data validation

Advanced

  • Conditional logic
  • Automating Lookups
  • Formula Auditing & Protection
  • Recording Macros
  • Spreadsheet design & Documentation
  • Advance Formula Techniques
  • Data Cleaning & Preparation
  • Financial Functions & Working with Dates
  • Advanced Lookup Functions
  • Building a Professional Dashboard
  • Power Query

Who should take it?

  • Students
  • Businessmen
  • Practitioners
  • Entrepreneurs
  • Anyone who wants to master organizational skills at work

About Grant Thornton :

With more than 53,000 people in over 130 countries, Grant Thornton is present in 15 cities of India.
It is one of the top 5 Global Accounting firms. Through e-learning, Grant Thornton has combined years' of practical knowledge and technical insights in their courses. All of their courses are designed in building the framework of the subject right from strengthening the foundation with basic.



Terms and Conditions :

  • Total Length of Videos: 8.45 Hrs
  • Expiry: 3.0 months or 12 hours of viewing whichever is earlier from the date of registration
  • Videos are meant for web viewing only and cannot be downloaded. Videos are available in Full Screen viewing
  • Course/Subject purchased once cannot be cancelled.

Enroll now




Speak to the Counselor

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


  Request a Callback


×

  CCI MENU