Microsoft Excel is a key part of many office roles; it is particularly important to jobs with an element of finance, accounts or bookkeeping. However, many Admin, PA, sales staff and numerous other roles now require proficient level skills in Excel. Many employers will test their new employees on excel skills and will not hire staff who fail to demonstrate Excel skills.

Excel Training Course Objective

To enable students to gain proficient level skills in Excel. Our training centre is a Microsoft Office Academy and this ensures that we deliver all training to the highest level. The Excel Training Course is also a CPD Accredited course, so CPD Certification is issued to staff on completion of the training.

Course Format

The course is delivered using a virtual tutor on a live server. This is a state of the art learning system. The virtual tutor will instruct you and correct your exercises. This standard of interactive learning will enable you to gain from interactive learning. This is available to you on a flexible basis, either online at home or you can take the training in our centre. You can also contact our live tutor at our centre in London for any doubts.

Course Content

Increase your efficiency in Excel

Microsoft Excel Help
Checking spelling, find and replace
Inserting/deleting rows, columns and cells
Moving cells, copying to non-adjacent cells
Copying cell format quickly, merging cells, orientation of cell content
Cell styles
Sorting data

Multiple worksheets and various views

Sheet name, tab colour, inserting, deleting sheets#
Sheet background
Moving, copying, hiding sheets
Splitting the window, freezing a column/row, hiding elements of a sheet
Repeating rows/columns on printed pages

More complex Excel Tables, Formulas and Functions

Merging and Wrapping text
Absolute reference in a formula
Copying values, copying with a link, transposing
Calculating with functions
Control date, date formats
Simple conditions
Custom formats
Applying, managing conditional formats
Naming a range of cells
Validation rules
Multiple cell ranges and calculations in functions

Charts in Excel to present data

Creating and managing a chart
Selecting, adding and removing items in a chart
Formatting chart items
Modifying a chart's text items
Printing and page layout of a chart
Sparklines in Charts
Managing chart options, data series, labels and axes

Visuals in Excel

Creating a drawing object
Selecting and deleting objects
Copying and moving objects
Resizing a drawing object
Modifying a text box
Modifying a drawing
Formatting drawing objects
Inserting a picture
Managing pictures
Rotating and aligning objects
Stacking and grouping objects

Database functionality with an Excel table

Subtotal rows
Automatic calculations in a table
Automatic filtering
Custom filters
Blank cells and duplicates
Advanced filtering with a criteria range
Criteria ranges
Copying rows filtered using a criteria range
Statistics with a criteria range
Flash Fill

Dates and Duration

The course lasts for three months, but can be completed earlier. It can be taken online from anywhere. Learners have an option for one month of training in our training centre.

Course Requirements

You will need to have the full set of skills covered in the Beginner Excel Course. Please look into taking our combined Beginner and Proficient Level Course, if you require some of the Beginner skills.

Course Benefits

Training written by senior Microsoft Trainers from a Microsoft Certified Academy, so the content has been certified to the highest standards
Interactive training from a live server with Virtual Tutor enables learner to receive instruction, as if they have a personal tutor
CPD Accredited Excel Course with a CPD Certificate of Excel Proficiency issued on successful completion
The training is highly practical with numerous exercise to ensure that you remember these details
Professional accredited qualification will build your CV