Advanced Excel Course

Session-1 Understanding Cell References and Range

    1 Working with range name

    2 Cell References

Session-2 Working with advanced Functions

    3 Statistical functions

    4 Logical functions

    5 Array functions

Session-3 Data Visualization

    6 Conditional Formatting part-I

    7 Conditional Formatting Part-II

    8 Conditional Formatting Part-III

    9 Data Sorting

Session-4 Analyzing Data

    10 Normal Filter

    11 Advanced Filter

    12 Filter with Subtotal Function

Session-5 Managing Date and Time in Excel

    13 Date & Time Function Part-I

    14 Date & Time Function Part-II

Session-6 Validation Data and understanding error

    15 Data Validation

    16 Error handling

Session-7 Managing and consolidating data

    17 Working with Table

    18 Consolidate Data from Multiple Sheets into one

    19 Data Analysis using Subtotal Tools

Session-8 Generating Interactive Reports using Pivot Tables

    20 Pivot Table- Part - 1

    21 Pivot Table- Part-2 Slicers

    22 Pivot Table- Part-3 Calculated Field

    23  Pivot Table- Part-4 Calculated Item

    24 Pivot Table- Part-5 Date Timeline

    25 Pivot Table- Part-6 Recommend PT

    26 Pivot Table- Part-7

Session-9 Working with What if Analysis Tools

    27 Data Sorting

    28 What if analysis- Goal seek

    29 What if analysis- Scenario Manager

Session-10 Auditing and Securing data in Excel

    30 Formula Auditing

    31 Data Protection in Excel

    32 Data Import From text

    33 Data Import from Web

Session-11 Working with Lookup Function

    34 Vlookup with False parameter

    35 Vlookup with True parameter

    36 Vlookup with any left column

    37 Vlookup using Array

    38 Vlookup Limitation

    39 Vlookup with sum

    40 Vlookup with multiple lookup values

    41 Hloopuo Function

    42  Match Function

    43 Index Function

    44 Match and Index Combination

    45 Vlookup with match

Session-12 Introduction of VBA Macros

    46 Introduction to excel macro VBA