Spearhead Training > Microsoft 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 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 advanced 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 two 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 Contents

    DAY ONE
  • Getting Started - Spreadsheet Terminology
    > Discussing Spreadsheet Basics; The Excel Environment
    > Examining Excel Window Components
    > Getting Help With Using Excel; Navigating A Worksheet
  • Entering And Editing Data
    > Entering And Editing Text And Values
    > Editing Cell Contents
    > Using AutoFill To Fill A Series
    > Entering And Editing Formulas; Creating And Editing A Basic Formula
    > Working With The Order Of Operations
    > Inserting And Modifying A Picture
  • Modifying A Worksheet
    > Moving And Copying Data
    > Moving Data In A Worksheet
    > Copying Data In A Worksheet
    > 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
    > Absolute And Relative References
    > Observing The Limitations Of Relative References
    > Applying Absolute References
    > Inserting And Deleting Ranges, Rows, And Columns
  • Using Functions
    > 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, RANK
  • 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
    > Applying Borders To Cell Ranges
    > Using The Border-Drawing Pencil
    > Using The Number Group To Format Numbers
    > Exploring The Number Tab
    > Creating A Conditional Format
    > Editing And Deleting A Conditional Format
    > Additional Formatting Options; Copying Formats
    > Using AutoFill To Copy Formatting
    > Applying Table Styles And Sorting Data
  • Printing
    > Preparing To Print
    > Finding And Replacing Text
    > Previewing A Worksheet
    > Page Setup Options
    > Setting Page Orientation And Scaling
    > Adjusting Margins
    > Creating And Formatting Headers And Footers
  • Charts
    > Chart Basics
    > Creating A Chart; Moving A Chart Within A Workbook
    > Examining Chart Elements
    > Creating And Editing A Pie Chart
    > Formatting Charts
    > Applying Chart Types And Chart Styles
    > Modifying Chart Elements
  • Managing Large Workbooks
    > Viewing Large Worksheets
    > Locking Rows And Columns
    > Opening And Arranging New Windows
    > Splitting A Worksheet Into Panes
    > Hiding And Unhiding Columns And Worksheets
    > Printing Large Worksheets; Setting Print Titles And Adjusting Page Breaks
    > Inserting Different Even And Odd Headers
    > Working With Multiple Worksheets
    > Naming Worksheets And Colouring Tabs
    > Working and Printing Multiple Worksheets
  • Graphics And Screenshots
    > Conditional Formatting With Graphics
    DAY TWO
  • Using Multiple Worksheets And Workbooks
    > Using Multiple Workbooks
    > Switching Between Workbooks
    > Copying A Worksheet To Another Workbook
    > Linking Worksheets and Workbooks
    > Examining External Links In A Worksheet
    > Creating External Links In A Worksheet
    > Editing Links
    > Managing And Creating Workbooks
  • Outlining And Subtotals
    > Outlining And Consolidating Data
    > Using The Consolidate Command
    > Creating Subtotals
  • Cell And Range Names
    > Creating And Using Names
    > Applying Names To Existing Formulas
    > Managing Names; Modifying And Deleting Named Ranges
  • Tables
    > Sorting And Filtering Data
    > Filtering Data By Using AutoFilter
    > Using Cell Colour And Attributes To Sort And Filter Data
    > Working With Tables; Creating And Formatting A Table
  • Advanced Charting
    > Chart Formatting Options
    > Adjusting The Scale Of A Chart
    > Creating A Combination Chart
    > Creating A Trendline; Inserting Sparklines
    > Using A Chart Template
  • Documenting And Auditing
    > Password-Protecting A Worksheet
    > Unlocking Cells And Protecting Part Of A Worksheet
  • Templates And Settings
    > Customising The Ribbon
    > Using Built-In Templates
    > Using A Downloaded Template

2 Days - Non-Residential

Delegate spaces available on the following course dates:

Date: 25th March » 26th March, 2015
Location: Dubai
Brochure Price: Dhs 2,200/-
Online Price: Dhs 2,090/-
(Save 5% when you book online)
Date: 15th April » 16th April, 2015
Location: Abu Dhabi
Brochure Price: Dhs 2,200/-
Online Price: Dhs 2,090/-
(Save 5% when you book online)
Date: 5th July » 6th July, 2015
Location: Dubai
Brochure Price: Dhs 2,200/-
Online Price: Dhs 2,090/-
(Save 5% when you book online)
Date: 2nd September » 3rd September, 2015
Location: Abu Dhabi
Brochure Price: Dhs 2,200/-
Online Price: Dhs 2,090/-
(Save 5% when you book online)

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,200/- which includes - Training Materials, Lunch & Refreshments. Discount available for multiple bookings.

Find a Course

1) Choose Category:

2) Choose Region

3) Choose Month: