Excel Weekly Challenge
With Oz du Soleil
Liked by 9,897 users
Duration: 16h 55m
Skill level: Beginner + Intermediate
Released: 10/5/2018
Course details
There are countless books and courses that teach Microsoft Excel. However, true mastery requires practice. You have to apply what you've learned in order to make it stick. This series, with Excel MVP Oz du Soleil, provides weekly Excel challenges taken from Oz's experience helping clients with real-world problems. Each video begins with a challenge, such as inconsistent cell formatting, duplicate line items, or incomplete data. Pause the video and download the related exercise file to work out your own solution using the powerful features built into Excel. When you're ready, you can restart the video to see how Oz solves the challenge. In just a few minutes a week, you can learn the most popular and useful Excel formulas, functions, and features. Tune in every Friday for a new technique.
Note: Because this is an ongoing series, viewers will not receive a certificate of completion.
Skills you’ll gain
Meet the instructor
Learner reviews
4.7 out of 5
-
Darsika Srisra
Darsika Srisra
CA finalist | B.com graduate | Currently pursuing US CPA | KPMG
-
Marie Phillips
Marie Phillips
Consumer Safety Inspector at United States Department of Agrciulture
Oh, I would recommend this to anyone that uses excel at all. No matter if you use it a little bit or a lot, this is an excellent course. Even things that I already knew how to do, I learn quicker ways to do. One really helpful thing was that I use this spreadsheet on a weekly basis, where I enter numbers into it and it sums up and gives me totals and volumes, etc. From time to time, I have to go over the spreadsheet because my formulas gets messed up or disappear. Through this course, I learnt that you can keep those formulas from jumping. So that is very helpful. -
EXCEL YOUR WAY
EXCEL YOUR WAY
EXCEL Learning ONLINE Learning
Learning through challenge, training and practical applications is one of the methods that I like, and I see that it is a very practical and useful method through a different instructor in explaining and presenting the challenge and the solution. I think it is an experience worth going into. Thank you.
Contents
-
-
(Locked)
Add new participants to teams2m 21s
-
(Locked)
Format the cells in a form1m 24s
-
(Locked)
Align and adjust text on an order form1m 24s
-
(Locked)
Get a count of possible venues2m 1s
-
(Locked)
Identify and move attendee data3m 20s
-
(Locked)
Combine first and last names2m
-
(Locked)
Clean up bizarre formatting2m
-
(Locked)
Fill in categories and sort2m 3s
-
(Locked)
Add a new list and line it up2m 6s
-
(Locked)
Sort addresses by region1m 28s
-
(Locked)
Help find our perfect home2m 21s
-
(Locked)
Excel in real life: House shopping5m 39s
-
(Locked)
-
-
(Locked)
Prepare this report to be printed2m 1s
-
(Locked)
List and inspect survey results2m 8s
-
(Locked)
Create table of course summaries1m 51s
-
(Locked)
Correct city names1m 4s
-
(Locked)
Fix the pricing formula1m 48s
-
(Locked)
Fill in pick list details3m 40s
-
(Locked)
Create a chart of monthly complaints1m 28s
-
(Locked)
Calculate pay based on hours and location3m 21s
-
(Locked)
Review accuracy of invoice2m 12s
-
(Locked)
Combine three donation lists into one4m 30s
-
(Locked)
Group and sort inventory items2m 16s
-
(Locked)
The expense report is wrong2m 18s
-
(Locked)
Categorize the status of each apartment3m
-
(Locked)
Excel in real life: Auditing inventory4m 37s
-
(Locked)
-
-
(Locked)
Leading zeroes1m 51s
-
(Locked)
Sort and stack2m 35s
-
(Locked)
Fix dates2m 57s
-
(Locked)
Add a shape2m 59s
-
(Locked)
Combo chart with secondary axis1m 48s
-
(Locked)
Horizontal sort2m 34s
-
(Locked)
Set up and format a workbook3m 17s
-
(Locked)
Count addresses2m 50s
-
(Locked)
Fix IDs3m 25s
-
(Locked)
Protect and validate3m 47s
-
(Locked)
Identify at least five problems with this data3m 51s
-
(Locked)
Hide zeroes2m
-
(Locked)
Correct these calculations3m 19s
-
(Locked)
-
-
(Locked)
What is this formula doing?2m 39s
-
(Locked)
Pricing grid and drop-down list3m 42s
-
(Locked)
Write a formula trigger3m 14s
-
(Locked)
Merge and compare lists3m 24s
-
(Locked)
Recreate this graphic5m 5s
-
(Locked)
Insert a happy or sad face3m
-
(Locked)
Conditional formatting and sorting icons2m 35s
-
(Locked)
Crop and print1m 53s
-
(Locked)
Quick access and theme2m 8s
-
(Locked)
Update graphs3m 26s
-
(Locked)
Insert a PivotTable2m 26s
-
(Locked)
Delete transactions and insert a PivotTable2m 58s
-
(Locked)
-
-
(Locked)
Close holes in a list1m 2s
-
(Locked)
QAT and pivot table2m 54s
-
(Locked)
Unpivot and split columns2m 19s
-
(Locked)
Presentations part 1: Randomize4m 5s
-
(Locked)
Presentations part 2: What day is each person presenting?2m 49s
-
(Locked)
Calculate team fees3m 2s
-
(Locked)
Lookup and correct errors2m 47s
-
(Locked)
Calculate final cost and set data validation5m 32s
-
(Locked)
Clear excess images1m 51s
-
(Locked)
Format workbook defaults1m 11s
-
(Locked)
Extract all Saturdays2m 52s
-
(Locked)
-
-
(Locked)
Copy to a new workbook and save as a PDF2m 1s
-
(Locked)
Insert a PivotTable and slicers to review workshop data3m 23s
-
(Locked)
Use Find and Replace to correct names1m 35s
-
(Locked)
Isolate addresses4m 37s
-
(Locked)
Payment errors, part 11m 39s
-
(Locked)
Payment errors, part 24m 32s
-
(Locked)
Change chart type and create summary3m 33s
-
(Locked)
Create drop-down lists2m 59s
-
(Locked)
Explain this sales formula3m 50s
-
(Locked)
Using COUNTIFS with wildcards1m 42s
-
(Locked)
Create an index column1m 32s
-
(Locked)
Create tables and eliminate hyperlinks2m 17s
-
(Locked)
List the top seven donation amounts1m 45s
-
(Locked)
-
-
(Locked)
Get data ready for a PivotTable3m 5s
-
(Locked)
Modify a PivotTable2m 35s
-
(Locked)
Find a Power Query result1m 19s
-
(Locked)
Create a dynamic drop-down list3m 34s
-
(Locked)
Filter venues with dynamic arrays2m 25s
-
(Locked)
Find and restore missing data3m 8s
-
(Locked)
Override names1m 57s
-
(Locked)
Answer four questions about data2m 54s
-
(Locked)
Protect calculations with a shape4m 32s
-
(Locked)
Working with inventory percentages1m 32s
-
(Locked)
Replace highlights with conditional formatting3m 42s
-
(Locked)
Replace "Al" with "Alyssa"2m 51s
-
(Locked)
Apply a spin button3m 24s
-
(Locked)
-
-
(Locked)
Create a custom message in data validation2m 11s
-
(Locked)
Change the parameters of a data validation3m 11s
-
(Locked)
Identify multiple shifts2m 43s
-
(Locked)
Apply conditional formatting icons2m 21s
-
(Locked)
View a worksheet through two windows2m 30s
-
(Locked)
Correct dates to show the weekday, day, month, and year1m 49s
-
(Locked)
Remove the background from an image2m 35s
-
(Locked)
Calculate reimbursements based on a maximum per day4m 1s
-
(Locked)
Sort this data1m 56s
-
(Locked)
Apply formulas to new data2m 30s
-
(Locked)
Clear the formatting in a range of cells1m 46s
-
(Locked)
Transpose data and paste formula2m 3s
-
(Locked)
-
-
(Locked)
Find three ways to extract the item ID3m 11s
-
(Locked)
Write a formula from nothing and create your own data2m 42s
-
(Locked)
Isolate data by the week3m 23s
-
(Locked)
TJ's arts and crafts: How can we improve this workbook?4m 4s
-
(Locked)
Explain this crazy formula and test it5m 18s
-
(Locked)
Please fix this PivotTable3m 26s
-
(Locked)
How many paid days off are available?3m 22s
-
(Locked)
Count flights in a matrix3m 36s
-
(Locked)
Adjust layout2m 37s
-
(Locked)
Sum the salmon dishes2m 5s
-
(Locked)
Event planning formula4m 8s
-
(Locked)
-
-
(Locked)
What's the deal with these payroll calculations?4m 47s
-
(Locked)
Format grid3m 23s
-
(Locked)
Apply two conditional formatting rules3m 30s
-
(Locked)
Tally the number of guests for a party3m 57s
-
(Locked)
Set the footers for printing worksheets2m 44s
-
(Locked)
Who failed one exam or the other, but not both?3m 45s
-
(Locked)
Apply slicers and filter dataset3m 1s
-
(Locked)
Check the quality of survey responses4m 17s
-
(Locked)
Extract names from a dataset3m 27s
-
(Locked)
Change icon colors2m 35s
-
(Locked)
Create a chart and adjust the axis3m 6s
-
(Locked)
Extract sales data1m 36s
-
(Locked)
-
-
(Locked)
Create an order form6m 33s
-
(Locked)
Correct and format dates2m 53s
-
(Locked)
Curriculum audit: Accept reasonable dates4m 4s
-
(Locked)
Create a running total4m 56s
-
(Locked)
Convert liquids3m 19s
-
(Locked)
Office expenses and relationships3m
-
(Locked)
IF AND OR: Identify records of interest2m 53s
-
(Locked)
Use conditional formatting to identify top and bottom values2m 35s
-
(Locked)
Calculate team records and break ties3m 15s
-
(Locked)
Assign random topics to our students3m 6s
-
(Locked)
Insert and format shapes2m 45s
-
(Locked)
Too hot or too cold3m 29s
-
(Locked)
-
-
(Locked)
Several lines: Just one cell3m 33s
-
(Locked)
Distribute the sales data4m 8s
-
(Locked)
Who's unique in this list?3m 10s
-
(Locked)
Repeat a pattern2m 54s
-
(Locked)
Who's on all three lists?3m 33s
-
(Locked)
Show me how to make a drop-down list2m 14s
-
(Locked)
Goals vs. actuals3m 3s
-
(Locked)
Calculate deadlines1m 51s
-
(Locked)
Conditional formatting icons3m 6s
-
(Locked)
Unpivot expenses2m 26s
-
(Locked)
Too many characters: Count characters in a cell2m 47s
-
(Locked)
Filter project data4m 20s
-
(Locked)
-
-
(Locked)
Sorting up, down, left, and right2m 28s
-
(Locked)
How many days are we open?2m 26s
-
(Locked)
Clean up this song list4m 17s
-
(Locked)
Sorting this column isn't working–what's wrong?2m 28s
-
(Locked)
What's going up and what's going down?4m 35s
-
(Locked)
Prep data for a pivot table4m 47s
-
(Locked)
Retrieve prices2m 27s
-
(Locked)
Clean and sort this song list4m 19s
-
(Locked)
Highlight southwest2m 54s
-
(Locked)
Create a drop-down list from table headers2m 37s
-
(Locked)
Summarize your progress3m 13s
-
(Locked)
-
-
(Locked)
Troubleshoot settings for printing3m 18s
-
(Locked)
Identify and correct completion dates3m 24s
-
(Locked)
Append these three datasets5m 15s
-
(Locked)
Filter with Excel's dynamic arrays2m 39s
-
(Locked)
Find two ways to combine these cells5m 10s
-
(Locked)
Who gets paid this month, and who doesn't?4m 15s
-
(Locked)
Build a sentence with variable inputs4m 46s
-
(Locked)
Correct the behavior of these spin buttons2m 52s
-
(Locked)
Identify and isolate distinct entries3m 6s
-
(Locked)
Isolate values and build a chart3m 51s
-
(Locked)
What's wrong with my XLOOKUP?5m 3s
-
(Locked)
Excel Slicers: Insert, format, select1m 53s
-
(Locked)
-
-
(Locked)
After ten rounds, which is the winning team?3m 42s
-
(Locked)
How much more can Kate advance?3m 26s
-
(Locked)
Assign email addresses and check for duplicates2m 39s
-
(Locked)
Identify five problems with this spreadsheet5m 24s
-
(Locked)
Write a sentence with dynamic values3m 31s
-
(Locked)
Print the entire sheet and its charts3m 21s
-
(Locked)
What's the revenue based on revenue share?3m 56s
-
(Locked)
Drop-down lists: Chairs and prices3m 22s
-
(Locked)
PivotTable training3m 50s
-
(Locked)
Write a formula trigger to control calculations4m 10s
-
(Locked)
Identify multipart last names2m 12s
-
(Locked)
Format times and calculate pay2m 56s
-
(Locked)
-
-
(Locked)
Area chart: Up vs. down?3m 38s
-
(Locked)
Create a PivotTable for juniors and seniors3m 25s
-
(Locked)
Clean the source data and fix the PivotTable5m 2s
-
(Locked)
Use the Picture Format tools to improve an image5m 6s
-
(Locked)
Split string of IDs4m 49s
-
(Locked)
Clean data to correct the PivotTable3m 25s
-
(Locked)
Animated color-change emoji6m 16s
-
(Locked)
Find the missing item numbers7m 32s
-
(Locked)
Filter for the car2m 51s
-
(Locked)
Spell out and sort the months3m 9s
-
(Locked)
Use three methods to identify and count empty cells4m 21s
-
(Locked)
Relative cell references and pricing3m 22s
-
(Locked)
-
-
(Locked)
Change the gridlines3m 58s
-
(Locked)
Modify this two-way lookup formula to fit your data3m 10s
-
(Locked)
PJ's 10-mile run3m 44s
-
(Locked)
Calculate the commissions based on increments of $1005m 26s
-
(Locked)
Correct this XLOOKUP2m 36s
-
(Locked)
Count and sort the airport codes4m 27s
-
(Locked)
Change the conditional formatting2m 43s
-
(Locked)
Calculate your out-of-pocket expense3m 2s
-
(Locked)
Highlight the odd-numbered rooms3m 23s
-
(Locked)
Make assignments based on the last name4m 32s
-
(Locked)
-
-
(Locked)
Sort names in Power Query3m 40s
-
(Locked)
Identify the non-donors3m 55s
-
(Locked)
Sort so the strikethrough values are on the bottom2m 18s
-
(Locked)
Simplify the IF formula and create a lookup table5m 21s
-
(Locked)
Total the emoji scores3m 52s
-
(Locked)
Delete unneeded rows2m 35s
-
(Locked)
Identify entries with specific day and time4m
-
(Locked)
Attendance matrix2m 49s
-
(Locked)
Measure the response rate6m 4s
-
(Locked)
Sort city dates2m 15s
-
(Locked)
Attendance queries6m 1s
-
(Locked)
Decrypt the words3m 56s
-
(Locked)
-
-
(Locked)
How much for the beach rental?3m 51s
-
(Locked)
Get data from image9m 49s
-
(Locked)
Quickly answer these questions11m 20s
-
(Locked)
Flag and delete records3m 51s
-
(Locked)
Delete rows and split text3m 55s
-
(Locked)
Tally the project cost2m 25s
-
(Locked)
Accept ID or confirmation number5m 4s
-
(Locked)
Generate random codes5m 23s
-
(Locked)
Count the L names3m 30s
-
(Locked)
Correct double column headers3m 42s
-
(Locked)
Quiz!4m 54s
-
(Locked)
Calculate total loss2m 39s
-
(Locked)
-
-
(Locked)
Calculate the percent change3m 38s
-
(Locked)
How many penalties can be accrued?4m 8s
-
(Locked)
Build your own Pivot Table4m 35s
-
(Locked)
Sort data by last name4m 20s
-
(Locked)
List all available colors5m
-
(Locked)
Build a Venn diagram7m 52s
-
(Locked)
Build an Event Calculator3m 55s
-
(Locked)
Sum the total loss4m 39s
-
(Locked)
Find the missing numbers4m 28s
-
(Locked)
Bring contents into a single cell4m 5s
-
(Locked)
Recycle a query to use on a different dataset3m 23s
-
(Locked)
Paydays that fall on a weekend or holiday4m 45s
-
(Locked)
-
-
(Locked)
Apply slicers to a review class schedule4m 17s
-
(Locked)
Build a bar chart for program attendance5m 42s
-
(Locked)
How many boxes can fit on this shelf?2m 57s
-
(Locked)
Stack names with rows in between3m 11s
-
(Locked)
Create a trivia night calendar6m 38s
-
(Locked)
Tally top scores4m 34s
-
(Locked)
Include filepath on print out2m 51s
-
(Locked)
Add a picture in a PivotTable4m 21s
-
(Locked)
Indent cells4m 42s
-
(Locked)
Change cell borders4m 2s
-
(Locked)
Create a logo and save it6m 36s
-
(Locked)
Convert performer roster5m 37s
-
(Locked)
-
-
(Locked)
Randomize three ways3m 56s
-
(Locked)
Teach me XLOOKUP8m 20s
-
(Locked)
Attendance of Mavis and Benedict5m 10s
-
(Locked)
Book club attendance count2m 23s
-
(Locked)
Create a 12x10 block of numbers with no duplicates3m 17s
-
(Locked)
Identify the top five and bottom five values7m 40s
-
(Locked)
Sort by shift3m 1s
-
(Locked)
Set print layout2m 47s
-
(Locked)
I know the day but need the year2m 9s
-
(Locked)
Filtering vehicles4m 35s
-
(Locked)
Sort pairs of columns2m 10s
-
(Locked)
Find trends using sparklines1m 53s
-
(Locked)
-
-
(Locked)
Highlight every third cell3m 22s
-
(Locked)
Explain the query5m 6s
-
(Locked)
Modify the query3m 36s
-
(Locked)
List the cheeses4m 31s
-
(Locked)
Schedule the meetings3m 31s
-
(Locked)
Append three datasets6m 25s
-
(Locked)
Filter by three criteria5m 1s
-
(Locked)
Convert range to table references3m 37s
-
(Locked)
Control and identify worksheet entries3m 41s
-
(Locked)
Flip this dataset2m 40s
-
(Locked)
Build a table3m 35s
-
(Locked)
Sort by last name3m 55s
-
(Locked)
-
-
(Locked)
Flip the zone2m 43s
-
(Locked)
Payment tracking4m 53s
-
(Locked)
Home scores4m 6s
-
(Locked)
Graph the population1m 22s
-
(Locked)
Win-loss record4m 49s
-
(Locked)
Round winners4m
-
(Locked)
November advances4m 54s
-
(Locked)
Revenue share4m 52s
-
(Locked)
Color choices3m 48s
-
(Locked)
Find the top three2m 51s
-
(Locked)
Calculate overtime1m 50s
-
(Locked)
Determine the new player lineup3m 34s
-
(Locked)
What’s included
- Practice while you learn 293 exercise files
- Test your knowledge 11 quizzes
- Learn on the go Access on tablet and phone