Microsoft® Office - Excel 2016 – Online Training Programme

Intermediate / Advanced Level. Maximum of 6 Delegates.

Microsoft® Office – Excel 2016 – Online Training Programme

3 day(s)

From: AED2,850.00



*Prior to attending any of the Microsoft® Courses, a Questionnaire and Assessment will need to be completed to ensure the course matches your specific needs.


This course is ideal for those who would like to be able to work comfortably with Microsoft® Excel 2016. Users who have a basic to good understanding and knowledge of Microsoft® Excel, and those who are keen to further their working knowledge of Microsoft® Excel 2016, would greatly benefit from this course.

This three-day programme, begins with the more intermediate levels of Microsoft® Excel 2016 and covers the advanced features of Microsoft® Excel 2016 on Day Two and Day Three.

Course Objectives

  • To understand the new features of Microsoft® Excel 2016, and how it is different from previous versions
  • To be able to use conditional formatting and advanced display options
  • To be able to use Date and Time, Logical, Statistical, and Lookup and Reference functions
  • To be able to create more complex formulas
  • To proficiently use Advanced Charting and the new charts introduced in Excel 2016
  • To be able to forecast using the Forecast Sheet tool
  • To be able to create relationships between multiple datasheets and analyse the combined data using PivotTables and PivotCharts
  • To understand and utilise advanced data management tools like What-If Analysis
  • To be able to secure, protect, and customise your workbook
  • To understand how to create and run macros

What You Will Gain

  • A practical working knowledge of Microsoft® Excel 2016
  • An in-depth understanding of how to work with complex and unfamiliar Functions
  • An understanding of how to create charts and graphs which are available in Microsoft® Excel 2016
  • An awareness of the various analysis tools available in Excel and how to use them
  • A list of keyboard shortcuts for frequently used tools, and how to use them to increase speed
  • Knowledge of how to record frequently used functions using Macros
  • Knowledge of how to protect your worksheets and data

Programme Content


  • Getting Familiar With Excel
    > Using AutoFill And Creating Custom Lists
    > Using FlashFill
    > Using The Quick Analysis Tool
  • Understanding Links
    > Pasting Links
    > Examining And Editing External Links
  • Understanding Absolute, Mixed, And Relative Cell References
  • Using Formulas And Functions
    > Working With The Order Of Operations
    > Inserting A Function
    > Understanding The Syntax Of A Function
    > Date And Time Functions
    > Statistical Functions
    > Logical Functions
    > Lookup Functions
    > Text Functions
    > Nested Functions


  • Conditional Formatting
    > Creating Conditional Formatting Rules Using Formulas
    > Creating Rules To Customise Icon Sets
  • Chart And Sparklines
    > Using The Recommended Charts Option
    > Understanding The Use Of The New Chart Types Offered In Excel 2016
    > Combination Charts
    > Using Sparklines To Understand Trends
  • Creating And Working With Tables
    > Formatting Tables Using Pre-Set Styles
  • Inserting PivotTables And Charts Into Your Excel Sheets
    > Creating A PivotTable
    > Using The Recommended PivotTables Option
    > Applying Conditional Formatting In PivotTables
    > Adding Fields To A PivotTable
    > Changing The Data Source
    > Refreshing The Data In A PivotTable
    > Grouping Data
    > Collapsing And Expanding Fields
    > Using Slicers And Timelines To Filter PivotTable Data
    > Creating Multiple Worksheets From Report Filter Pages
    > Using The Drill Down Feature
    > Build Relationships To Analyse Multiple Tables Together
    > Inserting PivotCharts


  • Macros
    > Recording Macros To Speed Up Frequently Performed Actions
    > Editing And Deleting Macros
    > Copying VBA Code
    > Assigning Shortcut Keys, Buttons Or Controls To Recorded Macros
  • Working With Data Tools
    > Separating Text Into Columns
    > What-If Analysis Tool
    > Forecast Sheet
  • Advanced Data Management
    > Defining Data Entry Rules To Prevent Incorrect Information Being Entered
    > Setting Date And List Validation Rules
    > Circling Invalid Data
  • Protecting Your Workbook
    > Customised Protection For Your Worksheet To Allow Selective Editing
    > Encrypting Your Workbook With A Password
    > Adding Password Protection To Protect Your Workbook Structure
    > Finalising Your Workbook As ‘Read Only’

Before the course each delegate will be asked to complete a Pre-Course Briefing Form to determine their individual objectives for attending the course. These objectives will be used by the Tutor to give on-target training that is focused on the individual delegates.

At the end of the course each delegate will be asked to complete a Personal Development Plan that can be used as part of future appraisals, and that will also be an important tool for management reference.

Total ONLINE Investment: AED 2,850/- + VAT

From: 26th January 2021

To: 28th January 2021

Duration: 3 day(s)

Location: Online

From: 21st February 2021

To: 23rd February 2021

Duration: 3 day(s)

Location: Online

From: 2nd March 2021

To: 4th March 2021

Duration: 3 day(s)

Location: Online

Microsoft® Office – Excel 2016 – Online Training Programme

3 day(s)

From: AED2,850.00