Microsoft Excel Diploma – CPD Accredited

£149.00

Product Total: 149

Most careers will require at least essential Microsoft Excel experience, but many require advanced Excel skills. The Microsoft Excel Diploma offers learners the ability to gain advanced skills in Excel. This will open many opportunities.

Souters also offer learners the ability to gain a professional qualification from CPD Standards, which is the Microsoft Excel Diploma. The Microsoft Excel Diploma combines all levels of training:

  • Beginner Level
  • Intermediate Level
  • Advanced Level

Our accredited online training courses will give you an in-depth knowledge of Microsoft Excel to make sure that you are confident in your role.

Excel Diploma

Diploma Format

Our Diploma is delivered on an interactive online software that enables interactive learning. All of the training material was written by Microsoft Platinum Partners. The learning system contains a virtual tutor that will instruct you in all lessons, provide exercises and gives you corrections and feedback. This state of the art system provides the persoanlised interaction needed to gain skills and transfer them back to your job.

Course Content

1. Beginner Level – Excel

Getting Started with Excel
  • Basic within new workbooks and an overview of the functionalities of Excel
  • Formatting in an Excel Workbook
  • Formatting font; formatting cells; borders; colours, highlighting
  • Copying, cutting, pasting and other formatting issues in Excel
Calculations in Excel
  • Set out your first Excel calculation and entering a calculation formula
  • Calculating a sum and other basic functions
  • Reproducing data in adjacent cells
Increase your efficiency as an Excel user
  • Simple numerical formats and checking spelling
  • Find and replace
  • Inserting/deleting/moving rows, columns and cells
  • Copying to non-adjacent cells; how to merge cells; change cell style; change the orientation of cell content
Print an attractive document
  • Page layout; print preview and printing
  • Repeating row/column headings on printed pages; headers and footers; hiding elements of a sheet
  • Page breaks and print area
  • Manipulating your Workbook
Introduction to tables
  • Sort data, customise the presentation, copy formatting, and work with automatic date.
  • Date formats
  • Splitting the window, freezing a column/row
  • Tables and Charts
  • Subtotal rows; advanced filtering options

2. Intermediate Level Excel

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

3. Advanced Excel Module

  • 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
  • Other advanced functions
  • Auditing and Error Checking
  • Templates and themes
  • Protecting workbooks
  • Sharing workbooks

Accreditation

We are a Certified Microsoft Office Academy. Our Excel Diploma is a CPD Accredited. After successful completion, every student is provided with the CPD Accredited Microsoft Excel Diploma.

Benefits

  • Training made by experts: senior Microsoft Trainers from a Microsoft Certified Academy
  • CPD Accredited Excel Diploma
  • Receiving a CPD Certificate provides an internationally recognised qualification
  • Virtual training with an expert, which enables you with all the same just like on personal training
  • Numerous practical exercises which provide you with all needed skills
  • Professional accredited qualification to help your CV