Making Data Work For You

This module explains how to understand and apply Excel basic formulas and functions.

Lessons

• Formula basics
• Using cell references
• Copy formula without changing cell reference
• Transpose formula
• Using nested functions

After completing this module, students will be able to:

• Understand and apply formula basics
• Use cell references
• Copy formula without changing cell reference
• Transpose formula using paste special
• Use nested functions

Statistical and Logical Functions

This module explains how to use logical functions including CountIf, Sumif, If, IsError.

Lessons

• Perform calculation using CountIF
• Perform calculation using SumIF
• Perform calculation using AverageA
• Using IF function to prevent division by zero
• Using IsError function to avoid error display
• Creating multiple conditions using nested IF
• Using logical function OR, And

After completing this module, students will be able to:

• Perform calculation using CountIf, SumIf, AverageA
• Use If function to prevent division by zero
• Use IsError function to avoid error display
• Create multiple conditions using nested IF
• Use logical function OR, AND

: Lookup and Reference Formulas

This module explains how to apply and use lookup formulas including vlookup, hlookup, match and index.

Lessons

• Use Vlookup to find specific data
• Use Hlookup to find values in rows
• Use Match and Index to retrieve data

After completing this module, students will be able to:

• Use Vlookup to find specific data
• Use Hlookup to find values in rows
• Use Match and Index to retrieve data

Text Formulas

This module explains how to apply Text formula to help change casing of text, append text and numerical value in excel spreadsheet.

Lessons

• Changing case of text
• Append text and numerical value
• Convert imported text format into numbers
• Break imported date field into individual columns

After completing this module, students will be able to:

• Change case of text using Upper, Lower or Proper formula
• Append text and numerical value
• Convert imported text format into numbers
• Break imported date field into individual columns