Microsoft Excel Advanced Certificate

Accreditation

ESS Certificate

Course duration

10 Hours

Certificate valid for

Never expires

Book this course today. Call 0115 8970 529 or click here to send us a message

This Microsoft Excel Advanced Certificate, is a comprehensive course, ideally recommended for those with a firm grasp on the subject matter of both the Beginners and Intermediate courses. This gives you an in-depth look into the full functionality of Excel and its formulae and is an ideal skillset for a plethora of career paths.

Please Note: This course uses the Windows version of Microsoft Office 2016. Any other versions will have some differences in the functions. 

Microsoft Excel Advanced Course Overview

The Microsoft Excel Advanced course will give you a comprehensive look into some of the fundamentals functions and formula of Excel, this includes;

  • VLOOKUP Advanced formula options and manipulations
  • Other advanced functions including OR, AND, CHOOSE, INDIRECT, REPLACE, LEN, LEFT, FIND
  • Functions including CEILING, CORREL, DATEDIF, DATEVALUE, DAVERAGE and EDATE
  • Colouring a column and row with a formula
  • Highlighting a cell with a formula
  • Functions including ISODD, ISNUMBER, ISTEXT, ISLOGICAL, ISNONTEXT, ISERR and ISBLANK
  • Functions including DGET, DMAX, DPRODUCT, DCOUNTA, DCOUNT and DSUM
  • How to calculate depreciation in Excel, including SLN depreciation and SYD depreciation
  • Calculating loan IPMT and EMI
  • Functions including DATEDIF, DATEVALUE, EDATE, EOMONTH, MATCH and INDEX
  • Full explanation of the INDEX and MATCH functions, covering several modules
  • Looking up data
  • Selecting only cells containing comments
  • Hiding formulas
  • Automatically inserting serial numbers

This Excel Intermediate course is broken down into 60 modules. Following completion of these 60 modules, there is a multiple choice test.

On completion of this course, you will receive a Microsoft Excel Advanced certification.