• Bridge the gap between basic and advanced Excel knowledge
• Experience hands-on, practical learning
• Boost efficiency by learning time-saving formulas
• Build confidence with guided support
• Flexible delivery options, either join in person or online

If you've attended our Excel Introduction course or used Excel before and understand simple calculations including AutoSum, then this course will help move your knowledge and confidence on to the next level.

This Excel Intermediate course is ideal for:

• Professionals who work with data regularly and want to improve the speed, accuracy, and clarity of their spreadsheets.
• Team members who need to manage or analyse lists, perform calculations across sheets, or prepare charts for meetings.
• Anyone who has taken an Excel Introduction course or is self-taught but unsure about features like conditional formatting, IF functions, or linking workbooks.
• Individuals preparing for roles that require greater spreadsheet confidence, such as project coordinators, administrators, finance assistants, or analysts.
   

• Increase team efficiency - Employees learn practical Excel techniques, functions, and tools that reduce time spent on manual tasks and repetitive data handling.
• Improve data accuracy - By mastering formulas, data validation, and conditional formatting, your team will produce more reliable and error-free reports.
• Maximise existing tools - No need for expensive new software as your team will unlock the full potential of Excel, a tool you likely already use, with immediate on-the-job benefits.
• Support staff development and retention - Investing in practical, confidence-building training demonstrates your commitment to employee growth and helps retain skilled team members.

• How to work with dates and times - Calculate age or stock date expiry warnings
• ​Build in logic with the IF function - Monitoring stock levels to display re-order information
• Conditional formatting - Automatically highlight relevant information, e.g. stock that needs re-ordering
• ​Absolute cell addressing - Lock cell references with dollar signs and learn why you would use this
• Database features - Sort, filter and sub-total lists of stock by category
• Calculations across multiple sheets - ​Store data with a sheet per month and create an annual summary
• ​Charting - Create a graphical representation of summary data for use in meetings

Revision

• Mathematical operators and BIDMAS
• Common functions plus Counta and Countblank
• Quick Access Toolbar and Excel Options
• Revision Exercise

Functions

• Date function
• Time function
• Round function
• IF function
• Integer function

Cell Addressing

• Absolute cell addresses
• Relative cell addresses
• Dynamic array alternative

Conditional Formatting

• Applying conditional formats to text
• Applying conditional formats to numerical values
• Clearing rules

Database Features

• Using a spreadsheet as a database
• Sorting data
• Basic subtotals
• Filtering data with Filter
• Custom Filter
• Find Feature

Working with Multiple Sheets

• Selecting sheets
• Inserting & deleting sheets
• Copying sheets
• Copy and paste between sheets
• Naming sheets
• 3D calculations
• Group edit facility
• Using Hyperlinks to link worksheets

Working with Multiple Workbooks

• Opening multiple workbooks
• Arranging windows
• Linking workbooks
• Hyperlinks to worksheets and workbooks

Additional Features

• Inserting comments

Charting

• Revision of basic charts
• Chart types
• Sizing and moving a chart
• Editing a chart
• Changing chart data
• Formatting chart elements
• Drawing features
• Printing a chart

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 intermediate-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:

• Use logical formulas like IF to automate decisions in your spreadsheet
• Manage and analyse lists of data using sorting, filtering, and subtotals
• Link data across multiple sheets and workbooks
• Create professional-looking charts to visualise data
• Apply conditional formatting to highlight key trends or outliers

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 Introduction course first?

Not necessarily. If you're already familiar with basic Excel tasks like entering data, using AutoSum, and creating simple formulas, you're ready for this intermediate 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 Intermediate course suitable for?

If you've used Excel before and understand simple calculations, but are looking to improve your knowledge further, this course is ideal for you. 

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