How to apply Order a prospectus  Prospectus Builder
Courses
Careers
Leisure Courses
More

What career opportunities can this lead to?

You will then be qualified to progress to the VBA course for Excel. Candidates can be directed toward the European Computer Driving License Course.

What are the entry requirements?

No formal entry requirements

What does this programme involve?

Course Syllabus:
Working with Advanced Formulas
- Using Names
- Using decision-making functions
- Creating nested functions
- Using financial functions
Lookups and Data Tables
- Working with lookup functions
- Creating data tables
Advanced List Management
- Creating subtotals
- Validating cell entries
- Exploring database functions
Working with PivotTables and Pivot Charts
- Working with PivotTables
- Rearranging PivotTables
- Formatting PivotTables
Exporting and importing text files
- Querying external databases
Using Analytical Options
- Working with Goal Seek and Solver
- Working with scenarios
- Working with views
Working with Macros
- Running and recording a macro
- Viewing VBA code
- Function procedures All one-day IT courses are bespoke and not qualification-based. Training formats available:
- 1 day instructor-led at the College
- Onsite at your company office UK wide
- Bespoke one-to-one basis
- Tailored training courses to your requirements At the end of this course, you will have a complete understanding of the higher functions of Excel. You will be able to perform the most advanced calculations and functions, manipulate data using pivot tables and advanced analysis, record macros and integrate with other office applications.

How is the programme taught and assessed?

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 else do I need to know?

Our Microsoft Excel Advanced course is suitable for those with a sound working knowledge of Excel who wish to progress to the most complicated functions and features. You must have a working knowledge of Excel or passed the Intermediate Excel course.

Pen and paper.

Dates for the diary

Our part-time open event is held every June. For specific dates and times please see the events section of our website or telephone 023 8091 1299.

How do I apply?

Apply by clicking on the APPLY NOW link on this page. Alternatively, you can apply by completing an application form through our Information, Advice and Guidance team by telephone 023 8091 1299 or via email at goplaces@eastleigh.ac.uk.

*Fees will apply if you are over 18. You may be eligible for fee support or a loan. To find out an accurate cost, based on your individual circumstances, please contact our Information, Advice and Guidance team.

Course Code

CLBUX0/EXC3

Session Venue Starts Days Time Weeks Fees* 24+ Fees*
EXC3A Eastleigh College Fri 09:30 – 16:30 1 £100.00 £100.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 any 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.

Course Notice

Unfortunately this course is now full. Please select another date, if available, or click here to submit an enquiry. By doing so our admissions team can contact you if a place becomes available.