Microsoft Excel - 3/3

2. Demonstrate Your Skills to an Evaluator

Only editable by group admins

  • Last updated July 18, 2018 at 8:40 AM by samdjackson
  • Evidence only visible to badge awarders
Show your completed project to an evaluator and demonstrate your ability to use the tools listed below.

Requirement Submission

Submit the date and name of the person who conducted your evaluation. View the list of evaluators here: https://wiki.learnsoftware.org/current-sages/

Demonstrate skill with:

  • Named Ranges
  • Boolean Functions: And, Or functions
    • Learn how to nest them in If Function
    • Learn how to combine different functions together.
  • Hlookup Function
  • Index and Match Functions
  • Pivot Tables
  • VBA
  • Macros