Training in Microsoft Excel Intermediate is an in-depth program to gain professional knowledge which is much needed in any office.
Objective
To learn the most efficient way to use Excel; to gain a CPD Accredited Certificate at Proficient (Intermediate) level.
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.
Course Content
- Create and customise 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 using a criteria range
- Display several lines of data in one cell
- Absolute reference in a formula
- Copy values, copy with a link, transposing
- Move, copy, hide sheets
- Select, delete, copy and move objects
- Format chart items; Modify chart’s text items; Legend and plot area; Data series and chart axes; Manage series, 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
- Summarise data with an outline
- Attach a comment to a cell
- Calculate with copied values.
Dates and Duration
Please email or telephone to arrange a start date with induction. It is recommended that you take your assessment within three months in order to obtain a CPD Accredited Microsoft Certificate (included in the price). You have access to the training program for 1 year. Course Requirements There is no special entry requirement.
Benefits of Excel Proficient Course
- CPD Accredited Microsoft Certificate
- Accredited qualification to boost your CV and job options
- Being prepared for any assessment at job interview
- Confidence in the use Excel effectively at work
- Work quickly because of this additional knowledge
- Flexible training can be at home or at our academy or a mix
- User friendly system to make you professionally effective with this software
- Access to training program for one year
Outcome
CPD Accredited Microsoft Certificate in Excel Intermediate on successful completion.