Level 1 · Beginner

Excel Kickstart

Basic Excel skills

Start from zero. Move around Excel with confidence, enter and format data, write your first formulas and build a clean table and chart.

40 lessons8 modulesAbout 7 hours

Log in to open this level

Students log in to see their lessons and progress.

What is inside

1Getting around Excel0/5

K-1-1Workbooks, worksheets and cellsComing soon
K-1-2The ribbon, tabs and searchComing soon
K-1-3The Quick Access Toolbar and customising ExcelComing soon
K-1-4Views, zoom and the status barComing soon
K-1-5The Name Box, Formula Bar and moving around fastComing soon

2Creating, saving and sharing0/5

K-2-1Creating a workbook and using templatesComing soon
K-2-2Saving, AutoSave and OneDriveComing soon
K-2-3Version history and recovering lost workComing soon
K-2-4Sharing and co-authoring a workbookComing soon
K-2-5Excel on the web and on your phoneComing soon

3Entering data0/5

K-3-1Text, numbers and datesComing soon
K-3-2AutoFill, the fill handle and Flash FillComing soon
K-3-3Editing, undo, redo and clearing cellsComing soon
K-3-4Find and ReplaceComing soon
K-3-5Keyboard shortcuts that save timeComing soon

4Formatting0/5

K-4-1Fonts, alignment and number formatsComing soon
K-4-2Borders, fills and cell stylesComing soon
K-4-3Wrap text, merge and column widthComing soon
K-4-4Conditional formatting basicsComing soon
K-4-5Format Painter and Paste SpecialComing soon

5Managing worksheets0/5

K-5-1Adding, renaming, moving and copying sheetsComing soon
K-5-2Colouring, grouping and organising tabsComing soon
K-5-3Freezing panesComing soon
K-5-4Hiding and unhiding rows, columns and sheetsComing soon
K-5-5Protecting a worksheetComing soon

6Your first formulas0/5

K-6-1How formulas workComing soon
K-6-2Operators and order of calculationComing soon
K-6-3Relative, absolute and mixed referencesComing soon
K-6-4SUM, AVERAGE, MIN, MAX, COUNT and AutoSumComing soon
K-6-5Reading and fixing error messagesComing soon

7Sorting, filtering and tables0/5

K-7-1Sorting dataComing soon
K-7-2Filtering dataComing soon
K-7-3Removing duplicatesComing soon
K-7-4Creating an Excel TableComing soon
K-7-5Table totals, styles and structured referencesComing soon

8Charts and printing0/5

K-8-1Choosing the right chartComing soon
K-8-2Building your first chartComing soon
K-8-3Formatting a chart so it reads clearlyComing soon
K-8-4Page layout and printingComing soon
K-8-5Project: a household budgetComing soon