Microsoft Excel training tailored to you

The Basics

The Excel Interface
Using Backstage View
Understanding the Ribbon
Using & customising the Quick Access toolbar

Organise Your Workbooks

Creating, saving & opening a new Workbook
Entering numbers, text & dates in a Workbook
Deleting Cell Contents
Quickly sorting data
Adding, deleting & naming sheets

Layout of Spreadsheets

Inserting Columns & Rows
Deleting Columns & Rows
AutoFill
Using Cut, Copy & Paste
Using Undo & Redo

Defining & Creating Calculations

Writing a basic formula
Understanding the order of BODMAS
The Sum function & AutoSum
Creating statistical functions (Average, Max and Min)
Working with Relative References when Copying Formulas

Presenting Your Data

Font formatting
Borders & Shading
Number formatting (currency etc)
Alignment options
Clearing formats

Printing Worksheets

Setting page margins & page orientation
Creating a Header & Footer
Printing all or part of a worksheet
Setting Print Titles for large Worksheets

Visual Representations of Your Data

Creating a chart
Changing the Chart Type
Basic Formatting of Charts

Learning outcomes