The course is given by Stephen Custance-Baker who has many years of experience in the use of Excel in a wide variety of commercial and industrial applications.

This is a hands-on course held near Taunton in Somerset, or on site, and each person is therefore required to bring a laptop with MS Excel 2007 or 2010.

The full course consists of 12 modules and may be entered at any point suited to your current level. If an organisation has at least 4 people wishing for a course then a version can be tailored to meet specific requirements. Each module will last 2 ½ hours, including a 30-minute period for specific queries. A set of notes and worked examples will be provided.

The cost is £60 + VAT per person per module, but a 10% discount applies if 4 sessions are booked.

For any further details Contact Stephen.

The modules, which are grouped into 3 levels, are described below.

Introductory Level
Module 1.1
Workbooks and Worksheets
File handling (1) – New, Open, Close, Save, Save As
Cell selection
Functions (1) – Count, Sum, Average
Copy / Paste / Paste Special
Hiding rows and columns
Shortcuts and Menus

Module 1.2
Cell Comments
Cell formats – Wrap, Merge, Text, Border, Colour, Justify
Find, Replace, Goto
Freeze panes, New Window
Linking cells
Formatting rows and columns
Graphs(1) - Formatting, Types, Symbols

Module 1.3
Toolbars
Printing – Page breaks, Quality
Corner dragging
Functions (2) IF, SumIf, CountIf
Pivot tables (1)
Error types - #NUM, #REF, #VALUE

Module 1.4
Autofill
$ sign and F4
Filtering (1) - Autofilter
Date formats
Date functions – Date, Now, Today, Weekday, Eomonth
Sheet copying
Sorting (1) – 1, 2 column

Intermediate Level
Module 2.1
Macros (1) - Recording
Protecting sheets
Conditional formatting, Zooming
Graphs (2) – Secondary-axis, Background, Series order
Summing across sheets
Functions (3) – Vlookup, Hlookup

Module 2.2
Filtering (2) – Advanced filter
Functions (4) – Left, Right, Mid, Lower, Upper, Proper, Datedif
Drop-down lists – LookUp, Validation
Naming Cells and Ranges
Macros (2) – Editing, Dim, Loops
Headers and Footers

Module 2.3
Hyperlinks
String concatenation
Sorting (2) – Multi-column, Left/Right
File handling (2) – Send To, CSV files
Graphics (1) – Shapes, Grouping
Macros (3) – Debug, Option explicit, Scope
Circular references

Module 2.4
Functions (5) – Match, Index, Indirect
User Forms
Dialogue Boxes
Configuration control
Macros (4) - Autoexec, New sheets, On Error
Templates

Advanced Level
Module 3.1
Macros (5) – Custom-built functions, Opening and closing workbooks, Personal
Shortcut keys
Passwords
Functions (6) – Combining Match, Index, Left, Right, Mid
String searching

Module 3.2
Formula auditing, Formula view
Dependents and Precedents
Graphs (3) – 3-D, Mixed line type, Bar Images,  Pie charts, Tricks
Pivot tables (2)
Graphics (2) – Nudge, Order, Flip
Array formulae (1) – 1-D, Entering

Module 3.3
Macros (6) – Modules, Attaching to Shapes
Inserting graphics
Subtotals
Graphs (4) - Self-correcting
Named ranges – Self-updating
Statistical functions

Module 3.4
Random numbers and Monte Carlo
Goal seek
Solver
Array formulae (2) – 2-D, Operations, Functions, Transpose
Importing data – recording queries
Macros (7) – Auto email, Optional arguments