Module 2 : Spreadsheet Functions to Organize Data

This module introduces various Excel functions to organize and query data. Learners are introduced to the IF, nested IF, VLOOKUP and the HLOOKUP functions of Excel.

 

Topics covered include:

  • IF and the nested IF functions
  • VLOOKUP and HLOOKUP
  • The RANDBETWEEN function

Module 1 : Introduction to Spreadsheets

Module 3 : Introduction to Filtering, Pivot Tables, and Charts

Leave a comment

Your email address will not be published. Required fields are marked *