Intermediate Excel – Excel level 2 – Online

Improve your spreadsheet skills  to develop more complex workbooks.  This Intermediate Excel course is delivered online.

 Intermediate Excel – Online Course Objectives

This hands-on, tutor-led Intermediate Excel online course equips the user with a proficient knowledge of Excel.  Delegates cover a wide range of commands and produce high-quality graphics and documents.  The day commences with a brief review of commands covered in the Introduction to Excel – Level 1 course, followed by an in-depth look at enhancing spreadsheets using multiple worksheets, database capabilities, split screens, other ‘functions’ and advanced charting including pie charts.


Intermediate Excel – Online Course Contents

General Review

General review of existing knowledge and the commands covered in the Introduction to Excel – level 1 course.

Cell References

Relative and absolute cell references.

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. Working with sparklines.


Including the IF and VLOOKUP functions.

Naming Cells

Defining names using the Name box.

Excel as a Database

Including database definition; sorting and filtering data; working with sub-totals.

Pivot Tables

Using Pivot Tables, Slicers and Pivot Charts

Protecting Data

Protecting data and using passwords.

The Excel Environment

Showing split screens and titles.


Intermediate Excel – Online Course Details         

This is a one-day intermediate course running from 9:30 am – 4:00 pm.


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

Online Course

This course is delivered live online. Course delegates will need a reliable internet connection and a PC or laptop with audio and video capability with the relevant software installed for the training.  Delegates see, hear and interact with the tutor.


This course covers material from the standard International Certificate of Digital Literacy (Module 4) and the Microsoft Office Specialist Core Excel syllabus.

What Next? Advanced 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.


The more you learn, the more you earn

Book Event

General Ticket
Available Tickets: 8

Training is hands-on and tutor-led. We provide a comprehensive training manual and certification. This course can be run as a company specific option.

The "General Ticket" ticket is sold out. You can try another ticket or another date.

© 2024 Computeraid
Website by NETBOP