Skip to content Skip to menu

What opportunities will this course give me?

After completing the course you will be prepared to attend the Excel Advanced training course.

What will I be learning?

Course Syllabus:
Working with Large Worksheets
• Viewing options
• Hiding and displaying data
• Printing large worksheets
Working with Multiple Worksheets and Workbooks
• Using multiple worksheets
• Linking worksheets by using 3-D formulas
• Consolidating data
• Linking workbooks
• Managing workbooks
Customising Excel
• Changing options
• Customising toolbars and menus
Advanced Charting
• Chart formatting options
• Creating combination charts
• Using graphic elements -Advanced Formatting
• Borders and shading
• Using special number formats
• Working with dates
• Working with styles
• Other advanced formatting
List Management
• Working with lists
• Sorting and filtering lists
• Advanced filtering
Documenting and Auditing
• Comments and text boxes
• Auditing features
• Protection
• Workgroup collaboration All one day IT courses are bespoke and not qualification-based. Training formats available:
• 1 day instructor-led at the College
• On-site at your company office UK wide
• Bespoke one-to-one basis
• Tailored training courses to your requirements The course is designed for those users who wish to step up their current knowledge of Excel to take advantage of the more complex features; to be able create, edit and format large or multiple spreadsheets. Delegates will also be able to perform calculations and functions within a workbook, manipulate data lists and create custom charts which will enable the user to maintain and present data in a professional environment.

Why is this course for me?

Training formats available
• 1 day instructor-led at the College
• On-site at your company office UK wide
• Bespoke one-to-one basis
• Tailored training courses to your requirements

What do I need to sign up?

No formal entry requirements

Is there anything else I need to know?

Our Microsoft Excel Intermediate course is suitable for those with a good working knowledge of Excel, or those who have completed the Introduction to Excel course.

Pen and paper.

Application Information

Please note that all courses are subject to minimum numbers and course descriptions may be subject to change. A place on your chosen course is not confirmed until all of the necessary enrolment paperwork is signed and any relevant fees are paid. The team will be in touch to discuss this with you, once your application has been processed.

Course Code


Course Options

Click an option below to see more details and to apply.

11/03/2022 - Apply Now


Eastleigh College

Session code





09:30 – 16:30





24+: £109.00

Session Venue Starts Days Time Weeks Fees* 24+ Fees*
EXC2A Eastleigh College 11/03/2022 Fri 09:30 – 16:30 1 £109.00 £109.00 Apply now

* Please note that although this tool looks to give customers the best indication of course costs, a final cost can only be confirmed once all submitted information is verified by our information, advice and guidance team.

Need some further advice?

If you require further advice and guidance about any course costs and/or the funding options available to you, the College has a dedicated Information, Advice and Guidance team who can be contacted on telephone 023 8091 1299.

The Equality Act

The College wishes to ensure that it complies with the requirements of the Equality Act 2010. If you are a disabled person, please ensure that we know what you need so that we can make all reasonable adjustments to help you succeed.

Please note all courses descriptions may be subject to change.