Description

Microsoft Excel Courses offers training in Microsoft Excel Advanced Level. This training is beneficial in order to gain professional knowledge which is an essential requirement in any office.

Objective

Excel Courses offer CPD Accredited Certificate at Advanced on successful completion of the course.

Course Format

A Virtual Tutor delivers the Excel training in an online format. The Virtual Tutor will instruct, correct and also give examples. This is very much like having your own personal IT Trainer. This method of delivering interactive online training is the most effective and up-to-date method of training.

Course Content

Advanced Module

  • Graphics and Illustrations
  • Pivots Tables
  • Pivot Charts
  • Advanced Formulas (VLookup, Date Functions and many more)
  • IF statements, AND and OR
  • Nested, Arrays and Conditions Formulas
  • Scenarios, Goal Seek
  • Auditing and Error Checking
  • Templates and Themes
  • Protecting Workbooks
  • Sharing Workbook
  • Attaching a comment to a Cell
  • Detecting errors
  • Evaluating Formulas
  • Nested Conditions
  • Array formulas
  • Financial Functions
  • Double Data Entry
  • Diffusing Excel Data: PDF, XPS, email, Web page
  • Updating and Managing imported data
  • Tracking changes in a workbook
  • Merging workbooks
  • Finalising a workbook
  • Office Online and Office 365
  • Best practice with a spreadsheet application

Dates and Duration

You may start at any time to suit you. Assessment and certification are included in the price. You have access to the training program for 1 year.

Course Requirements

You need to have completed the Intermediate Excel Course or be confident that you already possess Intermediate Level Excel skills. Consult us if in doubt about the best option.

Benefits of Excel Advanced Course

  • CPD Accredited Microsoft Certificate
  • Accredited qualification to boost your CV and job options
  • Prepared for any assessment at a job interview
  • Confidence in the use of Excel at work
  • Work quickly because of this additional knowledge
  • Flexible training can be at home/work or at any time
  • User-friendly system to make you professionally effective with this software
  • Access to the training program for one year

Outcome

CPD Accredited Microsoft Certificate in Excel Advanced on successful completion.