Course Overview

Microsoft Excel – Basic to Intermediate Level: Learn essential Excel skills for data entry, calculations, reporting, and efficient business operations. Employees across all departments are expected to organize information efficiently, produce accurate reports, and manage data professionally.

This practical 2-day course is designed for beginners and junior users who want to build strong foundational and intermediate Excel skills for daily office work. Participants will learn through hands-on exercises, realistic workplace examples, and guided activities that focus on productivity and reporting efficiency.

This program also serves as the foundation pathway for participants who wish to continue into the “Microsoft Excel – Intermediate to Advanced Level” course.

Course Objectives

By the end of Microsoft Excel – Basic to Intermediate Level course, participants will be able to:

• Navigate and use Excel confidently
• Create and manage professional worksheets
• Apply formulas and functions accurately
• Organize and manage business data efficiently
• Use sorting, filtering, and validation tools
• Create charts and simple reports
• Analyze data using basic PivotTables
• Improve daily productivity using Excel tools
• Prepare structured data for advanced reporting

Suggested Software:   Microsoft Excel 2019 / 2021 / Microsoft 365

Course Content

DAY 1 – Excel Fundamentals & Data Handling

Module 1: Introduction to Microsoft Excel

• Understanding the Excel interface
• Navigating worksheets and workbooks
• Creating, saving, and managing files
• Understanding rows, columns, cells, and ranges
• Excel best practices for office work

Module 2: Data Entry & Worksheet Formatting

• Efficient data entry techniques
• AutoFill and Flash Fill
• Formatting text, numbers, and dates
• Applying borders, colors, and styles
• Using Format Painter
• Creating professional worksheets

Module 3: Essential Formulas & Functions

• Formula basics and calculations
• Relative and Absolute Cell References
• Mathematical Functions:
  • SUM
  • AVERAGE
  • MIN / MAX
  • COUNT
• Logical Function:
  • IF
• Text Functions:
  • LEFT
  • RIGHT
  • CONCAT
  • TRIM
• Date Functions:
  • TODAY
  • NOW

Module 4: Organizing and Managing Data

• Sorting and filtering data
• Creating and managing Tables
• Removing duplicates
• Data validation
• Creating drop-down lists
• Freeze Panes and worksheet viewing tools

Module 5: Charts & Visual Reporting

• Understanding chart types
• Creating:
  • Column charts
  • Bar charts
  • Pie charts
  • Line charts
• Formatting charts professionally
• Introduction to visual reporting

DAY 2 – Intermediate Reporting & Data Analysis

Module 6: Intermediate Functions

• COUNTIF / SUMIF
• COUNTIFS / SUMIFS
• IFERROR
• Basic VLOOKUP
• Combining formulas efficiently
• Formula troubleshooting basics

Module 7: PivotTables & PivotCharts

• Understanding PivotTables
• Creating PivotTables from raw data
• Sorting and filtering PivotTables
• Basic grouping and summarizing
• Creating PivotCharts
• Introduction to slicers

Module 8: Workbook Productivity Techniques

• Worksheet protection
• Essential keyboard shortcuts
• Quick Analysis tools