Description

The IEAA Accredited Microsoft Excel Diploma offers our delegates the ability to use Excel. The Diploma enables our learners to learn advanced Excel skills will enable. This is a fundamental skill for a modern Executive Assistant. We offer the Excel Diploma in partnership with a Certified Microsoft Academy.

Training Format

All training is delivered online.  This interactive online training programme is provided in partnership with Microsoft Platinum Partners. This module is a flexible study schedule. You can start at any time and study when you would like.

The learning system contains a virtual tutor function that will instruct you on the lesson you are taking. It provides examples and practical exercises. The virtual tutor function will also offer corrections to any of your mistakes. It is truly interactive online learning.

Microsoft Excel Diploma

Course Content

The Microsoft Excel Diploma includes Beginner, Intermediate and Advanced Level Excel courses. You can learn at your own pace.

Beginner Level Excel

  • The function of Excel
  • Formatting in an Excel Workbook
  • Calculations in Excel
  • Calculating a sum
  • Starting level functions
  • Gain efficiency in Excel
  • Find and replace
  • Inserting/deleting/moving rows, columns and cells
  • Print an attractive document
  • Date formats
  • Merging and wrapping
  • 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.
  • Splitting the window, freezing a column/row
  • Tables and Charts
  • Subtotal rows; advanced filtering options

Intermediate Level Excel

  • Increase your efficiency in Excel
  • 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, and 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, and creating and managing a chart
  • Selecting, modifying, adding and removing items in a chart
  • 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, and copying and moving objects
  • Resizing a drawing object
  • Modifying a text box
  • Modifying and formatting drawing objects
  • Inserting a picture
  • Managing pictures
  • Rotating and aligning objects
  • Database functionality with an Excel table
  • Subtotal rows
  • Automatic calculations in a table and filtering
  • Custom filters
  • Stacking and grouping objects
  • 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

Advanced Excel Module

  • Pivots Tables and Pivot Charts
  • IF AND and OR statements, AND and OR
  • Nested, Arrays and Conditions Formulas
  • Advanced Formulas (VLookup, Date Functions and many more)
  • What If Scenarios
  • Goal Seek
  • Advanced functions
  • Auditing and Error Checking
  • Templates and themes
  • Protecting workbooks
  • Sharing workbooks

Other training options

We offer general Microsoft Office Diplomas for Executive Assistants if you prefer to cover more Microsoft Office programmes.

When can I start?

Flexible study is an online interactive training system that enables you to start or study anytime.

Course Requirements

Each learning module starts at the beginner level. All you need is a reliable internet connection.

Advantages of this course

  • Gain a professional qualification to build your resume
  • Experts have designed excel lessons in the subject
  • Advanced Excel skills open so many doors for a modern Executive Assistant
  • Gain from high-quality Microsoft Office training provided by a specialist training provider, a Microsoft Platinum Partner
  • IEAA accreditation for the certificates
  • Enhance your career options and employability