Take your Excel skills to the next level with these advanced challenges from an Excel MVP.
Overview
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
- Pizza party calculation
- Stack this data using Power Query
- Who has an assignment and who doesn't?
- Create data validation that only accepts pairs
- Stack and summarize vendor data
- Sort titles and ignore A, An, The
- Unwind this report
- Two data sets, one relationship, one PivotTable
- Extract the competition winners
- Three ways to retrieve data
- Unstack this list so that it's useful
- Pair each student with every other student
- This query used to work—what's wrong?
- Reformat this list
- The strange case of copy and paste from Word to Excel
- Combine a dataset with a Power Query conversion table
- Convert a report so it can be sorted and filtered
- Convert records from a matrix to a single column
- Retrieve school mascots from the column
- Look up customer data with XLOOKUP
- Graph the population and format large numbers
- Create a dynamic drop-down list and suppress 0 values
- Filter addresses with the FILTER function
- Find any duplicate or missing names
- Which words end in vowels?
- Power Query split and pivot
- Round times to the nearest 20 minutes
- Extract from the stack
- Assign transactions to months
Taught by
Oz du Soleil