Microsoft® Office - Excel 2016 - Distance Learning Programme

Microsoft® Office – Excel 2016 – Distance Learning Programme

3 day(s)

From: د.إ2,850.00

Description

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

Introduction

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

DAY ONE

  • 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

DAY TWO

  • 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

DAY THREE

  • 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: 11th August 2020

To: 13th August 2020

Duration: 3 day(s)

Location: Online

Microsoft® Office – Excel 2016 – Distance Learning Programme

3 day(s)

From: د.إ2,850.00