Need help?

+44 20 7248 8987

Proficient Excel – CPD Accredited

£79.00

Short Description

499 in stock

SKU: EXONC Category:

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.

Related Courses