Get familiar with the Excel 2019 environment and the features that make spreadsheet work more organised and efficient. This provides a starting point before moving into everyday Excel tasks.

Learn your way around workbooks, worksheets, rows, columns, cells, the Ribbon, Name Box, and Formula Bar. You will also practise entering and managing basic spreadsheet information.

Turn Excel into a useful calculation tool by working with formulas, mathematical operators, and cell references. The focus is on building confidence with calculations rather than relying on manual working.

Discover how to edit worksheet content, adjust rows and columns, move information, and make changes efficiently. These basic editing skills are useful in almost every Excel task.

Make spreadsheet information easier to read and understand through appropriate formatting. You will explore fonts, alignment, borders, number formats, and other worksheet presentation options.

Learn how to prepare spreadsheets for printing and control how information appears on the page. Topics include print settings, page layout, and preparing worksheets for clearer output.

Build better file-management habits by working with Excel workbooks and their different components. You will learn how to save, organise, and manage spreadsheet files effectively.

Go beyond basic calculations by using Excel functions to work with information more efficiently. Common functions can help automate calculations and reduce repetitive manual work.

Learn how Excel can be used to organise lists and structured information. The section introduces techniques that make larger sets of records easier to manage and work with.

Explore Excel tools that can help you identify useful information within a dataset. Learners develop an understanding of sorting, filtering, and other approaches to reviewing spreadsheet data.

Charts can make numbers easier to understand at a glance. You will learn how to create and work with charts to present spreadsheet information in a clearer visual format.

Discover how PivotTables can summarise larger amounts of information and make patterns easier to examine. PivotCharts extend this by presenting summaries visually.

Learn how to work across different worksheets and workbooks without losing track of information. This is particularly useful when managing related datasets or larger projects.

Develop your spreadsheet skills by exploring lookup functions and tools for checking formulas. These features can help you retrieve information and identify potential formula problems.

Understand ways to share Excel files while maintaining better control over their contents. Workbook and worksheet protection features can help prevent unwanted changes to important information.

Explore ways to reduce repetitive spreadsheet tasks and make workbook processes more efficient. The section introduces automation concepts that can save time when working with recurring tasks.

Use sparklines to show quick trends within cells and explore mapping features for presenting location-based information. These tools add alternative ways to communicate data.

Learn how Excel can be used to examine patterns and make forecasts from existing information. This provides an introduction to using spreadsheet data for forward-looking analysis.

Finish by exploring templates that can provide ready-made structures for common spreadsheet tasks. Using templates can help save time and provide a consistent starting point for new workbooks.