This training is suitable for anyone who has undergone Excel Intro training or who is a regular user of Excel to give them a more in-depth knowledge of the software.

Course Content & Aims

Overview of the Basics
The File Tab / Options
The Ribbon / The Quick Access Toolbar
Quick Analysis Tool
Flash Fill
Using Multi Sheets
Linking the Sheets
3D Data Entry / 3D Formula
Using Multiple Windows / Linking Files
Link and Pasting to other Applications
Formula
IF Statements / IF AND OR Statements (nested)
VLOOKUP / HLOOKUP / INDEX
In Linked Files / Using with Named Ranges
Data Handling
UPPER / LOWER / PROPER / CONCATENATE
LEFT / RIGHT / MID / LEN
Date & Time Calculations
Using Named Ranges in Formula
Goal Seek / The Scenario Manager
Text to Columns / Fixed Width Entries / Delimited
Sorting a Table / Sort Keys / Sorting Left to Right
Using AutoFilter / Advanced Filter
Creating Subtotals
Pivot Table Reports / Recommended Pivot Table
Pivot Table Drop Down Menu / Pivot Table Formula / Charts / Reports.
Validation Rules / Creating Drop down lists
Creating and Customising the Toolbars / Custom Menus
Intro to MSQuery
Introduction to Hyperlinks
Introduction to Macros
Macro Recorder
Macro Button / Embedded Button / Macro Tab
Adding to Toolbar
Viewing the VB Code

Assessment & Qualification

A certificate of attendance will be issued.