(Microsoft Excel Intermediate with Copilot as an efficiency booster)

This course will enable participants to link worksheets and consolidate data from multiple worksheets coupled with various formatting options as well as representing their data visually through different charts. This course is also designed to help participants gain in efficiency with their AI companion.

  • Type

    Face to Face

  • Date

    07 to 11 July 2025

  • Price

    Rs 20,000

Content
Module 1 : Using functions
  • Entering a SUM function
  • Using AVERAGE
  • Using fixed and mixed references
  • Using COUNT and COUNTA
  • Date & Time Functions
    • Date and time calculation
    • TODAY
    • YEAR
    • NETWORKDAYS / NETWORKDAYS.INTL
Module 2: Using multiple worksheets and workbooks
  • Link worksheets by using 3-D formulas
  • Create and manage links between workbooks
  • Consolidating data between worksheets and workbooks
Module 3: Lookup functions
  • Date and time formatting
  • Conditional Formatting
  • Use functions to split and format text
    • Upper / Lower / Proper
    • Concat / Textjoin
    • Left / Right / Mid
  • Use text to columns
    • Textsplit
  • Removing Duplicates
Module 4: Cell and Range Names
  • Define and apply cell and range names
  • Use names in formulas
  • Managing names
Module 5 : Advanced charting
  • Creating Charts
  • Recommended Charts
  • Format data points in charts
  • Create combination charts and trendlines
  • Insert sparklines
  • Add and format graphical elements
Module 6 : Gain in efficiency 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!