Class Central is learner-supported. When you buy through links on our site, we may earn an affiliate commission.

LinkedIn Learning

Excel Weekly Challenge

via LinkedIn Learning

Overview

Prepare for a new career with $100 off Coursera Plus
Gear up for jobs in high-demand fields: data analytics, digital marketing, and more.
Build your Excel skills, one week at a time. Accept a new challenge every Friday to learn and practice Excel.

Syllabus

New This Week
  • Clean data to correct the PivotTable
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

Taught by

Oz du Soleil

Reviews

4.6 rating at LinkedIn Learning based on 220 ratings

Start your review of Excel Weekly Challenge

Never Stop Learning.

Get personalized course recommendations, track subjects and courses with reminders, and more.

Someone learning on their laptop while sitting on the floor.