Overview
-
Take your Excel skills to the next level with these advanced challenges from an Excel MVP.
Syllabus
-
Welcome
- Excel Power User Challenge
- Deliveries and PivotTables
- Troubleshoot this query that has a peculiar result
- Check this data quality for results that don't fit requirements
- Set up a document to show low-level alerts
- Write a formula for a two-way lookup
- Format cells to create ID numbers
- Parse and summarize data to tally votes
- Write a SUMIFS formula for three criteria
- Beautify form with images and print settings
- Add spin buttons to compare products
- Restructure the data and write formulas to calculate bonuses
- Import from folder and tally attendances
- Create a histogram from the donation data
- How many full and partial orders can be filled from this inventory?
- Who owes what for the beach house vacation?
- Sort dates by day and month to find the birthday with the most people
