(Microsoft Excel Advanced with Copilot as a productivity companion)

This course is designed to empower participants to collaborate effectively, extract relevant data from their database, and conduct efficient analyses. Additionally, it is designed to assist participants in protecting their documents and making accurate data forecasts with ease while unlocking productivity with your AI companion.

  • Type

    Face to Face

  • Date

    25 - 29 August 2025

  • Price

    Rs 20,000

Content
Module 1 : Logical functions
  • IF function
  • OR AND as nested functions
  • Nested IF
  • IFS
Module 2: Documenting and auditing
  • Use auditing features
  • Protect a worksheet or part of a worksheet
  • Share, merge, and track changes in a workbook
  • Co-authoring and versioning
Module 3: Templates and settings
  • Work with Excel templates
  • Create and manage templates
Module 4: What-If Analysis
  • Goal Seek Tool
  • Solver Addins
  • Scenarios
Module 5 : Financial functions
  •  PMT / PPMT / IPMT
Module 6 : Lookup functions
  • Filter / Sort / Sortby
  • Vstack
Module 7 : Introduction to PivotTables
  • Creating a PivotTable
  • Refreshing PivotTable data
  • Rearranging PivotTables Fields
  • Formatting PivotTables
Module 8 : Unlock productivity with your AI companion
  • Use Copilot to work out solutions in relation to the above listed themes
Register Here.
Fill in the fields and send your application!