Intermediate Excel

This course builds upon the Introductory Excel course so we strongly encourage delegates to complete the Introductory course first. The course assumes a working knowledge of basic Excel functions such as SUM, COUNT and AVERAGE as well as the ability use absolute cell references with confidence.

By the end of the session delegates will be able to:

  • Inserting and renaming a new Worksheet
  • Importing Data from External Files
  • Data Validation (Drop Down Lists)
  • Conditional Formatting
  • Advanced Formatting
  • Auto Filters
  • Removing an Auto Filter
  • Advanced Auto Filtering
  • Using Named Cells and Ranges  
  • Calculating Across Worksheets 
  • Protecting Worksheets 
  • Creating a Shared Workbook
  • Advanced Functions (IF, AND, OR, VLOOKUP, HLOOKUP, CONCATENATE etc)
  • Mathematical Functions              
  • Using LOOKUPS  to Access Ranges
  • Introduction to Pivot tables
  • Pivot Table Charts