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

LinkedIn Learning

Excel Challenges

via LinkedIn Learning

Write review
Scrimba Ad

Free courses from frontend to fullstack and AI

Learn More → University of the People Ad

Earn Your CS Degree, Tuition-Free, 100% Online!

Learn More →

Overview

Google, IBM & Meta Certificates – 40% Off
One Coursera Plus subscription covers most Professional Certificates on Coursera.
Unlock All Certificates
Build your Excel skills with challenges taken from Excel MVP Oz du Soleil's experience helping clients with real-world problems.

Syllabus

Excel Challenges
  • Flag forbidden reimbursements
  • Stack and group data
  • Print holiday calendar
  • Rounding bundled products
  • Format and sort birthdates
  • Graph specific complaints
  • How many miles did Terri cycle?
  • Identify specific donors
  • Review data for Power Query
  • Build a grid of fake data for training
  • Choose preferred names
  • Find Valerie in the roster
  • Using checkmarks to check progress
  • Numbers that add to 11
  • Determine the new player lineup
  • Find the top three
  • Color choices
  • Revenue share
  • November advances
  • Win-loss record
  • Home scores
  • Payment tracking
  • Build a table
  • Flip this dataset
  • Control and identify worksheet entries
  • Schedule the meetings
  • List the cheeses
  • Explain the query
  • Find trends using sparklines
  • Set print layout
  • Identify the top five and bottom five values
  • Book club attendance count
  • Attendance of Mavis and Benedict
  • Teach me XLOOKUP
  • Recycle a query to use on a different dataset
  • Find the missing numbers
  • Build an Event Calculator
  • How many penalties can be accrued?
  • Accept ID or confirmation number
  • Quickly answer these questions
  • How much for the beach rental?
  • Measure the response rate
  • Sort so the strikethrough values are on the bottom
  • Make assignments based on the last name
  • Calculate your out-of-pocket expense
  • PJ's 10-mile run
  • Animated color-change emoji
  • Clean data to correct the PivotTable
  • Write a formula trigger to control calculations
  • Clean and sort this song list
  • Retrieve prices
  • Too hot or too cold

Taught by

Oz du Soleil

Reviews

4.7 rating at LinkedIn Learning based on 329 ratings

Start your review of Excel Challenges

Never Stop Learning.

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

Sign up for free
Someone learning on their laptop while sitting on the floor.