LinkedIn LearningExcelFree courseBeginner levelCertificate

Excel Weekly Challenge

0.0

Produced in 2018

Course Description

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.

Beginner Level

Time: 2h 4m

Instructor Details

Oz du Soleil

Oz du Soleil is an Excel MVP, author, and trainer with a passion for clean data and reliable reporting.

An even greater passion is that of teaching, sharing knowledge, and empowering people to handle their data more efficiently and with greater skill. Over the past 6 years, Oz has been teaching public and private workshops and giving presentations. He has presented at Northwestern University, University of Illinois at Chicago, IgniteChicago, and ExcelTV, and at various Excel and data conferences in Toronto; Amsterdam; San Jose; Portland, Oregon; and Chicago, Illinois.

His book, Guerrilla Data Analysis Version 2, condenses some of that knowledge. Through his popular YouTube channel, Excel on Fire, he trains students to use Excel more effectively and access more of Excel's features. Find out more at https://ozdusoleil.com/.