Advanced Excel Course (2019 Version)

Advanced Excel Course in Worli (2019 Version)

Master Microsoft Excel from Beginner to Advanced. Learn the most common Excel functions used in the Office. Maintain large sets of Excel data in a list or table. Wow your boss by unlocking dynamic formulas with IF, VLOOKUP, INDEX, MATCH functions and many more.

Access to a Professional Trainer with 6+ years of Excel Training.

Master 75+ Excel formulas & functions with hands-on demos from a experienced Microsoft Excel instructor

What you will get with this advanced excel course?

  • CAT (Center for Advanced Technologies) Certificate
  • Printed Book
  • Online Exam
  • LIVE Projects on Basic & Advanced Excel

QUICK Inquiry Form

Fees- 4,000/- Only | Group Discount Available

In-Depth Knowledge | LIVE Projects

Basic Excel

Excel Introduction

Basic Functions

(AVERAGE, MIN, MAX, COUNT,COUNTA, ROUND, INT)

Nested functions

Learn Nested Functions

Logical functions

Learn Logical functions using IF, AND, OR, NOT

The LOOKUP function

Date and time functions , Annotating formulas

Sub Total Reports, Auto Filter

Learn Sub Total Reports, Auto Filter

Password Protecting Worksheets

Learn How to Password Protecting Worksheets

Linking Multiple Sheets

Learn how to Linking Multiple Sheets

Sheet Referencing

Learn Sheet Referencing

Advanced Functions

LOOKUP, VLOOKUP, HLOOKUP, COUNTIF, SUMIF

What-if-analysis

Learn How to use What-if-analysis

GOAL SEEK

Learn how to use GOAL SEEK

NESTED IF

Learn How to use NESTED IF

Reporting

Learn Reporting in Excel

Character Functions

Learn Character Functions in Excel

Date Functions

Learn Date Functions in Excel

Age Calculations

Learn Age Calculations in Excel

Consolidation of Data

Learn Consolidation of Data in Excel

Data Validation

Learn Data Validation in Excel

PIVOT TABLES

Learn PIVOT TABLES in Excel

Functions with Super Powers

Learn Functions with Super Powers

Array Formula / Tables

Learn Array Formula / Tables

Charts that Inspire

Create Professional Looking Charts in Excel

Graphic Tricks/Techniques

Learn Graphic Tricks/Techniques

Working with External Data

Learn How to work with External Data

Rs, 4,000/- Only

Fees with Book

Certification

Get Govt. Recognized Certification...

Printed Book

Get Printed Book for Advanced Excel Course...

Group Discount Available...