Microsoft Excel - 2/3

2. Demonstrate Your Skills to an Evaluator

Only editable by group admins

  • Last updated May 9, 2018 at 4:04 PM 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:

  • Know how to import data from a text file
  • Know how to clean data
    • Text to Columns
    • Flash Fill
    • Format Painter
    • Remove Duplicates
  • Know how to format data
    • Format phone number, SSN, BYU-ID (custom formatting)
  • Know how to create and manipulate tables
    • Format as table
    • Themes
    • Sorting and Multilevel sorting
    • Filtering
    • Totals row
  • Know how to use conditional formatting
  • Know how to use the If function, Nested If function, SumIF and Average IF function, Vlookup function
  • Know how to create charts
    • Know the different chart elements and what they do
  • Know how to set up for printing
    • Page Breaks
    • Print Titles
  • Know how to use different viewing options
    • Freeze Panes
    • Split Screen
For pass off you should use the Excel Files that we use on Day 2,3,and 4 of the Excel Software Training workshop and demonstrate to the sage in person or through a screen-cast.