This module introduces the basic use of Excel spreadsheets and fundamental data functions. Students learn to read data into Excel using various formats (comma-delimited, tab-delimited, fixed-width), perform basic data manipulation, and use arithmetic operations in Excel. The module covers essential Excel functions, formatting techniques for rows and columns, and using formulas with absolute and relative cell referencing. This foundation module prepares students for more advanced Excel functionality in subsequent modules.

This module introduces more advanced Excel functions for organizing and querying data. Students learn to use the IF function for conditional logic, nested IF statements for handling multiple conditions, and lookup functions (VLOOKUP and HLOOKUP) to search for and retrieve data from tables. The module also covers the RANDBETWEEN function for generating random numbers within a specified range. These functions significantly enhance a user's ability to manipulate and organize data efficiently in Excel.

This module focuses on Excel's data filtering capabilities, the construction of Pivot Tables for data organization, and an introduction to charts. Students learn to use VLOOKUP across different worksheets, apply filters to selectively access data, and create Pivot Tables with both categorical and numerical data. The module concludes with an introduction to Excel's charting capabilities, preparing students for more advanced visualization techniques in the next module.

This final module explores various advanced graphing and charting techniques available in Excel. Students learn to construct different types of visualizations including line graphs, bar graphs, pie charts, and pivot charts. The module also covers scatter plots for examining relationships between variables and histograms for frequency distribution analysis. Through practical examples, students gain hands-on experience in selecting and creating appropriate visualizations for different types of data and analytical needs.