• If you use Excel daily or more complex logic and automation is required
• Experience hands-on, practical learning
• Boost efficiency by learning time-saving formulas and techniques
• Solve Excel problems with guided support
• Flexible delivery options, either join in person or online

If you've attended our Excel Intermediate course or used Excel before and understand absolute and relative cell addressing and can combine basic calculations in a single formula, then this course will help move your knowledge and confidence on to the next level.

This Excel Advanced Level 1 course is ideal for:

• Professionals that need to build complex nested formulas as part of creating a custom Excel solution
• Team members who need to build business logic into their Excel spreadsheets and automate repetitive tasks
• Anyone who has taken our Excel Intermediate course and wants to learn a wider range of functions and techniques
• Individuals preparing to move to roles requiring daily Excel use and need to ensure their time is used efficiently

• Solve real business challenges - by developing confident, capable Excel users across your organisation that can use advanced formulas and functions
• Strengthen data accuracy - enabling the team to implement well structured spreadsheets with practical steps to validate data and protect worksheets
• Increase efficiency- by automating repetitive tasks to free up time for more valuable insight driven tasks
• Share and collaborate efficiently - by designing user friendly spreadsheets containing formulas that are easy to read and maintain across the team and wider organisation

• Nesting functions - complex IF (and IFS) functions using AND/OR logic plus error trapping functions
• Dynamic arrays - learn the benefits of using dynamic arrays in formulas
• 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, making functions easier to use and building custom functions
• 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
• IFS function
• Logic functions
• Complex formula layout tips
• Dynamic array logic
• Error trapping functions

Auditing

• Auditing features
• Tracing precedents and dependants
• Tracing errors and invalid data
• Evaluate formulas step by step

Dates and Times

• Calculations
• Formats

Data Validation and Protection

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

Templates

• Creating a template
• Personal vs shared templates
• Editing templates
• Changing the default template

Working with Defined Names (Named Ranges)

• Creating defined names
• Workbook and worksheet scopes
• Navigating and selecting with defined names
• Using defined names in calculations
• Using defined names to create custom functions (LAMBDA function)

Quick Access Toolbar

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

Macros

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

This course does not lead to a formal qualification or accreditation, but upon successful completion, you will receive a Certificate of Attendance from Jarrold Training.

This certificate demonstrates your commitment to professional development and confirms that you have completed an advanced level course in Microsoft Excel - a valuable asset for your CV and workplace skillset.

By the end of this course, you’ll be able to:

• Nest formulas and create complex logic - including dynamic array logic
• Make data entry more robust and reduce the risk of someone breaking a spreadsheet
• Create reusable templates with custom formatting and readable calculations
• Customise the interface generally and for specific workbooks
• Automate repetitive tasks with Macros and so introduce the concept of programming inside Excel

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.

We aim to provide you with an effective, high-quality learning experience to help you build confidence and practical skills in Excel.

Your trainer will guide and support you throughout the training day, so please feel free to ask questions at any time - they’re always happy to help. Our friendly team is also on hand to ensure your learning experience is smooth and enjoyable from start to finish.

While there is no formal exam, the course includes plenty of hands-on exercises and revision opportunities to reinforce what you’ve learned. Additional support is available after the course, with 90 days of post-course help should you need it. Please contact us if you have any questions.

Do I need to have taken the Excel Intermediate course first?

Not necessarily. If you're already familiar with Excel techniques such as combining calculations into a single formula and using absolute and relative cell addressing, you're ready for this advanced course.

Do I need to bring a laptop?

For in-person courses, all equipment is provided. For online delivery, you’ll need a computer with internet access and Excel installed.

Who is this Excel Advanced Level 1 course suitable for?

If you've been using Excel regularly for a while and are finding it difficult or time consuming to complete your spreadsheet tasks then, this course is ideal for you. It doesn't matter which industry you work in, the techniques covered will be useful across the board.

Is this course suitable for Mac users?

Yes, although Excel looks slightly different on Mac, most functions covered in the course are the same. Please let us know in advance if you’re using a Mac so we can tailor support where needed.