Computer Excel Course

Lesson 1 • Entering and Editing Data

Teaches text, number, and date entry plus in-cell editing techniques. Accurate data entry is the prerequisite for every formula and analysis chapter.

Lesson 2 • Navigating Cells and Ranges

Covers keyboard shortcuts and mouse techniques for moving through large grids. Efficient navigation reduces data-entry time throughout the course.

Lesson 3 • The Excel Interface Overview

Identifies every major UI element: ribbon, formula bar, sheet tabs, and status bar. Establishes spatial awareness needed for all subsequent tasks.

Lesson 4 • Workbooks, Worksheets, and Files

Explains the relationship between workbooks and worksheets and covers file formats. Students can create, save, and reopen files in appropriate formats.

Lesson 1 • Row, Column, and Sheet Management

Covers resizing, hiding, inserting, and deleting rows, columns, and sheets. Structural control is essential before building multi-sheet workbooks.

Lesson 2 • Font, Alignment, and Cell Styles

Controls font properties, text alignment, and built-in cell styles for visual hierarchy. Consistent styling makes worksheets easier to read and audit.

Lesson 3 • Number and Date Formatting

Applies built-in and custom number formats to display values correctly. Proper formatting prevents misreading of financial and date data.

Lesson 4 • Conditional Formatting Basics

Highlights cells automatically based on value rules, colour scales, and data bars. Visual cues speed up data review and are built upon in later analysis chapters.

Lesson 1 • Date and Time Functions

Calculates durations, extracts date parts, and works with time values. Date functions support scheduling, aging analysis, and deadline tracking.

Lesson 2 • Text Functions

Manipulates string data with LEFT, RIGHT, MID, LEN, TRIM, and related functions. Text functions are critical for cleaning imported data.

Lesson 3 • Essential Math and Statistical Functions

Covers SUM, AVERAGE, MIN, MAX, COUNT, and ROUND for everyday calculations. These functions appear in virtually every professional spreadsheet.

Lesson 4 • Formula Syntax and Operators

Explains the equal-sign rule, operator precedence, and parentheses usage. A solid syntax foundation prevents the most common formula errors.

Lesson 5 • Logical Functions

Builds decision-making formulas using IF, AND, OR, and NOT. Logical functions enable automated categorisation and conditional calculations.

Lesson 1 • Sorting Data Effectively

Performs single-level and multi-level sorts by value, colour, or custom list. Correct sorting is a prerequisite for reliable filtering and reporting.

Lesson 2 • Filtering and Advanced Filtering

Uses AutoFilter and Advanced Filter to isolate relevant records quickly. Filtering skills directly support the pivot table and dashboard chapters.

Lesson 3 • Importing and Cleaning External Data

Brings data from CSV and text files into Excel and applies cleaning techniques. Clean imports reduce manual correction time in every real-world project.

Lesson 4 • Creating and Managing Excel Tables

Converts ranges to Tables and explores automatic features like structured references. Tables are the recommended foundation for all data analysis work.

Lesson 1 • Dynamic Arrays and Spill Functions

Covers FILTER, SORT, UNIQUE, and SEQUENCE as modern array-based alternatives. Dynamic arrays reduce formula complexity and eliminate helper columns.

Lesson 2 • XLOOKUP and XMATCH

Introduces the modern XLOOKUP and XMATCH functions with simplified syntax and new capabilities. Students choose the right lookup tool for each scenario.

Lesson 3 • VLOOKUP and HLOOKUP

Explains vertical and horizontal lookup syntax, match types, and common pitfalls. These functions remain widely used in legacy workbooks professionals must maintain.

Lesson 4 • COUNTIF, SUMIF, and AVERAGEIF

Aggregates data conditionally based on one or multiple criteria. These functions bridge lookup skills and the pivot table analysis covered next.

Lesson 1 • Sparklines and In-Cell Visuals

Embeds miniature sparkline charts inside cells for compact trend display. Sparklines complement full charts in dashboards and summary tables.

Lesson 2 • Choosing the Right Chart Type

Maps common business questions to appropriate chart types using selection principles. Choosing the wrong chart type is the most frequent visualisation mistake.

Lesson 3 • Advanced Chart Techniques

Builds waterfall, funnel, and histogram charts and adds dynamic chart titles. Advanced types handle specialised business reporting needs not covered by basic charts.

Lesson 4 • Formatting Charts Professionally

Applies titles, labels, legends, gridlines, and colour schemes for publication quality. Consistent formatting builds credibility in reports and presentations.

Lesson 1 • PivotTable Design and Layout

Applies report layouts, styles, subtotals, and grand total options for polished output. Professional layout choices make PivotTable reports presentation-ready.

Lesson 2 • Building Your First PivotTable

Walks through inserting a PivotTable, placing fields, and reading the output. A clear mental model of rows, columns, values, and filters is established here.

Lesson 3 • Summarising and Grouping Data

Changes summary functions, groups dates and numbers, and adds calculated fields. Grouping transforms raw records into meaningful time-series or range summaries.

Lesson 4 • PivotCharts and Visual Analysis

Creates PivotCharts linked to PivotTables and customises chart type and style. Visual summaries communicate findings faster than tables in most business contexts.

Lesson 1 • What-If Analysis Tools

Uses Goal Seek, Scenario Manager, and Data Tables to model business outcomes. What-If tools turn static spreadsheets into interactive decision-support models.

Lesson 2 • Workbook Protection and Security

Locks cells, protects sheets, and encrypts workbooks to control access and editing. Security measures are mandatory before sharing workbooks with external stakeholders.

Lesson 3 • Introduction to Power Query

Connects to data sources, transforms data, and loads clean results into Excel. Power Query automates repetitive data preparation tasks that previously required manual effort.

Lesson 4 • Building Interactive Dashboards

Combines PivotTables, charts, slicers, and named ranges into a single-screen dashboard. Students deliver a complete, interactive reporting tool as a capstone project.