Take your Excel skills to the next level with these advanced challenges from an Excel MVP.
Overview
Syllabus
New This Week
- Partner advances
- 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
Taught by
Oz du Soleil
