IMPROVING BUSINESS PERFORMANCE
MAXIMUM OF 12 DELEGATES ON EVERY FACE-TO-FACE PUBLIC COURSE!
MAXIMUM OF 8 DELEGATES ON EVERY DISTANCE LEARNING PUBLIC COURSE!
IN-COMPANY
DOWNLOADS
UPCOMING COURSES
BOOK ONLINE
UPCOMING COURSES
BOOK ONLINE
IN-COMPANY
DOWNLOADS

Microsoft® Office - Excel 2016
مايكروسوفت أوفيس - إكسل ٢٠١٦


(Currently Being Offered Online)

During the COVID-19 crisis, a number of our programmes will be offered online with reduced hours and a reduced investment, but with maximum effectiveness.
Please contact us for specific details on the courses we are running. Our Business Development Staff will be happy to provide you with further details.
Duration: 2 days
Online Course Price: AED 2,850/- + VAT
Regular Price: AED 3,900/- + VAT

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

 

During the COVID-19 crisis, a number of our programmes will be offered online with reduced hours and a reduced investment, but with maximum effectiveness.

Please contact us for specific details on the courses we are running. Our Business Development Staff will be happy to provide you with further details.

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.

Date: 28th - 30th Jun 2020
Duration: 3 days
Location: Online
Online Course Price: AED 2,850/- + VAT
Regular Price:AED 3,900/- + VAT
Duration: 2 days
Online Course Price: AED 2,850/- + VAT
Regular Price: AED 3,900/- + VAT


© Copyright 2020. Spearhead Gulf LLC. All Rights Reserved.