تفاصيل الدورة

Unleash Your Microsoft Excel Skills to an Advanced Level

Course Material Works in Excel 2007, 2010, 2013 and 2016

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.

So, what are you waiting for, enroll now and take the next step in mastering Excel and become an Advanced Excel Guru!


تحديث بتاريخ 27 December, 2017
دورات يمكنك الالتحاق بها على الفور... خذ دورة عبر الإنترنت على Soft Skills ابتداءً من الآن. See all courses