From accounting to NGOs to sales, employers expect Excel skills. Here are the most useful ones and how to prove them.
Beginner skills
- Formatting and freezing panes
- SUM, AVERAGE, MIN, MAX and COUNT
- Sorting and filtering
- Basic charts
Intermediate skills
- IF, IFS, AND and OR
- XLOOKUP or VLOOKUP and INDEX MATCH
- SUMIFS and COUNTIFS
- Conditional formatting
- Data validation drop downs
- Removing duplicates and text functions
Advanced skills
- PivotTables and PivotCharts
- Power Query
- Simple dashboards
- Basic macros
Practice projects
- A monthly budget tracker
- A sales report with PivotTables
- A stock management sheet
- A dashboard from public data
Show it on your CV
Be specific: "Built a sales dashboard using PivotTables and XLOOKUP that cut reporting time by half."
Get expert help in minutes
Every situation is different. If you want advice tailored to your plans, book a short call with a verified expert on The Quick Consult and get clear answers without leaving your home or office.