Duration: 1 day(s)
Course Code: XL10L1
Early Bird Courses
London 10th Jul 2019 £198.25 Book
London 23rd Sep 2019 £198.25 Book
London 19th Nov 2019 £198.25 Book
Course Dates Within Next 4 Weeks
London 13th May 2019 Book
Normal price: £305.00+VAT

Microsoft Excel 2010 Level 1

Course Aims

This Microsoft Excel 2010 Level 1 course is aimed at people who want to learn how to use Microsoft Excel to carry out basic spreadsheet tasks including the creation of simple formulas and functions. The course is suitable for either beginners or people with limited experience of the product.

Course Prerequisites

Students who wish to attend this Microsoft Excel course need to be familiar with the use of a PC keyboard and mouse.

Course Objectives

On completion of this Excel training course delegates will be able to:

  • Use formulas for basic calculations
  • Copy and move data
  • Preview and print worksheets
  • Use Page Setup to edit page margins, headers and footers
  • Apply automatic formatting
  • Insert columns and rows
  • Use automatic formatting
  • Create and edit basic charts

Course Content

Using Basic Workbook Skills

  • Creating & Saving a New Workbook
  • Selecting Cells, Entering & Editing Data
  • Opening an Existing Workbook
  • Using Data Entry Shortcuts
  • Renaming an Existing Workbook

Working with Ranges

  • Selecting Adjacent & Non-Adjacent
  • Entering Values Into a Range
  • Using the Auto Fill Feature

Creating Simple Formulas

  • Using Formulas, AutoSum Button
  • Using the AutoSum List
  • Entering & Editing Basic Functions
  • Inserting Functions in Formulas
  • Using the AutoCalculate Feature
  • Using Range Borders to Modify

Copying & Moving Data

  • Copying/Cutting & Pasting Data
  • Using the Paste Options Smart Tag
  • Using the Paste List
  • Using the Clipboard Task Pane
  • Creating an Absolute Reference
  • Using Undo & Redo


Printing & Previewing Worksheets

Using Page Setup

  • Editing Margins, Orientation,
    Alignment, Headers & Footers, Printing
    Gridlines, Repeating Row & Columns
    Labels Scaling a Worksheet, Page
    Break Preview & Setting/Removing a
    Print Area

Formatting Numbers & Text

  • Applying Number Styles & Decimal
  • Character Formatting
  • Rotating, Wrapping & Shrinking Text in
    a Cell
  • Merging Cells & Changing Text Indent
  • Text Alignment & Borders & Fill

Formatting Cells

  • Changing Cell Alignment
  • Creating Cell Borders
  • Using the Fill Colour Button
  • Using the Format Painter Button
  • Inserting & Deleting Selected Cells

Working with Columns & Rows

  • Inserting, Deleting, Adjusting,
    Hiding & Unhiding Rows & Columns

Using Automatic Formatting

  • Cell Styles
  • Themes

Appendix - Creating Charts


Click to expand...

Next Learning Step

The next course in this series is: