Description

Our Advanced Microsoft Excel Course has been designed for experienced Excel users to develop expert-level skills.  The course is delivered online and is CPD-accredited. It also provides practical training that enables learners to analyse complex data, automate calculations, build powerful formulas, create professional business reports and much more.

Microsoft Excel is an essential application for many industries and professions. Finance, accounting, bookkeeping, administration, project management, operations, business analysis, marketing, HR, and many other professions require advanced Excel skills. Job seekers are often asked to take Excel tests during the recruitment stage when applying for jobs.

This course is ideal for learners who are looking to enhance their career prospects, prepare for an Excel assessment, gain a professional qualification or simply become more productive at work. This course provides the advanced knowledge employers value.

Advanced Excel Course Online

The main objective of this course is to enable students to gain advanced-level skills in Excel. As a Microsoft Certified Academy offering advanced Excel classes online, you can be sure that all the training, knowledge, and skills you receive are state-of-the-art, and that your training will be delivered to the highest standard. The Advanced Excel Training Course we offer is fully CPD Accredited, and a CPD certificate will be issued to those who pass the course upon completion. The course format is ideal for anyone looking to learn advanced Excel online.

Course Format

The training is delivered online, using a virtual tutor. The virtual tutor instructs, corrects and provides examples to simulate having a personal IT trainer. This is a very effective and up-to-date method of delivering interactive online training.

Learn Advanced Excel Online

Course Content

  • Advanced Data Management

    • Converting data
    • Creating data series
    • Custom views
    • Comments
    • Detecting Errors
    • Data Consolidation
    • Double-entry calculations
    • Data Tables

  • Formula Auditing and Troubleshooting

    • Detecting formula errors
    • Evaluating formulas
    • Using the Watch Window
    • Auditing and troubleshooting formulas

  • Advanced Formulas and Functions

    • Lookup functions, Index Match
    • Logical Functions
    • Advanced Lookup Tables
    • Advanced Text and Date Functions
    • Text joining and editing functions
    • Advanced logical functions
    • Nested functions
    • Dynamic array functions
    • Combining logical functions
    • Formula error handling

  • Business Analysis Tools

    • Goal Seek
    • Solver
    • Scenario Manager

  • Templates and Workbook Customisation

    • Creating, editing and using templates
    • Custom functions
    • Creating hyperlinks
    • custom themes

  • Importing, Exporting and File Formats

    • Publishing workbooks to PDF or XPS
    • Exporting  and importing data
    • Updating and managing imported data
    • Working with Microsoft Excel, Google Sheets, LibreOffice and OpenOffice formats

  • Workbook Management and Security

    • Workbook properties
    • Protecting workbooks
    • Protecting worksheets and their contents
    • Sharing workbooks
    • Finalising workbooks

  • Automation, Macros and Recovery

    • Macros
    • File versions
    • Recovering unsaved and previous workbook versions

Dates and Duration
The course is expected to last an average of 3 months. However, it is possible to complete it in far less time if you study more intensively. You can take up to 12 months to complete the course.

Training can start at any time, and you can study flexibly.

Advanced Excel Course Requirements

You should have Proficient Level skills to take the Advanced Course and earn an advanced Excel certification online. If you lack these skills, please take the Intermediate Excel Course.

Advanced Excel Online

Benefits

  • Training is written by senior Microsoft Trainers in a Microsoft Certified Academy
  • Live server with Virtual Tutor enables learners to receive instruction as if they have a personal tutor
  • CPD Accredited Excel Course with a CPD Certificate issued on successful completion
  • The training is highly practical, with numerous exercises for hands-on learning.
  • As a Microsoft Certified Academy, we can offer internationally recognised Certifications and guarantee the best advanced Excel course online.
  • As a result, we will issue a CPD-accredited certificate from our Microsoft Academy. Advanced Excel skills to add to your CV.