Try Excel exercises

Introduction - Intermediate - Advanced

Microsoft Excel is a very comprehensive spreadsheet software package that can be used to maintain business accounts, contact databases and many other features.  Training starts at basic data input, data formatting and simple maths, progressing to data analysis and manipulation.

 

These outlines are guides only.  Any course can be customised to suit

Introduction
The Default Screen
Worksheets/Workbooks
Navigating a Workbook
Entering Data
Selecting Cells
Editing Data
Formatting Cells
AutoSum/Average/Max/Min
Basic Sums
Mathematical Precedence
Copying Data
Using the Auto Fill Feature
Saving a Workbook
Using the Borders Feature
Charting
Formatting Charts
Hiding Columns
Moving Columns/Inserting Columns
Database Filters
Database Sorts/Forms

Intermediate
Basic Formulae
Average function
Maximum function
Minimum function
Basic Scenarios
Sheet Layout and design
Named Cells/Ranges
Absolute Referencing
Basic Pivot Tables
Using 3-D Referencing
Goal Seek
Data Tables
Protection
Linking Workbooks
Using Array Formulae
Attaching Comments to a Cell
Using Outline
Naming Worksheets
Using the Subtotals Feature
Creating Templates
Basic Lookups

Advanced
Customising a Toolbar
Using Solver
IF Statements
Advanced VlookUp and SUMIF
IF And Match
Logical Tests, Error Trapping
Using Form Tools
Data Validation
Advanced Pivot Tables Formulae
Recording Basic Macros
Importing External Data
Using Named Ranges in a Formula
Advanced Database Filters and functions
Advanced Scenarios
Investment Rate of Return Functions
Using Text Functions, Left, Right, Mid, Large, Small
Using Forecast and Frequency functions