Excel Course Overview - Stage 1

Course Overview

This course consists of a series of hands on activities to enhance the use of Microsoft Excel. It provides an Introduction to the commands and their use. By the end of the Course users will be confident in using Excel to produce spreadsheets using basic ‘what if’ calculations, be familiar with relative and absolute addressing and be able to link Worksheets.

 Course Outline

Getting Started
Terms
Starting Excel
Using the Menus
Moving around 

Linking
Linking Sheets
Linking Workbooks
Summary Sheets

Formulae
Adding Values
Using Operators
Basic Functions
Function Wizard
Relative and Absolute Addressing
Naming Ranges
What if Calculations

Database Utilities
Sorting
Criteria for selection
Sub Totals
Outlines

Formatting
Adjusting Column Widths
Changing Row Heights
Inserting and deleting Rows/Columns/Sheets
Using the Format Painter

 

Customising Excel
Change Defaults and Settings
Customising Excel start-up

Page Layout
Headers and Footers
Switch Between Different Views
Alter Margin Settings
Paper Size and Orientation 

 Charts
Chart Types
Creating a graph
Chart Wizard

 Who Should Attend

This course is intended for the user who has a basic understanding of Windows and are familiar with the basic functions of Excel.

 Duration

2 Days                9.30 - 4.45 with one for lunch.

 

Excel Course Overview - Stage 2

Course Overview

This course is suitable for delegates who wish to be able to use the more advanced features of Excel effectively. It covers features such as Pivot Tables, Customising, Outlining, Statistical Analysis and 3D spreadsheets.

Custom Lists
Setting up a Custom List
Using the Fill Command to enter a commonly used list

Styles
Creating Styles
Using Styles from the Toolbar

Functions using the Function Wizard
What functions are available?
How to select and use functions

Templates
Creating and Using Templates

Relative and Absolute Addresses
Formulae change relative to where they are
How to Fix the cell reference to only read from one cell or one row/column

Conditional Formatting
Changing the font or background colour according to set conditions

Grouping and Linking Sheets/Books
Grouping sheets together for quick input of labels and formulae
Reading values from one sheet to another or one book to another

Naming Ranges
Why give cells names
How to give cells names
Natural Language referencing

Database Utilities
Sorting, filtering, group totals

Pivot Tables
Why use a pivot table
How to create a pivot table
How to change a Pivot table

Lookup and If Functions
Use of the If function
Horizontal and Vertical lookup tables

 

 

 Who Should Attend

This course is intended for the user who has a basic understanding of Windows but is not familiar with Microsoft Access.

 Duration

2 Days                        9.30 - 4.45 with one for lunch.

Back to Top