Microsoft Excel Training for Beginners

Lesson 1 • Creating and Saving Files

Teaches file creation, saving formats, and AutoRecover settings. Proper file management prevents data loss from the first session onward.

Lesson 2 • Customising the Excel Environment

Adjusts display options and toolbar shortcuts to match personal workflow. A tailored environment improves speed and reduces fatigue.

Lesson 3 • Understanding the Excel Interface

Identifies every major screen element and its purpose. Establishes spatial awareness needed for all subsequent tasks.

Lesson 1 • Working with Rows, Columns, and Cells

Teaches inserting, deleting, resizing, and hiding structural elements. Proper structure keeps datasets readable and formula references intact.

Lesson 2 • Using AutoFill and Flash Fill

Automates repetitive entry using fill handles and pattern recognition. These tools dramatically cut manual input time for series and formatted data.

Lesson 3 • Selecting and Moving Data

Demonstrates range selection techniques and cut, copy, paste operations. Efficient data movement speeds up dataset construction and reorganisation.

Lesson 4 • Typing and Editing Cell Content

Covers entering text, numbers, and dates, plus in-cell editing shortcuts. Accurate entry is the foundation of every reliable spreadsheet.

Lesson 1 • Formatting Text and Numbers

Controls font, size, colour, and number display formats. Consistent formatting signals professionalism and aids data interpretation.

Lesson 2 • Using Cell Styles and Themes

Applies built-in styles and document themes for consistent design. Themes ensure uniform colour and font choices across an entire workbook.

Lesson 3 • Aligning and Wrapping Cell Content

Sets horizontal, vertical, and wrap alignment for readability. Proper alignment prevents truncated text and misread values.

Lesson 4 • Conditional Formatting Basics

Highlights cells automatically based on value rules and data bars. Visual cues let readers spot trends and outliers without manual scanning.

Lesson 1 • Absolute, Relative, and Mixed References

Distinguishes how cell references behave when copied across ranges. Correct reference types are essential for scalable, reusable formulas.

Lesson 2 • Logical Functions and Conditionals

Builds decision logic with IF, AND, OR, and nested conditions. Conditional formulas let spreadsheets respond dynamically to changing data.

Lesson 3 • Text Functions for Data Cleanup

Uses TRIM, UPPER, LOWER, CONCATENATE, and LEFT/RIGHT/MID. Clean text data is a prerequisite for accurate lookups and reporting.

Lesson 4 • Understanding Formula Syntax

Explains operators, operand order, and how Excel evaluates expressions. A solid syntax foundation prevents the most common formula errors.

Lesson 1 • Using HLOOKUP for Horizontal Data

Applies HLOOKUP to tables organised in rows rather than columns. Understanding both orientations prepares students for varied data layouts.

Lesson 2 • Named Ranges and Structured References

Creates named ranges and uses table-structured references in formulas. Named references make formulas self-documenting and easier to audit.

Lesson 3 • Introduction to VLOOKUP

Explains VLOOKUP syntax, arguments, and exact vs. approximate match. VLOOKUP is the most widely used lookup tool in business spreadsheets.

Lesson 4 • XLOOKUP for Modern Workbooks

Introduces XLOOKUP as a unified replacement for VLOOKUP and HLOOKUP. Its simpler syntax and default exact match reduce common lookup mistakes.

Lesson 1 • Advanced Filter Techniques

Uses criteria ranges and unique-record extraction for complex filtering. Advanced filters handle multi-condition logic beyond AutoFilter's menus.

Lesson 2 • Data Validation Rules

Restricts cell input to defined lists, ranges, or formats. Validation prevents entry errors before they corrupt downstream calculations.

Lesson 3 • Filtering with AutoFilter

Enables AutoFilter to display only rows matching selected criteria. Filtering lets users focus on relevant records without deleting any data.

Lesson 4 • Sorting Data Effectively

Applies single-level and multi-level sorts to rows and columns. Correct sort order is the first step in making large datasets readable.

Lesson 1 • Sparklines and Conditional Chart Elements

Embeds miniature sparkline charts inside cells for inline trend display. Sparklines add analytical depth without consuming extra worksheet space.

Lesson 2 • Formatting Chart Elements

Customises titles, axes, legends, gridlines, and data labels. Well-labelled charts require no verbal explanation to convey their message.

Lesson 3 • Applying Chart Styles and Colours

Uses built-in styles and manual colour overrides for visual consistency. Consistent colour schemes reinforce brand identity in workplace reports.

Lesson 4 • Inserting and Editing Charts

Walks through chart creation from a data selection to a finished object. Editing source data and chart placement are core production skills.

Lesson 1 • Summarising Data with Value Fields

Changes summary functions and adds calculated fields for custom metrics. Flexible aggregation lets one dataset answer many different business questions.

Lesson 2 • Building Your First PivotTable

Creates a PivotTable from a structured dataset and explores the field list. Understanding the layout pane is the gateway to all PivotTable analysis.

Lesson 3 • Slicers and Timelines for Interactivity

Adds slicers and timeline controls for one-click PivotTable filtering. Interactive controls make reports usable by colleagues with no Excel expertise.

Lesson 4 • Grouping and Filtering PivotTable Data

Groups dates, numbers, and text items and applies report filters. Grouping reveals patterns at different levels of granularity within the same table.