Spreadsheets: Unit Standards 27642 and 27643

Spreadsheets: Unit Standards 27642 and 27643

Microsoft Excel has tools that enable you to summarise large amounts of data. It has functions like SUMIF and COUNTIF as well as pivot tables and automatic subtotals. You can also use lookup functions to find the price (or other attribute) of an item. This manual covers:

  • Creating formulas with absolute and mixed cell references
  • Naming cells and ranges
  • Nested functions
  • SUMIF and COUNTIF
  • Creating and formatting tables
  • Validating data
  • Lookup functions
  • Conditional formatting
  • Sparklines and charts
  • Linking worksheets and workbooks
  • Calculating subtotals
  • Pivot tables and pivot charts


ISBN: 1-877350-86-9
Total pages: 200+
Qualification: NZQA Unit Standards 27642 and 27643

Table of Contents