PrintPrint

Excel Advanced - Masterclass
B00637

This intensive 1 day course is a follow on from the Excel-Intermediate course and covers the more complex functions and features of Excel.

Course Content

Using logical functions-Creating nested IF functions
AND and OR functions
Working with lookups
Advanced list management-Using data validation
PivotTables and PivotCharts
Using analytical options- Working with scenarios-
Macros

Entry Requirements

Individuals who have a sound working knowledge of Excel, who have completed an intermediate course or have equivalent knowledge.

First Class Requirements

You can progress to:
Microsoft Office Specialist-Excel. If you are interested in applying for this course or to take the assessment for this accreditation you will need to have a more detailed discussion with your course tutor at the end of your course.Further study may be required.

Assessment Methods

Course fee includes:
Training booklet
Certificate of completion

If you have any further questions please contact: training@racc.ac.uk

Further Study Options

You can progress to:
Microsoft Office Specialist-Excel. If you are interested in applying for this course or to take the assessment for this accreditation you will need to have a more detailed discussion with your course tutor at the end of your course. Further study may be required.

Additional Information

If you are booking and paying for the course yourself you can enrol directly online or in person at our Parkshot Centre
If your employer is paying for you or you are an employer wishing to pay for your staff

Please email training@racc.ac.uk stating:
1.The course code and title
2. The names of the learners and the total fee you are paying
3. The name and contact details for invoicing
We will then contact you to confirm your booking.