Overview
Excel Training Course Content
- The Basics In Excel
- Excel basics and interface overview
- Navigate worksheets and workbooks
- Essential Excel keyboard shortcuts
- Select cells, rows, columns and ranges
- Data in Excel
- Enter text, numbers and dates in Excel
- Edit, copy, move and update cell contents
- Use AutoFill and Flash Fill
- Find and Replace data
- Proofread worksheets
- Insert and delete rows, columns and cells
- Beginner Excel Formulas
- Creating simple formulas
- Understanding cell references
- Using SUM and other Beginner functions
- Overview of how formulas work
- How to use the formula bar
- Formatting Worksheets
- How to apply number formats
- Applying a theme
- Formatting characters and cells
- Cell borders
- Working with Rows, Columns and Sheets
- Adjust column widths and row heights
- Managing worksheets
- Add worksheet backgrounds
- Freeze panes for easier navigation
- Split windows for more efficient views
- Organising Data
- Sorting data
- Creating simple data lists
- Grouping rows and columns
- Creating outlines
- Hiding rows, columns and gridlines
- Printing and Page Layout
- Configure page layout settings
- Use Print Preview
- Print Excel worksheets efficiently
- Set print areas
- Insert page breaks
- Repeat row and column headings
- Create headers and footers
- Working Efficiently
- Display zoom option
- Using Excel Help
- Productivity tips and shortcuts
- Best practices for building clean spreadsheets
FREE
Beginners
Digital Skills & Photography
It’s suitable for complete beginners who want to start with the basics, as well as learners with some existing experience who wish to progress to intermediate or advanced levels
You should be able to turn a computer on and off, be able to use a mouse and keyboard, everything else we will teach you.
Age 19 +
Basic IT skills – be able to turn a computer on and off, be able to use a mouse and keyboard, everything else we will teach you.
Start Date: 09 October 2026
Time: 9:30am - 3:30pm
Day: Thursday and Friday
Duration: 1 Week
Billingham Community Centre
The Causeway, Billingham
TS23 2DA
You could progress onto another one of our digital skills courses including Intermediate Excel, or Functional Skills ICT

