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.