Microsoft Excel Intermediate
Complex Formulas

Overview

This stage introduces more complex features. By the end of this course students will be in a position to use some of Excel’s most beneficial functions such as; If, Sumif, Countif, And, Or, Vlookup, Hlookup and an introduction to using combined formulas. In addition, PCS will also look at more advanced data analysis techniques with combined formulas such as Pivot tables.

Course Outline

  • Editing (Custom Fills / Conditional Formatting)
  • Advanced Linking Spreadsheets (Formula Linking)
  • Data (Pivot Tables/ Custom Filtering/ Subtotals/ Validation/ Lists/ Protection)
  • Formulas (IF Statements/ CountIF & SumIF/ V & H Lookup)
  • What IF Analysis (Goal Seek / Scenario manager)
  • Introduction to Combined Formulas