Microsoft Excel (Level 1 to 3)

Designed for beginners and advanced users alike, this transformative program guides you through Excel’s functionalities, from fundamental spreadsheet creation to advanced data visualization and automation. Gain proficiency in formulas, functions, pivot tables, macros, and more, enhancing your efficiency and decision-making prowess. Elevate your Excel skills to expert levels, enabling you to streamline processes and extract valuable insights.

Learning Objectives

  • Basic Navigation: Navigate Excel’s interface with ease, including cells, rows, columns, and sheets.
  • Data Entry and Formatting: Enter and format data, enhancing readability and visual appeal.
  • Basic Formulas and Functions: Learn essential formulas and functions for calculations and data analysis.
  • Cell References: Understand relative, absolute, and mixed cell references to optimize formula efficiency.
  • Charts and Graphs: Create basic charts and graphs to visualize data trends and patterns.
  • Advanced Functions: Master advanced functions like VLOOKUP, HLOOKUP, IF, COUNTIF, and SUMIF for data manipulation.
  • Data Validation: Implement data validation techniques to ensure accurate and consistent data entry.
  • Pivot Tables: Create and customize pivot tables to summarize and analyze large datasets efficiently.
  • Data Sorting and Filtering: Sort and filter data for quick analysis and data extraction.
  • Conditional Formatting: Apply formatting rules based on data conditions, enhancing data visualization.

Who should attend?

Beginners and Intermediate Users, Administrative Professionals, Finance and Accounting Professionals, Project Managers, Data Analysts, Operations Managers

Modes of delivery:

The module shall be delivered by way of:

  • Lectures
  • Demonstrations
  • Video
  • Group presentations
  • Case studies
  • Assignments & Tests
  • Role Play
Back to Course List