Excel Intermediate 1-Day Course, Private 1-to-1, Webinar Virtual Classroom

Excel Intermediate 1-Day Course, Private 1-to-1, Webinar Virtual Classroom

Actions and Detail Panel


This practical, instructor-led, online course is designed to give you excellent techniques to improve your good already Excel Spreadsheet.

About this event



This Excel course is offered one-to-one or in small group of up to 4, because we understand that professionals have varying skill levels and varying applications.

We run the class in our Virtual Online Classroom, Instructor-led, Practical, Interactive.

You already have the basic Excel skills but have many questions daily and want to be more proficient. 


Working with Functions and Formulas

Creating Formulae in Excel, general calculations 

The Function Wizard

Using Functions in Excel: The 5 Popular functions

If- function

Working with Names and Ranges 

Copying formulae 

Group and Outline, Range names,

Sub Totals

Functions: Commonly used Functions from the Function wizard and Formula Ribbon

Lookup Functions: Vlookup, Hlookup, Index, Match 

Conditional Formatting

Filter and Advanced filter: Using Excel as a Database- Advanced filter , Auto filter, Sort


Create Pivot Table, Amend, Filter, Sort, Group Data, Format Pivot Tables, Add additional formulas, Refresh Data.  Pivot Charts 

Managing Tables

Working with Tables , Working with Records and Fields ,

Filters and Sorting,

Freeze panes, split,

Protecting and unprotecting 

Charts and Spark Lines: Adding and Editing Charts , Adding and Editing Spark Lines 


  • Certificate on completion
  • Course notes
  • Practical Class exercises, Homework / Revision work
  • To assist after the course, 1 free session for questions online

Share with friends

Save This Event

Event Saved