Lookup Functions - Including VLOOKUP, HLOOKUP, MATCH, INDEX, COLUMN/S, ROW/S, OFFSET, INDIRECT and CHOOSE.įormula Errors - Debugging and troubleshooting formula errors, and handling errors with IFERROR. Please update it.Ĭonditional Function - Including IF, Nested IFs, IF(OR, IF(AND, IFS, SWITCH, SUMIF/S, AVERAGEIF/IS, COUNTIF/IFS, MINIFS and MAXIFS.

Your browser does not support modern web standards. It's these more advanced techniques that will really set you apart from the crowd.

I cover the fundamentals for each function as well as some less obvious uses for them. I’ve broken the course into logical groups of topics with real world examples taught in short videos (on average 7 minutes long).

Many of the functions are considered advanced, but when you’ve finished the course, you’ll know like I do, that everything is easy once you know how. I’ve designed this course to get you quickly up to speed with the functions that are going to give you the biggest efficiency gains. It’s a slow process with inconsistent results. Mastering Excel formulas can take years by trial and error, picking up tips from colleagues or help you might find on the web.

Excel for Decision Making Under Uncertainty Course.

Excel for Customer Service Professionals.

Excel 2021 online