Description

Microsoft Excel Diploma is an accredited online training course. Microsoft Excel is needed in most offices.

Online Microsoft Excel Diploma

Microsoft Excel Courses offers you the opportunity to achieve a Microsoft Diploma in Excel. This will include training at Beginner Level, Intermediate Level plus Advanced Level.

Diploma Objective

We are a Certified Microsoft Office Academy. Our courses enable students to gain the necessary skills needed for everyday tasks. The Excel Diploma is a CPD Accredited. The Diploma is issued to participants on successful completion of the course.

Diploma Format

A Virtual Tutor delivers the online training. The Virtual Tutor will instruct, correct your work immediately and provide examples. This method of training is similar to having your own personal IT trainer. Students find this is a very effective way of delivering interactive online training.

Excel Diploma Content

Beginner Module

  • Getting started with Excel
  • How to format in Excel
  • Formulas / Formatting
  • Tables / Themes
  • Printing
  • Shortcuts and tips to build efficiency
  • Charts
  • Graphics and Illustrations
  • Merging Cells
  • Hiding elements
  • Charts

Intermediate Module

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

Advanced Module

  • Graphics and Illustrations
  • Pivots Tables
  • Pivot Charts
  • Advanced Formulas (VLookup, Date Functions and many more)
  • IF statements, AND and OR
  • Nested, Arrays and Conditions Formulas
  • Scenarios, Goal Seek
  • Auditing and Error Checking
  • Templates and Themes
  • Protecting Workbooks
  • Sharing Workbook
  • Attaching a comment to a Cell
  • Detecting errors
  • Evaluating Formulas
  • Nested Conditions
  • Array formulas
  • Financial Functions
  • Double Data Entry
  • Diffusing Excel Data: PDF, XPS, email, Web page
  • Updating and Managing imported data
  • Tracking changes in a workbook
  • Merging workbooks
  • Finalising a workbook
  • Office Online and Office 365
  • Best practice with a spreadsheet application

Dates and Duration

Training can be completed flexibly. Start date to suit your needs.

Course Requirements

No requirements needed for this course as it is designed to start at beginner level.

CPD Accredited Course

Benefits

  • The training programme was written by Senior Microsoft Trainers at a Microsoft Certified Academy
  • Live help with your own virtual tutor
  • CPD Accredited Microsoft Excel Diploma issued on completion
  • A number of practical exercises are included
  • On completion a CPD Accredited Diploma will be issued by the Microsoft Academy, which will build your CV and career options.