Excel Weekly Challenge

Excel Weekly Challenge

Excel Weekly Challenge is an Beginner level course on Business, crafted by an expert, Oz du Soleil. This course is an essential base for an individual who needs to get better at his/her Business talent. It gives you a strong understanding on Business, Spreadsheets, Excel, Business, Spreadsheets and Excel.

Free Download - Excel Weekly Challenge
Author Oz du Soleil
Publish Date 10/5/2018
Skill Beginner
Duration 3h 28m
Topic Business
Video Tutorials 79
Last Update 4/3/2020

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.

Excel Weekly Challenge : Video Lessons

  • Get data ready for a PivotTable3m 5s
  • Sharpen your Excel skills with hands-on practice1m 38s
  • Add new participants to teams2m 21s
  • Format the cells in a form1m 24s
  • Align and adjust text on an order form1m 24s
  • Get a count of possible venues2m 1s
  • Identify and move attendee data3m 20s
  • Combine first and last names2m
  • Clean up bizarre formatting2m
  • Fill in categories and sort2m 3s
  • Add a new list and line it up2m 6s
  • Sort addresses by region1m 28s
  • Help find our perfect home2m 21s
  • Excel in real life: House shopping5m 39s
  • Prepare this report to be printed2m 1s
  • List and inspect survey results2m 18s
  • Create table of course summaries1m 51s
  • Correct city names1m 4s
  • Fix the pricing formula1m 48s
  • Fill in pick list details3m 40s
  • Create a chart of monthly complaints1m 28s
  • Calculate pay based on hours and location3m 21s
  • Review accuracy of invoice2m 12s
  • Combine three donation lists into one4m 30s
  • Group and sort inventory items2m 16s
  • The expense report is wrong2m 18s
  • Categorize the status of each apartment3m
  • Excel in real life: Auditing inventory4m 37s
  • Leading zeroes1m 51s
  • Sort and stack2m 35s
  • Fix dates2m 57s
  • Add a shape2m 59s
  • Combo chart with secondary axis1m 48s
  • Horizontal sort2m 34s
  • Set up and format a workbook3m 17s
  • Count addresses2m 51s
  • Fix IDs3m 25s
  • Protect and validate3m 47s
  • Find duplicates3m 51s
  • Hide zeroes2m
  • Correct these calculations3m 19s
  • What is this formula doing?2m 39s
  • Pricing grid and drop-down list3m 42s
  • Write a formula trigger3m 14s
  • Merge and compare lists3m 24s
  • Recreate this graphic5m 5s
  • Insert a happy or sad face3m
  • Conditional formatting and sorting icons2m 35s
  • Crop and print1m 53s
  • Quick access and theme2m 8s
  • Update graphs3m 26s
  • Insert a PivotTable2m 26s
  • Delete transactions and insert a PivotTable2m 58s
  • Close holes in a list1m 2s
  • QAT and pivot table2m 54s
  • Unpivot and split columns2m 19s
  • Presentations part 1: Randomize4m 5s
  • Presentations part 2: What day is each person presenting?2m 49s
  • Calculate team fees3m 2s
  • Lookup and correct errors2m 47s
  • Calculate final cost and set data validation5m 32s
  • Clear excess images1m 51s
  • Format workbook defaults1m 11s
  • Extract all Saturdays2m 52s
  • Copy to a new workbook and save as a PDF2m 1s
  • Insert a PivotTable and slicers to review workshop data3m 23s
  • Use Find and Replace to correct names1m 35s
  • Isolate addresses4m 37s
  • Payment errors, part 11m 39s
  • Payment errors, part 24m 32s
  • Change chart type and create summary3m 33s
  • Create drop-down lists2m 59s
  • Explain this sales formula3m 50s
  • Using COUNTIFS with wildcards1m 42s
  • Create an index column1m 32s
  • Create tables and eliminate hyperlinks2m 17s
  • List the top seven donation amounts1m 45s

Recommended video tutorials from YouTube.

  • Excel Weekly Challenge 1 (Employee Shifts)
  • ??? ????? ?? ?????? ???????? :) ?????? ????? ????? ???? ?????? ??? ?? ??????? ????? ?? ???? ???????? ??????...

  • DateTime : 2020-03-22 18:19:16
  • Source : Kabsoolet Excel
  • 52 WEEK-CHALLENGE EXCEL SHEET
  • How to create a 52 week account balance of money saved.

  • DateTime : 2013-05-05 20:39:30
  • Source : meridian2u
  • TECH-011 - Create a calendar in Excel that automatically updates colors by event category
  • Learn a quick trick to automatically change the event colors in your calendar, accordingly to the text you are entering in the different cells. You will use simple ...

  • DateTime : 2017-06-11 20:39:51
  • Source : The Excel Challenge
HELP THE AUTHOR

Please consider buying this course - Excel Weekly Challenge directly from the author - Oz du Soleil. This way you could help the author create more great content, also you may get personal help.

The links being shared are only for poor students who really cannot afford to pay. So, if you are capable of paying please do consider it once before trying the free download links.

Categorised in: , ,

Kindly note, we have recently migrated to a new server. In case of download links not working at all it means that we are undergoing maintenance at the backend. In such case please try after 24 hours. Also make sure your internet connection is persistant else the file may endup corrupted.