Excel Weekly Challenge

New This Week

• Clean data to correct the PivotTable

• Sharpen your Excel skills with hands-on practice

• Add new participants to teams
• Format the cells in a form
• Align and adjust text on an order form
• Get a count of possible venues
• Identify and move attendee data
• Combine first and last names
• Clean up bizarre formatting
• Fill in categories and sort
• Add a new list and line it up
• Sort addresses by region
• Help find our perfect home
• Excel in real life: House shopping

• Prepare this report to be printed
• List and inspect survey results
• Create table of course summaries
• Correct city names
• Fix the pricing formula
• Fill in pick list details
• Create a chart of monthly complaints
• Calculate pay based on hours and location
• Review accuracy of invoice
• Combine three donation lists into one
• Group and sort inventory items
• The expense report is wrong
• Categorize the status of each apartment
• Excel in real life: Auditing inventory

• Leading zeroes
• Sort and stack
• Fix dates
• Add a shape
• Combo chart with secondary axis
• Horizontal sort
• Set up and format a workbook
• Count addresses
• Fix IDs
• Protect and validate
• Identify at least five problems with this data
• Hide zeroes
• Correct these calculations

• What is this formula doing?
• Pricing grid and drop-down list
• Write a formula trigger
• Merge and compare lists
• Recreate this graphic
• Insert a happy or sad face
• Conditional formatting and sorting icons
• Crop and print
• Quick access and theme
• Update graphs
• Insert a PivotTable
• Delete transactions and insert a PivotTable

• Close holes in a list
• QAT and pivot table
• Unpivot and split columns
• Presentations part 1: Randomize
• Presentations part 2: What day is each person presenting?
• Calculate team fees
• Lookup and correct errors
• Calculate final cost and set data validation
• Clear excess images
• Format workbook defaults
• Extract all Saturdays

• Copy to a new workbook and save as a PDF
• Insert a PivotTable and slicers to review workshop data
• Use Find and Replace to correct names
• Isolate addresses
• Payment errors, part 1
• Payment errors, part 2
• Change chart type and create summary
• Create drop-down lists
• Explain this sales formula
• Using COUNTIFS with wildcards
• Create an index column
• Create tables and eliminate hyperlinks
• List the top seven donation amounts

• Get data ready for a PivotTable
• Modify a PivotTable
• Find a Power Query result
• Create a dynamic drop-down list
• Filter venues with dynamic arrays
• Find and restore missing data
• Override names
• Answer four questions about data
• Protect calculations with a shape
• Working with inventory percentages
• Replace highlights with conditional formatting
• Replace "Al" with "Alyssa"
• Apply a spin button

• Create a custom message in data validation
• Change the parameters of a data validation
• Identify multiple shifts
• Apply conditional formatting icons
• View a worksheet through two windows
• Correct dates to show the weekday, day, month, and year
• Remove the background from an image
• Calculate reimbursements based on a maximum per day
• Sort this data
• Apply formulas to new data
• Clear the formatting in a range of cells
• Transpose data and paste formula

• Find three ways to extract the item ID
• Write a formula from nothing and create your own data
• Isolate data by the week
• TJ's arts and crafts: How can we improve this workbook?
• Explain this crazy formula and test it
• Please fix this PivotTable
• How many paid days off are available?
• Count flights in a matrix
• Adjust layout
• Sum the salmon dishes
• Event planning formula

• What's the deal with these payroll calculations?
• Format grid
• Apply two conditional formatting rules
• Tally the number of guests for a party
• Set the footers for printing worksheets
• Who failed one exam or the other, but not both?
• Apply slicers and filter dataset
• Check the quality of survey responses
• Extract names from a dataset
• Change icon colors
• Create a chart and adjust the axis
• Extract sales data

• Create an order form
• Correct and format dates
• Curriculum audit: Accept reasonable dates
• Create a running total
• Convert liquids
• Office expenses and relationships
• IF AND OR: Identify records of interest
• Use conditional formatting to identify top and bottom values
• Calculate team records and break ties
• Assign random topics to our students
• Insert and format shapes
• Too hot or too cold

• Several lines: Just one cell
• Distribute the sales data
• Who's unique in this list?
• Repeat a pattern
• Who's on all three lists?
• Show me how to make a drop-down list
• Goals vs. actuals
• Calculate deadlines
• Conditional formatting icons
• Unpivot expenses
• Too many characters: Count characters in a cell
• Filter project data

• Sorting up, down, left, and right
• How many days are we open?
• Clean up this song list
• Sorting this column isn't working–what's wrong?
• What's going up and what's going down?
• Prep data for a pivot table
• Retrieve prices
• Clean and sort this song list
• Highlight southwest
• Create a drop-down list from table headers
• Summarize your progress

• Troubleshoot settings for printing
• Identify and correct completion dates
• Append these three datasets
• Filter with Excel's dynamic arrays
• Find two ways to combine these cells
• Who gets paid this month, and who doesn't?
• Build a sentence with variable inputs
• Correct the behavior of these spin buttons
• Identify and isolate distinct entries
• Isolate values and build a chart
• What's wrong with my XLOOKUP?
• Excel Slicers: Insert, format, select

• After ten rounds, which is the winning team?
• How much more can Kate advance?
• Assign email addresses and check for duplicates
• Identify five problems with this spreadsheet
• Write a sentence with dynamic values
• Print the entire sheet and its charts
• What's the revenue based on revenue share?
• Drop-down lists: Chairs and prices
• PivotTable training
• Write a formula trigger to control calculations
• Identify multipart last names
• Format times and calculate pay

• Area chart: Up vs. down?
• Create a PivotTable for juniors and seniors
• Clean the source data and fix the PivotTable
• Use the Picture Format tools to improve an image
• Split string of IDs