Excel Skills Library

Easy

• Shortcut Keys
• Creating a basic formula
• The SUM function
• Relative vs Absolute cell addressing
• Merging cells to create a heading
• Sorting data
• Basic filtering
• Freeze panes to keep headers visible
• Creating charts and choosing the right chart type
• Quick Analysis and Format Painter

Intermediate

• Check for Duplicates
• IF statements
• VLOOKUP vs XLOOKUP
• Conditional formatting basics
• Data validation and drop-down lists
• COUNTIF and SUMIF
• PivotTables for beginners
• Text functions (LEFT, RIGHT, MID, TRIM, CONCAT)
• Remove duplicates and clean messy data
• Flash Fill
• Date and time functions (TODAY, DATEDIF, NETWORKDAYS)
• Named ranges
• Protecting sheets and cells

Advanced

• INDEX and MATCH
• Power Query basics
• Dynamic array functions (FILTER, SORT, UNIQUE)
• Nested IFs, IFS and SWITCH
• Dashboards with slicers
• What-if analysis (Goal Seek and Scenario Manager)
• Power Pivot and the data model