Excel level 2 - Intermediate

Microsoft Office - Microsoft Excel

Course Overview

Improve your Excel skills to develop more complex workbooks.

This course equips the user with a proficient knowledge of Excel, covering a wide range of commands and the production of high quality graphics and documents. The day commences with a brief review of commands covered in the Level 1 course, followed by an in-depth look at enhancing spreadsheets using multiple worksheets, database capabilities, split screens, other 'functions' and advanced charting.

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.

This course can be run as a company specific option either at your site or our own.

Up to 70% funding for this course may be available if booked as part of a Skills for Industry training package. Check to see if you are eligible (email: [email protected]) before booking this training.

  • Course Content

    General Review

    General review of existing knowledge and the
    commands covered in the Level 1 course.

    Multiple Worksheets

    Creating multiple worksheets; moving between
    sheets; deleting sheets; using 3D formulae; typing,
    pointing and pasting links.

    Advanced Charting

    Editing charts; selecting chart elements; using chart
    options. Sparklines.

    Simple Functions

    Including the IF and VLOOKUP functions.

    Naming Cells

    Defining names using the Name box.

    Excel as a Database

    Including database definition; data forms; sorting and
    filtering data; sub-totals and pivot tables.

    Protecting Data

    Protecting data and using passwords.

    The Excel Environment

    Showing split screens and titles.

  • Prerequisites

    Attendees will gain the maximum benefit if they have attended our Level 1 course, or are familiar with creating basic spreadsheets and using simple functions.

  • Qualification

    This course covers material from the standard European Computer Driving Licence (Module 4, contributes to an ITQ level 2 / ECDL Extra qualification and the Microsoft Office Specialist Core
    Excel syllabus.

  • Excel Functions
    Developing formulas for calculations you want to make in Excel can be tedious and complicated. Excel has an entire library of functions or predefined formulas that you can use. There are hundreds of functions in Excel that allow you to format text, reference cells, calculate financial rates, look up information and more.


    Excel Level 3
    Gain an in depth knowledge of data analysis, learn how to audit your spreadsheet and use advanced features such as templates and macros.

Booking Options Available for Excel level 2 - Intermediate

Please select the location you want to book the course

Please select the date you want to book the course

Please select the number of people attending the course

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

Funded Redundancy Training

Funded Redundancy Training

Are you about to be made redundant or have you been made redundant in the last three months? 100% funded training is available.

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

  • Computeraid Ltd, 4th Floor, 11 Wind Street, Swansea, SA1 1DP

  • Telephone: 01792 610550 / 029 2066 4285
  • [email protected]
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