1. Complete a Project

Demonstrate skill with:

• Know how to import data from a text file
• Know how to create and manipulate tables
• Format as table
• Themes
  
• Sorting and Multilevel sorting
• Filtering
• Slicers
• Pivot Tables
• Know how to use them and why they're useful
• Conditional formatting
• Presets, custom rules
• Basics of Power Query Editor
• What is it and why we use it
• SUMIF function
• AVERAGEIF function
• COUNT and COUNTIF functions
• IFS function
• INDEX and MATCH functions
• Know how to create charts
• Know the different chart elements and what they do
• Switch x and y axis
• Scatterplots
• Pie charts
• Know how to set up for printing
• Page Breaks
• Print Titles
• Know how to use different viewing options
• Freeze Panes
• Split Screen
• Paste Special