Excel Weekly Challenge

New This Week

• Graph the population

Introduction

• Sharpen your Excel skills with hands-on practice

1. Excel Challenges (Oct-Dec 2018)

• 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

2. Excel Challenges (Jan-Mar 2019)

• 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

3. Excel Challenges (Apr-Jun 2019)

• 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

4. Excel Challenges (Jul-Sep 2019)

• 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

5. Excel Challenges (Oct-Dec 2019)

• 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

6. Excel Challenges (Jan-Mar 2020)

• 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

7. Excel Challenges (Apr-Jun 2020)

• 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

8. Excel Challenges (Jul-Sep 2020)

• 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

9. Excel Challenges (Oct-Dec 2020)

• 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

10. Excel Challenges (Jan-Mar 2021)

• 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

11. Excel Challenges (Apr-Jun 2021)

• 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

12. Excel Challenges (Jul-Sep 2021)

• 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

13. Excel Challenges (Oct-Dec 2021)

• 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

14. Excel Challenges (Jan-Mar 2022)

• 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

15. Excel Challenges (Apr-Jun 2022)

• 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

16. Excel Challenges (Jul-Sep 2022)

• 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
• Clean data to correct the PivotTable
• Animated color-change emoji
• Find the missing item numbers
• Filter for the car
• Spell out and sort the months
• Use three methods to identify and count empty cells
• Relative cell references and pricing

17. Excel Challenges (Oct-Dec 2022)

• Change the gridlines
• Modify this two-way lookup formula to fit your data
• PJ's 10-mile run
• Calculate the commissions based on increments of $100
• Correct this XLOOKUP
• Count and sort the airport codes
• Change the conditional formatting
• Calculate your out-of-pocket expense
• Highlight the odd-numbered rooms
• Make assignments based on the last name

18. Excel Challenges (Jan-Mar 2023)

• Sort names in Power Query
• Identify the non-donors
• Sort so the strikethrough values are on the bottom
• Simplify the IF formula and create a lookup table
• Total the emoji scores
• Delete unneeded rows
• Identify entries with specific day and time
• Attendance matrix
• Measure the response rate
• Sort city dates
• Attendance queries
• Decrypt the words

19. Excel Challenges (Apr-Jun 2023)

• How much for the beach rental?
• Get data from image
• Quickly answer these questions
• Flag and delete records
• Delete rows and split text
• Tally the project cost
• Accept ID or confirmation number
• Generate random codes
• Count the L names
• Correct double column headers
• Quiz!
• Calculate total loss

20. Excel Challenges (Jul-Sep 2023)

• Calculate the percent change
• How many penalties can be accrued?
• Build your own Pivot Table
• Sort data by last name
• List all available colors
• Build a Venn diagram
• Build an Event Calculator
• Sum the total loss
• Find the missing numbers
• Bring contents into a single cell
• Recycle a query to use on a different dataset
• Paydays that fall on a weekend or holiday

21. Excel Challenges (Oct-Dec 2023)

• Apply slicers to a review class schedule
• Build a bar chart for program attendance
• How many boxes can fit on this shelf?
• Stack names with rows in between
• Create a trivia night calendar
• Tally top scores
• Include filepath on print out
• Add a picture in a PivotTable
• Indent cells
• Change cell borders
• Create a logo and save it
• Convert performer roster

22. Excel Challenges (Jan-Mar 2024)

• Randomize three ways
• Teach me XLOOKUP
• Attendance of Mavis and Benedict
• Book club attendance count
• Create a 12x10 block of numbers with no duplicates
• Identify the top five and bottom five values
• Sort by shift
• Set print layout
• I know the day but need the year
• Filtering vehicles
• Sort pairs of columns
• Find trends using sparklines

23. Excel Challenges (Apr-Jun 2024)

• Flip the zone
• Highlight every third cell
• Explain the query
• Modify the query
• List the cheeses
• Schedule the meetings
• Append three datasets
• Filter by three criteria
• Convert range to table references
• Control and identify worksheet entries
• Flip this dataset
• Build a table
• Sort by last name

24. Excel Challenges (Jul-Sep 2024)

• Payment tracking
• Home scores