Excel Level 2 - Intermediate

Overview

At the end of this course participants will have a better understanding of how formulas are constructed and will have a thorough knowledge of how to structure a spreadsheet and database within Excel.

This course is specifically for those who already have some experience of Excel and know how to input data into a spreadsheet. It will specifically be of interest to those who are working on spreadsheets created by others but want to know how to set up and manage their own workbooks.

Syllabus
  • Understanding the difference between “relative” and “absolute” cell references.
  • Defined Names of cells and ranges and using the Name Manager.
  • Create custom formats for dates and numbers.
  • Use the IF function.
  • Understand and use the VLOOKUP and HLOOKUP functions.
  • Learn how to use the SUMIF(s), COUNTIF(s) and AVERAGEIF(s) functions.
  • Work with Text by using the common Text functions.
  • Import data from other systems and clean it up.
  • Review the basics from Level 1 Excel
  • Learn how to prepare a basic Pivot Table
  • Average - AverageIF - AverageIFs - Clean - Concatenate - Count - CountIF - CountIFs - CountA - Countblank - Exact - HLookup - IF - Left - Lower - Max - Mid - Min - Now - Proper - Right - Sum - SumIF - SumIFS - Today - Trim - Upper - VLookUp