If you've put the topics on our Excel Introduction and Intermediate courses to good use then you're ready for this one. Or perhaps you've been using Excel for a year or two and want some formal training to help master the more advanced topics. Any doubts about which level to book, then have a chat with one of our trainers...its free!

• Nesting functions - complex IF functions using AND/OR logic plus error trapping functions
• Auditing formulas - troubleshoot your own spreadsheets and tools to work out how other spreadsheets work
• Time calculations - summing times above 24 hours and calculate with hourly rates
• Validate and Protect - Make it easier and safer for others to use your spreadsheets
• Defined Names - Name cells for navigation, printing and make functions easier to use
• Macros - Automate repetitive tasks by recording the steps and have Excel run them at super speed

Course Introduction and Revision

• Basic formulae and functions
• AutoFill options
• Absolute / relative / mixed referencing
• Basic and nested if functions
• Round function
• Column & row / text / number formats
• Custom number formats

Functions

• Nested functions
• Logic functions
• Error trapping functions

Auditing

• Auditing Features
• Precedents and Dependants
• Tracing Errors and Invalid Data

Dates and Times

• Calculations
• Formats

Data Validation and Protection

• Data validation
• Circling invalid data
• Protecting cells, ranges and files

Templates

• Creating a template
• Editing templates
• Changing the default template

Working with Ranges

• Creating range names
• Workbook and worksheet scopes
• Navigating with range names
• Selecting using range names
• Calculating with range names

Quick Access Toolbar

• Changing position
• Adding and removing commands
• Customising for a workbook

Macros

• Storing macros
• Recording a macro
• Running a macro
• Absolute & relative recording
• Assigning macros to:
• Quick access toolbar
• Spreadsheet buttons and keyboard shortcuts
• Editing a macro

The course runs from 9:30am through to 4:30pm. Refreshments are available from 9am.

We provide:

• Full course material
• Certificate of attendance
• 90 days post course support
• Note pad and pen
• Polos!

Also includes:

• Free on-site parking
• Refreshments throughout the day
• Lunch at a local restaurant
• Free WiFi

Our Norwich on-site parking (NR3 1UB) is free and situated 5 minutes walk along the river to our training centre at St James Mill. If you arrive by train it is about 20 minutes on the Riverside walk or a short taxi ride to get to us. View full directions for Norwich and all our other venues.

You will learn in a relaxed environment with a small group of up to 8 people. A specialist tutor will guide and encourage you through all the learning necessary to develop your skills and questions are always welcome.

• Excel Advanced Level 2
• Visual Basic for Excel
• Word Advanced Level 1