IT Training

Microsoft Excel Basic

  • Duration: 1 day
  • Maximum group size: 6-8 people

Course overview

Delegates will learn the Excel basics: It will allow you to be able to perform basic calculations with confidence using formulas, be able to navigate around Excel much quicker and learn the shortcuts. It will show you how to create and format professional spreadsheets, build simple formulas, calculate totals and lots more.

Topics covered


  • Starting Excel
  • What’s new in Excel
  • Understanding the Excel screen
  • Giving commands and using command shortcuts
  • Creating workbooks
  • Opening a workbook
  • Previewing and printing a worksheet
  • Saving workbooks
  • Closing a workbook
  • Using help
  • Exiting a workbook

Editing a worksheet

  • Editing cell contents
  • Copying and moving cells
  • Controlling how cells are moved or copied
  • Collecting items to move or copy
  • Checking spelling
  • Inserting cells, rows, and columns
  • Deleting cells, rows, and columns
  • Using undo and redo
  • Finding and replacing content
  • Adding comments to cells
  • Tracking changes

Getting started with worksheets

  • Navigating worksheets
  • Entering labels and values
  • Selecting a cell range and entering data in a cell range
  • Overview of Formulas and cell references
  • Entering formulas including Sum, Average & Count
  • Entering content automatically
  • Referencing external data
  • Freeze Panes
  • Absolute Cell References

Formatting a worksheet

  • Formatting Text
  • Formatting Values
  • Adjusting Row Height and Column Width
  • Working with Cell Alignment
  • Adding Cell Borders and Background Colours
  • Copying Formatting
  • Applying and Removing Cell Styles
  • Creating and Modifying Cell Styles
  • Using Document Themes
  • Applying Conditional Formatting
  • Creating and Managing Conditional Formatting Rules
  • Finding and Replacing Formatting

Delivery methodology

(Face-to-face or virtual delivery available)

Small groups

Ideally 6-8 delegates to maximise engagement and interaction levels.


We also provide one-to-one 90 minute support workshops to provide targeted individual support (specific topics to be selected).

Tailored sessions

Talk to us about designing bespoke workshops for your team

Course guide

Download our training course guide and find out more.

Book this course

Call Us: +44 (0)1623 409 824
Email Us: