Microsoft Excel 103 - Advanced Level Excel

MP4 | Video: AVC 1280x720 | Audio: AAC 44KHz 2ch | Duration: 3 Hours | 783 MB

Genre: eLearning | Language: English

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.