Excel Weekly Challenge (Updated 3/29/2019)
MP4 | Video: h264, 1280x720 | Audio: AAC, 48 KHz, 2 Ch | Duration: 1h 6m
Genre: Business / Spreadsheets | Language: English + Sub | Size: 170 MB
Level: Beginner | Author: Oz du Soleil
There are countless books, websites, 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 and functions, including VLOOKUP, flash fill, COUNTIFS, relative and absolute cell references, and PivotTables. Tune in every Friday for a new technique. Note: Because this is an ongoing series, viewers will not receive a certificate of completion. HOMEPAGE https://www.lynda.com/Excel-tutorials/Excel-Weekly-Challenge/731731-2.html
TO MAC USERS: If RAR password doesn't work, use this archive program:
RAR Expander 0.8.5 Beta 4 and extract password protected files without error.
TO WIN USERS: If RAR password doesn't work, use this archive program:
Latest Winrar and extract password protected files without error.