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

Go to class Write review
Coursera Ad

40% Off Career-Building Certificates

Learn More → Scrimba Ad

Free courses from frontend to fullstack and AI

Learn More →

Overview

Coursera Flash Sale
40% Off Coursera Plus for 3 Months!
Grab it
Take your Excel skills to the next level with these advanced challenges from an Excel MVP.

Syllabus

Welcome
  • Excel Power User Challenge
Excel Power User Challenge
  • Deliveries and PivotTables
  • Troubleshoot this query that has a peculiar result
  • Check this data quality for results that don't fit requirements
  • Set up a document to show low-level alerts
  • Write a formula for a two-way lookup
  • Format cells to create ID numbers
  • Parse and summarize data to tally votes
  • Write a SUMIFS formula for three criteria
  • Beautify form with images and print settings
  • Add spin buttons to compare products
  • Restructure the data and write formulas to calculate bonuses
  • Import from folder and tally attendances
  • Create a histogram from the donation data
  • How many full and partial orders can be filled from this inventory?
  • Who owes what for the beach house vacation?
  • Sort dates by day and month to find the birthday with the most people
  • Pizza party calculation
  • Stack this data using Power Query
  • Who has an assignment and who doesn't?
  • Create data validation that only accepts pairs
  • Stack and summarize vendor data
  • Sort titles and ignore A, An, The
  • Unwind this report
  • Two data sets, one relationship, one PivotTable
  • Extract the competition winners
  • Three ways to retrieve data
  • Unstack this list so that it's useful
  • Pair each student with every other student
  • This query used to work—what's wrong?
  • Reformat this list
  • The strange case of copy and paste from Word to Excel
  • Combine a dataset with a Power Query conversion table
  • Convert a report so it can be sorted and filtered
  • Convert records from a matrix to a single column
  • Retrieve school mascots from the column
  • Look up customer data with XLOOKUP
  • Graph the population and format large numbers
  • Create a dynamic drop-down list and suppress 0 values
  • Filter addresses with the FILTER function
  • Find any duplicate or missing names
  • Which words end in vowels?
  • Power Query split and pivot
  • Round times to the nearest 20 minutes
  • Extract from the stack
  • Assign transactions to months

Taught by

Oz du Soleil

Reviews

4.7 rating at LinkedIn Learning based on 234 ratings

Start your review of Excel Power User Challenge

Go to class

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.