Excel Power User Challenge

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

New This Week

• Partner advances

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
• Find and follow the instructions
• List every Tuesday in 2022 except for holidays
• Format cells to show degrees in Celsius and Fahrenheit
• Annual gala ticket sales
• Assign the team leads
• Correct the Conditional Formatting
• What percentage of your home is the home office?
• Running totals, splits, and times
• Which room is bigger?
• Identify cells that have strikethrough
• Calculate the next Monday after a given date
• Separate the names from professional designations
• How many trios are in this band?
• Highlight every fifth person in the list
• Calculate the nth mile
• Which of the pairs are anagrams?
• Import from a broken file
• How many states has Elsie been to?
• Calculate the area of a stage for dancers
• Splitting and merging codes using PowerQuery and TEXTJOIN
• Retrieve from a partial string
• Sort the teams by team name
• List the missing numbers
• Set up a workbook to split data onto different sheets
• Custom sorting for work shifts
• Capture the essence of anti-joins
• Identify the months that require two payments
• Extract email domains
• Calculate revenue for a sold-out show
• Find the break-even point
• How many outfits can be made?
• Count based on cell color
• Execute an anti-join
• Determine the longest winning streak
• Create a dual axis graph
• Match the airport with its city
• Look here or look there
• Two source dropdown
• Desired jersey numbers
• Set up a Power Query transformation table
• Create a dropdown list with a warning
• Build a histogram
• Pick from the available songs
• Find the side-by-side duplicates
• PIVOTBY and filter school data
• Hours and ratings