Description

This is an accredited Microsoft Excel Diploma that is delivered online. So many jobs will require you to use Microsoft Excel.

If you need to work on your Excel skills, we have the right degree for you.

Microsoft Excel Diploma

Diploma Objective

Our training centre is a Certified Microsoft Office Academy, providing students with all the skills you need for everyday tasks. The Excel Diploma we offer is a CPD Accredited course, meaning this certification is issued to participants upon completion of the course, if successfully completed. CPD is an internationally recognized professional qualification.

Diploma Format

The training is given online, with the help of a virtual teacher. The virtual teacher instructs, corrects and gives examples, to simulate that you have a personal IT trainer. This is a very effective and modern method of delivering interactive online training.

Training available in Dutch or English

Diploma Content

Beginner Module

– Get started with Excel
– How to format in Excel
– Formulas
– Tables
– Print
– Shortcuts and tips for more efficiency
– Graphs
– Graphics and illustrations

Intermediate Module

– Create and customize charts
– Create and manage tables
– Present, sort data in a table
– Automatic calculations in a table, filtering
– Blank cells and duplicates
– Advanced filtering and statistics with a criteria range
– Copy rows filtered by a criteria range
– Display several lines of data in one cell
– Absolute reference in a formula
– Copy values, copy with link, transpose
– Move, copy, hide sheets
– Select, delete, copy and move objects
– Format chart items; Change text items of charts; Legend and plot area; data series and chart axes; Manage series and chart templates
– Create and manage sparklines
– Modify a text box, drawing
– Rotate, align, stack and group objects
– Apply, manage conditional custom formats
– Validation criteria
– Convert data; Create a data series
– Use cell ranges in functions
– Summarize data with an overview
– Add a comment to a cell
– Calculate with copied values.

Advanced Module

– Pivots tables and charts
– Advanced formulas (Lookup, Date functions)
– IF statements, AND and OR
– Nested, Arrays and Conditions Formulas
– Scenarios, Target Search and other advanced features
– Auditing and error checking
– Templates and Themes
– Protect workbooks
– Share workbooks
– Dates and duration

There is a maximum duration of 6 months. The course can be completed well before that time. The course can be started and taken at any time.

Prerequisites for the course

There are no entry requirements for this course. The Diploma starts at beginner level.

Benefits of the course

  • Training written by senior Microsoft Trainers in a Microsoft Certified Academy
  • Live help with your own virtual teacher
  • CPD Accredited Microsoft Excel Diploma issued upon completion
  • A practical course with a number of exercises
  • Upon completion, a CPD accredited degree is issued by the Microsoft Academy, expanding your resume and career opportunities.