Enquiry : 9920294574

Advanced Excel – Online

Salient Features

  • Learn Advanced Excel from the comfort of your Home

  • Organised in two parts (Part 1, Part 2)

  • High Quality Videos that you can download

  • Entire Training in Marathi

  • Minimal Internet bandwidth and uninterrupted playback (as Videos are pre-loaded)

  • Unrestricted access of  One Month for each part

  • Videos for Excel VBA Macros also available

 

Demo : How to use IFERROR in Excel

 

 

Course Curriculum (Part 1)

Module 1 : Overview of the Basics

  • Overview of the Basics

  • Transpose

  • Hyperlinks

  • Comments

Module 2 : Working with Functions

Logical functions

  • IF

  • AND

  • IF – AND

  • OR

  • IF – OR

  • NOT, IF – NOT

Mathematical and Statistical Functions

  • COUNTIF

  • COUNTBLANK

  • RANK

  • IFERROR

  • Nested IF

Lookup Functions

  • MATCH

  • INDEX

  • OFFSET – MATCH

  • INDEX – MATCH

  • VLOOKUP

  • VLOOKUP with COLUMN

  • HLOOKUP

  • HLOOKUP with ROW 

  • Nested VLOOKUP

MIS Reports

  • MIS Report

Module 3 : Data Validation

  • Checking for Whole Number

  • Using List

  • Preventing Duplicates

  • Limiting the Totals

  • Restricting Day

  • Restricting Size

Module 4 : Data Form

  • Creating Data Form

Module 5 : What-If Analysis

  • Goal Seek

  • Scenario Manager

  • Data Table

Duration : 30 Days

Fees : Rs. 500/-

Call 9920294574 to receive Download Link

 

Course Curriculum (Part 2)

Module 6 : Conditional Formatting

  • Highlight Cells Rules

  • Top / Bottom Rules

  • More Examples of various Rules

  • Custom Formatting with Formula

  • More Examples of Custom Formatting

Module 7 : Sorting and Filtering Data

  • Sorting

  • Multiple Level Sorting

  • Filter

  • Advanced Filter

  • WildCard

Module 8 : Common Functions

  • Text Functions

  • Date and Time Functions

  • Financial Functions

Module 9 : Working with Data

  • Consolidate Data

  • SubTotal

Module 10 : Pivot Tables and Charts

  • Pivot Table : Design

  • Pivot Table : Analyze

  • Column Chart

  • Pie Chart

  • Pivot Chart

Duration : 30 Days

Fees : Rs. 500/-

Call 9920294574 to receive Download Link