top of page

Microsoft Excel Course
Intermediate

The course has been developed for people who have a good knowledge of Excel. It is highly recommended that any one attending should attend our introduction to excel first. Initially exercises will be carried out under instruction from the tutor, throughout the course there will be plenty of time to practise the new skills. 

​

It is recommended that students have a good knowledge of Excel and must have knowledge of formula building. Ideally to have attended our 
introduction to excel course. 

Wireless Computer Accessories
Microsoft Excel logo

​

 

Formulae

  • Custom Lists

  • Review of Cell Addressing within Formulae

  • Copy Formulae

  • Absolute Cell Referencing

 

Functions

  • Use of the Average, Min, and Max Functions

  • If Function and Logical Functions

  • VLookup Function

  • VLookups to a database on a different sheet

  • Sub Totals

  • Date Related Functions

  • Nested Functions

  • Grouping Data with Summary Rows

  • Remove Duplicates/ Highlight duplicates/conditional formatting

​

Ranges

  • Creating Named Ranges

  • Dynamic Named Ranges

  • Using Range Names in Formulae

  • Multiple Sheets

  • Group Edit Mode

  • Pivot Tables

  • Creating a Pivot Table

  • Updating

  • Creating a Pivot Chart

 

General

  • Conditional Formatting – customising built in settings

  • Format as a table
     

Microsoft Excel Course Topics

bottom of page