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

LinkedIn Learning

Excel Power User Challenge

via LinkedIn Learning

Write review
Coursera Ad

Learn AI, Data Science & Business — Earn Certificates That Get You Hired

Learn More → Boot.dev Ad

The Most Addictive Python and SQL Courses

Learn More →

Overview

Syllabus

Welcome
  • Excel Power User Challenge
Excel Power User Challenge
  • Three friends, one vacation
  • Can this data be useful?
  • Calculate who's late
  • Sandwich shop combo
  • Expense summary
  • Pizza party calculation
  • Sort titles and ignore A, An, The
  • Extract the competition winners
  • Two data sets, one relationship, one PivotTable
  • Retrieve school mascots from the column
  • Annual gala ticket sales
  • Create data validation that only accepts pairs
  • Assign the team leads
  • Correct the Conditional Formatting
  • How many trios are in this band?
  • Calculate the nth mile
  • Which of the pairs are anagrams?
  • How many states has Elsie been to?
  • Count based on cell color
  • Determine the longest winning streak
  • Build a histogram
  • Desired jersey numbers
  • Look here or look there
  • Find the side-by-side duplicates
  • Fix the FILTER formula
  • Sort moons
  • Who bought none?
  • Bottom-up XLOOKUP
  • Stop the clopen
  • Remove no-shows
  • Reimbursement limit
  • Compare attendance lists
  • Tally wins and losses across worksheets
  • Match Zodiac Signs
  • Assign rooms
  • Who owes what for the beach house vacation?
  • Match the airport with its city
  • Create a dual axis graph
  • How many outfits can be made?
  • Find the break-even point
  • Custom sorting for work shifts
  • Retrieve from a partial string
  • Calculate the next Monday after a given date
  • What percentage of your home is the home office?
  • Round times to the nearest 20 minutes
  • How many full and partial orders can be filled from this inventory?

Taught by

Oz du Soleil

Reviews

4.7 rating at LinkedIn Learning based on 598 ratings

Start your review of Excel Power User Challenge

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.