Microsoft Excel 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-seeklogo.com.png

Session Topics

 

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