BASIC and ADVANCED EXCEL

  • Working with Dates

  • Working with Macros

  • MS EXCEL Features

  • What IF Analysis

  • Finance Functions

  • Text Functions

  • Data Validations

  • Working with Charts

  • Pivot Tables

  • Error Handling

  • OFFSET Function

  • Match and Index Function

  • EXCEL Protections

  • Lookups

  • Logical Functions

  • Date Formula

  • Arithmetic Functions

  • Count, Sum and Average Functions

  • Conditional Formatting

  • Sort and Filter