EXCEL INTERMEDIATE COURSE, PRIVATE 1-TO-1

COURSE SUMMARY

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. 

COURSE OUTLINE

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

Pivot-tables 

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 

WHAT IS INCLUDED:

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