Courses My learning

Excel Kickstart

Getting around Excel

Workbooks, worksheets and cells
The ribbon, tabs and search
The Quick Access Toolbar and customising Excel
Views, zoom and the status bar
The Name Box, Formula Bar and moving around fast

Creating, saving and sharing

Creating a workbook and using templates
Saving, AutoSave and OneDrive
Version history and recovering lost work
Sharing and co-authoring a workbook
Excel on the web and on your phone

Entering data

Text, numbers and dates
AutoFill, the fill handle and Flash Fill
Editing, undo, redo and clearing cells
Find and Replace
Keyboard shortcuts that save time

Formatting

Fonts, alignment and number formats
Borders, fills and cell styles
Wrap text, merge and column width
Conditional formatting basics
Format Painter and Paste Special

Managing worksheets

Adding, renaming, moving and copying sheets
Colouring, grouping and organising tabs
Freezing panes
Hiding and unhiding rows, columns and sheets
Protecting a worksheet

Your first formulas

How formulas work
Operators and order of calculation
Relative, absolute and mixed references
SUM, AVERAGE, MIN, MAX, COUNT and AutoSum
Reading and fixing error messages

Sorting, filtering and tables

Sorting data
Filtering data
Removing duplicates
Creating an Excel Table
Table totals, styles and structured references

Charts and printing

Choosing the right chart
Building your first chart
Formatting a chart so it reads clearly
Page layout and printing
Project: a household budget

K-7-4 · Sorting, filtering and tables

8 min

Creating an Excel Table

Log in to open this lesson

Students log in to see their lessons and progress.

Email or username

Password

Remember Me

© 2026 Excel at Excel