Description

Training in Microsoft Excel Intermediate is an in-depth program to gain professional knowledge that is much needed in every office.

Objective

Learn the most efficient way to use Excel; obtain a CPD accredited certificate at proficient (intermediate) level.

Intermediate Excel Course

Course 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.

Course content

Create and customize charts
Create and manage tables
Presenting, sorting data in a table
Automatic calculations in a table, filtering
Blank cells and duplicates
Advanced filtering and metrics with criteria range
Copy rows filtered with a criteria range
Show multiple lines of data in one cell
Absolute reference in a formula
Copy values, copy with a link, transpose
Move, copy, hide sheets
Select, delete, copy and move objects
Format chart items; Change text items of charts; Legend and stakeout area; data series and chart axes; Manage Series, Chart Templates
Create and manage sparklines
Change a text box, drawing
Rotate, align, stack, and group objects
Apply, manage conditional custom formats
Validation Criteria
Convert data; create a data series
Using cell ranges in functions
Summarize data with an overview
Add a comment to a cell
Calculate with copied values.

Dates and duration

The average learning time is 15 hours. You can start and study at any time according to a flexible schedule.

You have access to the training program for 1 year.

Benefits of the Excel Course

  • CPD Accredited Microsoft Certificate
  • Accredited qualification to enhance your CV and career prospects
  • Internationally recognized qualification
  • Be prepared for any assessment during a job interview
  • Confidence in using Excel effectively at work
  • Working quickly thanks to this extra knowledge
  • Flexible training can be at home or in our academy or a mix
  • Easy-to-use system to make you professionally effective with this software
  • Access to training program for one year

Excel Course Outcome

CPD Accredited Microsoft Certificate in Excel Intermediate upon successful completion.