Excel Power User Challenge

Take your Excel skills to the next level with these advanced challenges from an Excel MVP.

Welcome

• Excel Power User Challenge

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