(Microsoft Excel Expert with Copilot for your data analysis processes)

This course will teach you advanced techniques, including how to use complex functions, present data in various chart formats, format data effectively, find specific information within large data sets, create and format PivotTables, manage document security and sharing, and onboard your AI companion in the data analysis process.

  • Type

    Face to Face

  • Date

    10 - 14 November 2025

  • Price

    Rs 20,000

Content
Module 1 : Advanced functions Logical functions
  • IF function
  • OR AND as nested functions
  • Nested IF functions
  • IFS
  • Using the IFERROR function
Module 2: Math and statistical functions
  • SUMIF/ SUMIFS
  • COUNTIF/COUNTIFS
  • ROUND
Module 3: Lookup functions
  • VLOOKUP / HLOOKUP
  • XLOOKUP
  • MATCH and INDEX
Module 4: Cell and Range Names
  • Data Validation
  • INDIRECT / UNIQUE / CHOOSECOLS / CHOOSEROWS
  • Advanced filters
  • Using the DSUM, DCOUNT & DAVERAGE functions
Module 5 : PivotTables and Pivot Charts
  • Creating a PivotTable
  • Refreshing PivotTable data
  • Rearranging PivotTables Fields
  • Inserting slicers
  • Formatting PivotTables
  • Calculate values within the PivotTable
  • Creating Pivot Chart

 

Module 6 : Intro to Importing data
  • Importing data from a text file into a workbook
Module 7 : Web and sharing features
  • Insert and edit hyperlinks
Module 8 : Onboard your AI companion to add value in Data analysis process
  • Use Copilot to work out solutions in relation to the above listed themes
Register Here.
Fill in the fields and send your application!