From the course: Excel: Advanced Formulas and Functions
Learning advanced formulas and functions using Excel - Microsoft Excel Tutorial
From the course: Excel: Advanced Formulas and Functions
Learning advanced formulas and functions using Excel
- So you know how to use Excel's if and sum functions, but what about using an X lookup with wild cards to identify critical values? What about Excel's other 500 ish functions? And it just keeps growing, the team keeps adding more formulas every day. I'm going to teach you some of the more widely used functions in Excel and show you ways to weave these functions together into robust formulas and solutions. You'll be able to do things faster and work with your data more efficiently. I'm Oz Du Soleil, 11 year Excel MVP, Regular commentator for the Excel World Championships and longtime data analyst. Welcome to Advanced Excel formulas and functions.
Practice while you learn with exercise files
Download the files the instructor uses to teach the course. Follow along and learn by watching, listening and practicing.
Download courses and learn on the go
Watch courses on your mobile device without an internet connection. Download courses using your iOS or Android LinkedIn Learning app.