Microsoft Excel

Introduction - 1 Day

• What Is A Spreadsheet ?

• Entering / Formatting Data
• Opening / Saving Workbooks

• Copying / Pasting Data
• Increasing Column Width / Row Height

• Automatic / Keyboard Shortcuts
• AutoFill / AutoCorrect / AutoComplete

• Simple Formulae / Calculations
• Creating Graphs / Charts

• Printing Worksheets
• Cell Comments

Microsoft Excel

Intermediate - 1 Day

• Building Formulae

• Relative And Absolute References
• Splitting / Combining Cell Content

• Copying / Linking Worksheets & Workbooks
• IF / COUNTIF / VLOOKUP Functions

• Conditional Formatting - Basics
• Freeze Panes / Split Screen

• Sorting / Filtering Data
• Creating Pivot Tables

• Protecting Cells / Sheets
• Creating Nested Formulae

• Creating Combination Charts

Microsoft Excel

Advanced - 1 Day

• Named Ranges

• Advanced Sorting / Filtering Data
• Creating Complex Nested Formulae

• Data Validation
• SUMIF / DSUM / INDEX / MATCH Functions

• Conditional Formatting - Advanced
• Using Date Functions / Formulae

• Customising Ribbon / Tabs

• Pivot Tables - Advanced

• Macros – Creating / Modifying / VBA

Microsoft Excel

Excel VBA : User - 1 Day

• Introducing Visual Basic for Applications

• Recording / Running a Macro
• Editing a Macro in the Visual Basic Editor

• Creating a Standard Module
• Creating a Sub Procedure

• Declaring Variables
• Understanding Data Types

• Using Message Boxes
• Using Input Boxes

• Using the If...End If Decision Structures

• Using the Select Case Structure
• Using the Do...Loop Structure

• Using the For...Next Structure
• Error Trapping / Break Points

• Stepping Through a Procedure

Microsoft Excel

Excel VBA Professional - 1 Day

• Creating / Designing User Forms

• Filling UserForm Controls
• Filling a ListBox / ComboBox

• Validating User Inputs
• Option Buttons / Checkboxes

• Multi-Page Control
• Using Calendar Controls

• Passing Form Values Into Excel
• Creating Run Time Events

• Automatically Running Code
• Creating User Defined Functions

• Exchange Data With External Applications

Ideally, this course would allow time for the Users to develop their own Code, in a Spreadsheet, which they bring along to the training day.