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

Microsoft® Office - Excel 2013 Level 1
مايكروسوفت أوفيس - إكسل ٢٠١٣ المستوى الأول


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

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

Who Should Attend? 
This course is ideal for those who would like to be able to work comfortably with Microsoft® Excel. Users who are very new to Microsoft® Excel, and those who are keen to further their basic working knowledge of Microsoft® Excel, would benefit from this course.

About The Programme
This two-day programme covers the basics of Microsoft® Excel on Day One, and looks at intermediate topics on Day Two. Delegates who feel they already have a basic working knowledge of Microsoft® Excel, or are familiar with some Day One topics, should view Day One as a ‘refresher’.

Course Objectives
  • To understand the basics of Microsoft® Excel 2013, 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 review the various functions available in Microsoft® Excel, and how they can be used
  • To use data within a sheet to create charts and graphs
  • To review the various chart and graph options available in Microsoft® Excel, and how they can be used
  • To be able to rearrange and filter data 
  • To be able to insert media into Excel sheets, charts, etc.
  • To use the Protect Function for your sheet and workbook, and know how the Protect Function can be applied to different elements of a Microsoft® Excel sheet

What You Will Gain
  • A good working knowledge of Microsoft® Excel
  • 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
  • An awareness of the types of charts, graphs, pictures, etc., that can be inserted into your Excel sheets, and how they can be formatted
  • 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

DAY ONE
  •  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
    > Using AVERAGE, MIN, MAX, COUNT, COUNTA, COUNTBLANK
    > Absolute And Relative References
    > Observing The Limitations Of Relative References
    > Applying Absolute References
  • Graphics And Screenshots
    >Inserting And Modifying A Picture, Shape, SmartArt, And Screenshot
DAY TWO
  •  Modifying A Worksheet
    > 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
  • Outlining And Subtotals
    > Outlining And Summarising Data
    > Creating And Removing Subtotals
  • Conditional Formatting
    > Creating A Conditional Format
    > Editing And Deleting A Conditional Format
    > Creating Rules To Customise Icon Sets
  • Tables
    > Working With Tables; Creating And Formatting A Table
    > Applying Table Styles
    > Sorting And Filtering Data
    > Using Cell Colour And Attributes To Sort And Filter Data
  • Charts
    > Chart Basics; Selecting Data
    > Using Recommended Charts Option
    > Creating A Chart
    > Moving A Chart Within A Workbook
    > Examining And Modifying Chart Elements
    > Creating And Editing A Pie Chart
    > Formatting Charts
    > Applying Chart Types And Chart Styles
    > Adjusting The Scale Of A Chart
    > Creating A Combination Chart
    > Creating A Trendline; Inserting Sparklines
    > Using A Chart Template
  • 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
  • Documenting And Auditing
    > Password-Protecting A Worksheet
    > Unlocking Cells And Protecting Part Of A Worksheet
    > Password-Protecting A Workbook
    > Encrypting Workbook With A Password

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 2,600/- + VAT (applicable as of 1st January 2018), which includes - Training Materials, Lunch and Refreshments. Discount available for multiple bookings.



Date: 20th - 21st Dec 2017
Duration: 2 days
Location: Dubai
Brochure Price: AED / QR 2,600/-
Online Price: AED / QR 2,470/-
© Copyright 2017 - 2018. Spearhead Gulf LLC. All Rights Reserved.