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.

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

Included with your course
We provide the following with online and training centre delivered courses.

• Course notes
• Certificate of attendance
• 90 days post course support

Online Delivery
A link to the online training platform will be sent before the course, simply click the link and follow the instructions.

• See Virtual / Remote training information for more details
• Contact us if you'd like to test the platform before the morning of the course
• You can be located anywhere in the world with an internet connection and your computer

Our Training Centres
For training courses run at one of our training centres we include.

• Free onsite parking
• Lunch and refreshments
• Notepad, pen and Polos

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.

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