Spearhead Training > Microsoft Office Courses > Microsoft® Office - Excel 2010 Level 1

Microsoft® Office - Excel 2010 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 improve their basic working knowledge of Microsoft® Excel, would greatly 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

  • Understand the basics of Microsoft® Excel 2010, and how it differs from previous versions
  • Understand how to navigate efficiently to the relevant tools within the Microsoft® Excel Ribbon
  • Prepare and format Microsoft® Excel sheets
  • Review the various formulas available in Microsoft® Excel, and how they can be used
  • Use data within a sheet to create charts and graphs
  • Review the various chart and graph options available in Microsoft® Excel, and how they can be used
  • Be able to rearrange and filter data
  • Be able to insert media into Excel sheets, charts, etc.
  • 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

  • Basic 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
  • 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
    >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
  • 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
    >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
    >Encrypt Workbook With A Password

2 Days


Delegate spaces available on the following course dates:

Date: 5th April » 6th April, 2017
Location: Dubai
Brochure Price: Dhs 2,600/-
Online Price: Dhs 2,470/-
Date: 20th August » 21st August, 2017
Location: Dubai
Brochure Price: Dhs 2,600/-
Online Price: Dhs 2,470/-

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 Investment: AED / QR 2,600/- which includes - Training Materials, Lunch and Refreshments. Discount available for multiple bookings.

Find a Course

1) Choose Category:

2) Choose Region

3) Choose Month: