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 and format 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. You should already know how to create charts.

Charts, Sheet Layout and Formatting are covered at Level 1 - Introduction.
Items not listed here (including PivotTables and Macros) are not covered on this course and are covered at a higher level.

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
  • 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