Most careers will require at least essential Microsoft Excel experience, but many require advanced Excel skills. The Microsoft Excel Diploma allows learners 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, 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 ensure you are confident in your role.
Excel Diploma
Diploma Format
Our Diploma is delivered on 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 who will instruct you in all lessons, provide exercises, and give you corrections and feedback. This state-of-the-art system provides the personalised interaction needed to gain skills and transfer them back to your job.
Course Content
1. Beginner Level – Excel
Getting Started with Excel
- Essential 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 enter a calculation formula
- Calculating a sum and other essential functions
- Reproducing data in adjacent cells
Increase your efficiency as an Excel user
- Simple numerical formats and checking to spell
- 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 sheet elements.
- Page breaks and print area
- Manipulating your Workbook
Introduction to tables
- Sort data, customise the presentation, copy formatting, and work with an 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 to spell, find and replace
- Inserting/deleting rows, columns and cells
- Moving cells, copying to non-adjacent cells
- Copying cell format quickly, merging cells, the 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, and 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 to all the same just like on personal training
- Numerous practical exercises which provide you with all the needed skills
- Professional accredited qualification to help your CV