top of page

Data Analysis Using Microsoft Excel

The Microsoft Excel Intermediate Courses are designed to help individuals work more efficiently and effectively in Excel. Participants will learn to better organize, analyze, and present data using complex formulas, a wide range of functions, dynamic charts, and reports. The course also covers pivot tables, conditional formatting, defined names, data validation, and What-If Analysis Tools, including one-variable and two-variable data tables, and the scenario manager. Upon completion, attendees will have mastered key Excel techniques and become highly productive assets to their organizations, resulting in improved efficiency.

Logo HRDF Claimable.png

Targeted Groups:

This course was designed to fit everyone including: 

  • Individuals with a basic understanding of Excel

  • Individuals who want to learn how to utilize Excel's in-built features

  • Business professionals

  • Data analysts

  • Researchers

  • Students

Logo HRDF Claimable.png

Course Objectives:

This course was designed to let the participants able:

  • To learn how to create and modify complex formulas to analyze data

  • To understand how to use Excel functions to manipulate and analyze data

  • To learn how to create charts and graphs to visually represent data

  • To understand how to use pivot tables to summarize and analyze large data sets

  • To learn how to use conditional formatting and data validation to ensure data accuracy and consistency

  • To understand how to use Excel's What-If Analysis Tools to perform sensitivity analysis and scenario planning

  • To gain proficiency in Excel and be able to use it effectively in data analysis tasks

  • To increase productivity and efficiency by using Excel's in-built features effectively

Course Contents

Unit 1: Introduction

  • What is Microsoft Excel?

  • What is Data Analysis

  • Understanding the interface

  • Navigation and basic formatting

  • Designing Better Spreadsheets


Unit 2: Advanced Excel Formulas and Functions

  • Logical Functions

  • LOOKUP Functions

  • Working with Date and Time


Unit 3: Data Organization and Management

  • Advanced Sorting and Filtering

  • Tables and table formatting

  • Data validation and cleaning

Unit 4: Pivot Tables and Charts

  • Creating and manipulating pivot tables

  • Pivot table analysis

  • Pivot Chart creation and customization


Unit 5: Advanced Data Analysis Tools

  • What-If Analysis Tools

  • Solver Tool

  • Data Analysis ToolPak


Unit 6: Visualizing Data with Excel

  • Creating custom visuals

  • Data visualization best practices

  • Interactive dashboards and reporting


Unit 7: Collaborating with Excel

  • Sharing workbooks

  • Co-authoring and version control

  • Protecting data and workbook security


Unit 8: Real World Applications and Case Studies

  • Real-world data analysis problems

  • Case studies and application examples

  • Project-based assessment and evaluation

bottom of page