Microsoft® Office - Excel 2016 Beginner Level
مايكروسوفت أوفيس - إكسل ٢٠١٦ المستوى المبتدئ

Beginner Level. Maximum of 8 Delegates. Spearhead will provide laptops for all delegates attending this course.

'المستوى المبتدئ. بحد أقصى ٨ متدربين'

Duration: 1 day
Brochure Price: AED 1,300/- + VAT
Online Price: AED 1,235/- + VAT
Who Should Attend? 
This course is ideal for those who would like to be able to work comfortably with Microsoft® Excel 2016. Users who are very new to Microsoft® Excel 2016, and those who are keen to further their basic working knowledge of Microsoft® Excel, would benefit from this course.

About The Programme 
This one-day programme, covers the basics of understanding and using Microsoft® Excel 2016.

Course Objectives 
  • To understand the basics of Microsoft® Excel 2016, and how it differs from previous versions
  • To understand how to navigate efficiently to the relevant tools within the Microsoft® Excel Ribbon
  • To prepare and format Microsoft® Excel sheets
  • To be able to rearrange and filter data 
  • To be able to write simple formulas and functions
  • To use the page setup options to print your data in the required format

What You Will Gain
  • A good working knowledge of Microsoft® Excel 2016
  • Quick and easy ways of creating and formatting your Excel sheets
  • An understanding of how to perform calculations using the various formulas available in Microsoft® Excel
  • The ability to sort, and filter your data, as well as customise the ‘Sort’ and ‘Filter’ functions to suit your needs
  • A list of keyboard shortcuts for frequently used tools, and how to use them to increase speed
  • Knowledge of how to insert links from websites, and other files, into your Excel sheets

Programme Content
  • Getting Started – Spreadsheet Terminology
    > Discussing Spreadsheet Basics; The Excel Environment
    > Examining Excel Window Components
    > Getting Help With Using Excel
    > Managing And Creating Workbooks
    > Saving Workbooks In Different Formats Including PDF
  • Templates And Settings
    > Customising The Quick Access Toolbar
    > Using Built-In Templates
    > Using A Downloaded Template
  • Entering And Editing Data
    > Entering And Editing Text And Values
    > Editing Cell Contents
    > Using AutoFill To Fill A Series
    > Using FlashFill To Repeat Patterns
    > Using The Quick Analysis Tool
    > Navigating A Worksheet Using Keyboard Shortcuts
    > Adding, Editing And Deleting Comments
    > Inserting And Deleting Ranges, Rows, And Columns
    > Hiding And Unhiding Columns And Rows
  • Formatting
    > Formatting Text
    > Formatting A Non-Contiguous Range
    > Using The Format Cells Dialog Box To Format Text
    > Row And Column Formatting
    > Changing Column Width And Row Height
    > Applying Colour To A Row Or Column
    > Applying Borders To Cell Ranges
    > Using The Border-Drawing Pencil
    > Using The Number Group To Format Numbers
    > Exploring The Number Tab In The Format Cells Dialog Box
    > Additional Formatting Options; Copying Formats
    > Using AutoFill To Copy Formatting
  • Managing Large Workbooks
    > Using Multiple Workbooks
    > Switching Between Workbooks
    > Copying Or Moving A Worksheet To Another Workbook
    > Viewing Large Worksheets
    > Locking Rows And Columns
    > Opening And Arranging New Windows
    > Splitting A Worksheet Into Panes
    > Hiding And Unhiding Worksheets
    > Grouping And Working With Multiple Worksheets Simultaneously
    > Naming Worksheets And Colouring Tabs
    > Changing The Order Of Your Sheets
  • Using Formulas And Functions
    > Entering And Editing Formulas; Creating And Editing A Basic Formula
    > Working With The Order Of Operations
    > Entering Functions
    > Entering A SUM Function
    > Using The Mouse To Enter A Function Argument
    > Entering A Function In The Formula Bar
    > Inserting A Function
    > Using AutoSum And Other Common Functions
    > Moving And Copying Data
    > Moving And Copying Data By Using Drag-And-Drop
    > Using The Clipboard Task Pane
    > Moving And Copying Formulas
    > Using AutoFill To Copy A Formula
    > Using Paste Link And Other Paste Special Options
    > Linking Worksheets And Workbooks
    > Examining External Links In A Worksheet
    > Creating External Links In A Worksheet
    > Editing Links
  • Printing
    > Exploring The Different Excel Views
    > Preparing To Print; Defining A Print Area
    > Finding And Replacing Text
    > Previewing A Worksheet
    > Page Setup Options
    > Setting Page Orientation And Scaling
    > Adjusting Margins
    > Creating And Formatting Headers And Footers
    > Inserting Different Even And Odd Headers
    > Printing Large Worksheets; Setting Print Titles And Adjusting Page Breaks

Before the course each delegate will be asked to complete a Pre-Course Questionnaire 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 Investment: AED 1,300/- + VAT, which includes - Training Materials, Lunch and Refreshments. Discount available for multiple bookings.

Date: 18th Nov 2018
Duration: 1 day
Location: Abu Dhabi
Brochure Price: AED 1,300/- + VAT
Online Price:AED 1,235/- + VAT
Duration: 1 day
Brochure Price: AED 1,300/- + VAT
Online Price: AED 1,235/- + VAT
© Copyright 2017 - 2018. Spearhead Gulf LLC. All Rights Reserved.