Microsoft Excel 103 - Advanced Level Excel

Become the Ultimate Excel Guru by Mastering Advanced Excel Functions, Macros, Protecting Worksheets and More

Using my 10+ years of Microsoft Excel training I will guide you through some of the most advanced tools Excel has to offer, including;

Create dynamic formulas using Excel's IF(), SUMIF() and IFERROR() functions
Make searching for information in large Excel data sets a breeze by using Excel's powerful VLOOKUP() and HLOOKUP() functions
Learn to manipulate text values by using Excel's LEFT(), RIGHT(), and CONCANTENATE() functions
Master Excel's formula auditing tools to trace errors in your worksheets formulas
Learn how to protect specific cells in a worksheet locking important information
Put Excel on autopilot by learning how to automate your day to day task by using Macros


By engaging and completing this advanced Microsoft Excel course you will master tools that will blow the socks off of your boss and coworkers. You will learn how using these tolls will ultimately streamline you Excel experience boosting your productivity to the highest level.

Each section within this course also includes exercise files for you to download and practice with. These are the same files that are used in the video lectures.