Excel level 3 - Advanced

Microsoft Office - Microsoft Excel

Course Overview

Become an expert Excel user!

This course is designed to enable the proficient user to gain extended use of the spreadsheet package. The day starts with a brief review of commands covered in the Level 1 and 2 courses, followed by an in-depth look at some of the advanced tools of this package, such as Scenarios, Auditing and the Solver. The course covers conditional formatting,
creating templates, data validation and data analysis tools. There will also be a detailed look at creating and using macros to enhance spreadsheet efficiency.

This is a one-day course running from 9:30 am - 4:30 pm.
Training is hands-on and tutor-led.
We provide a comprehensive training manual, lunch and certification.
Courses run at both Swansea and Cardiff locations.

  • Course Content

    General Review

    General review of existing knowledge and the
    commands covered in Levels 1 and 2.

    Goal Seek and Solver

    Finding values for one or more input cells to optimise
    the value of a formula.

    Scenario Manager

    Setting up a scenario; switching between scenarios.

    Auditing

    Error checking.

    Data Validation

    Creating comments and defining valid cell entries.

    Templates

    Creating and saving a template.

    Conditional Formatting

    Setting and using conditional formatting.

    Macros

    Creating and running macros; assigning macros to
    buttons, keystrokes, menus and toolbars.

    Hyperlinks

    Using hyperlinks to move to specific cell references
    in spreadsheets.

  • Prerequisites

    To gain the maximum benefit from this course, an attendee should have attended our Levels 1 and 2 courses, or have an equivalent understanding of Excel, especially the use of formulae, functions and
    multiple worksheets.

  • Qualification

    This course covers material from the Advanced European Computer Driving Licence and the Microsoft Office Specialist Expert Excel syllabus.

  • Access
    Use the powerful Access database capability to keep and organise all your records. Learn how to create tables of information, design useful forms, query your database and produce professional reports.

Booking Options Available for Excel level 3 - Advanced

Please select the location you want to book the course

Download Booking Form

Alternatively you can download our booking form, fill in all the relevant information and mail it back to us.

Tailored Training

Tailored Training

Take advantage of a customised training programme to suit your needs at a location of your choice.

Learn More

Up to 70% Funded Training

Up to 70% Funded Training

Up to 70% funding might be available for training depending on your circumstances.

Learn More

Redundancy Training

Redundancy Training

Are you about to be made redundant or have you been made redundant in the last three months?

Learn More

Email Updates

Email Updates - Join Our Mailing List

Join our mailing list to keep updated on exclusive offers and latest news on our training courses.

  • ECDL
  • ECDL Advanced
  • Approved Test Centre
  • Skills for Industry

Join Computeraid Ltd on Facebook
Follow Computeraid Ltd on Twitter
Tweets by @ComputeraidLtd
View Dizzee Designs on LinkedIn

Computeraid Ltd

Computeraid Ltd – LinkedIn

Computeraid is the largest supplier independent computer training and consultancy company in South Wales, training around 20,000
people days annually.

Swansea. South Wales