Excel Level 1 - Introduction

Microsoft Excel is one of the most powerful tools for data management, reporting, and calculations, but getting started can feel overwhelming.

​

This beginner Excel course is designed for those who are new to Excel or need a refresher on the basics.

​​

Learn the secrets of being a great Excel user, banish your nerves and finish tasks more quickly.

​

Understanding the Excel Interface & Navigation

• What is Excel?

• Opening, saving and navigating between worksheets and workbooks

• Zooming in to the right distance every time - no more squinting at tiny numbers!

• Ribbon, formula bar, adding and removing columns and rows

• Customising the Quick Access Toolbar

 

Entering and Managing Data

• Typing, editing and clearing data in cells

• Selecting multiple cells, entire rows and entire columns

• Speed up data entry and creating formulas with Autofill and the Fill Handle

• Separate, join and edit data quickly using Flash Fill (one of the most powerful features in Excel!)

• Using Cut, Copy, and the different options for Pasting data

 

Performing Essential Calculations

• Writing simple formulas using basic mathematical operators (plus, minus, divide, multiply)

• Using cell references to make your formulas easy, dynamic and error-free

• Essential formulas - SUM, AVERAGE, MIN, MAX, and counting functions

• Percentage calculations in Excel (increase, decrease, finding percentages)

• Understanding common formula errors and how to fix them

 

Formatting & Organising Data

• Applying number formatting (currency, percentages, dates, etc.) and why it's important

• How to quickly and easily clear formatting, data and hyperlinks

• Adjusting column widths, row heights, and cell alignment

• Using conditional formatting to highlight important data

 

Working with Lists & Tables

• Sorting and filtering data effectively

• Creating Excel Tables for better data management

• Applying custom sorts and using subtotals

 

Data Visualisation Fundamentals

• Creating and customising basic charts (column, bar, line, pie)

• When to use different charts depending on your data

• Modifying chart elements (titles, labels, legends, colours)

 

Finalising Worksheets & Printing

• Spell check and Find & Replace to polish your worksheets

• Adjusting page layout and print settings for professional-looking spreadsheets

• Setting print areas and using headers & footers

• Print Excel worksheets without the headaches and stress!