4.3  125 reviews on Udemy

Learn Microsoft Excel Advanced

Learn Microsoft Excel Advanced from Microsoft Certified Trainer
Course from Udemy
 2570 students enrolled
Microsoft Excel advance level

This course is designed for Clerks, Officers, Executives, Supervisors, Administrators, Managers of all levels; and personnel who already know and understand and want to further enhance their knowledge and practical uses of Microsoft Excel.

Basic knowledge of Microsoft Excel is essential with the following pre-requisites:

  • Have attended Microsoft Excel – Foundation and Intermediate Level; OR
  • Able to use and apply Database function
  • Able to use and apply Logical function (IF, AND)
  • Able to use and apply Statistical function (COUNTIF, AVERAGEIF, COUNTIFS, AVERAGEIFS)
  • Able to use and apply Mathematical function (SUMIF, SUMIFS)
  • Able to use and apply Lookup function (VLOOKUP)
  • Able to use Auto and Advanced Filter command
  • Able to validate data
  • Able to apply Conditional Formatting
  • Able to Protect worksheet and workbook

Upon completion of this program, participants should be able to:

  • Advance Chart function and PowerPivot Function
  • Analyze data Using Pivot Tables
  • Perform What If Analysis using:
  • Goal Seek
  • Solver
  • Input Table
  • Scenarios
  • Use VLOOKUP function to extract data
  • Nesting INDEX and MATCH Function
  • Combining & Consolidating Data
  • Create Hyperlink in a workbook

Learn Microsoft Excel Advanced
$ 59.99
per course
Also check at

FAQs About "Learn Microsoft Excel Advanced"


Elektev is on a mission to organize educational content on the Internet and make it easily accessible. Elektev provides users with online course details, reviews and prices on courses aggregated from multiple online education providers.
DISCLOSURE: This page may contain affiliate links, meaning when you click the links and make a purchase, we receive a commission.