Coronavirus Update

Eastleigh College has moved to online learning, as such campuses are closed to the vast majority of learners. The College remains open (including over the Easter holiday period) for 16-18 learners of key workers, and those learners with an Education, Health and Care Plan (EHCP). However, for both categories, learners are asked to stay at home where it is safe to do so. Consistent with public health advice, learners and staff are asked to follow public health guidance and the steps outlined via the 'read more' button.

What opportunities will this course give me?

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 will I be learning?

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.

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 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.

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

CLBUX0/EXC3

Course Options

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

- Apply Now

Venue

Eastleigh College

Session code

EXC3A

Day

Time

09:30 – 16:30

Weeks

1

Fees

£103.00

24+: £103.00

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