Microsoft Excel 2010 Level 1 Training Course

Fundamentals

Course length – 1 day

Pre-requisites:

There are no pre-requisites for this course apart from general computer knowledge.

Objectives:

  • Create a spreadsheet
  • Working with data
  • Formatting
  • Using calculations and statistical functions
  • Setting up a worksheet to print
  • Manage multiple worksheets
  • Use the help feature

Topics detailed below:

Introducing Excel
  • The Excel screen
  • Using the ribbons, toolbar and backstage view
  • Worksheets and workbooks
  • Creating and saving workbooks
  • Zoom
  • Help
 Working With Data
  • Entering, editing and deleting data
  • Navigating around the workbook
  • Selecting data
  • Moving, copying, deleting, inserting, changing data
  • Inserting and deleting rows/columns
  • AutoFill
Formatting
  • Numbers, dates and text
  • Cell borders and shading
  • Auto format
Using Calculations & Functions
  • Simple calculations
  • Absolute and relative referencing
  • AutoCalculate
  • AutoSum
  • Common functions
  • Moving and copying formulas
Setting Up A Worksheet To Print
  • Headers and footers
  • Paper size and orientation
  • Page breaks
  • Print preview
  • Page layout view
Manage Multiple Worksheets
  • Insert, delete, move, copy worksheets
  • Rename worksheets
  • Worksheet tab colours

Topics not what you require? More information required? Contact us to discuss.

The topics in this course can be mixed and matched with Excel Level 2 and/or Excel Level 3 if required.


Prices

1 to 1 training: £299 + VAT per day
Each additional person: £40 + VAT per day

We come to you.  Courses take place at your offices.