Duration: 1 day(s)
Course Code: XL07L1
Early Bird Courses
London 16th Jan 2018 £191.75 Book
London 19th Mar 2018 £191.75 Book
London 21st May 2018 £191.75 Book
For dates or any further enquiries please call 01344 830100
Price: P.O.A

Microsoft Excel 2007 Level 1

Course Aims

This Microsoft Excel 2007 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. This Excel 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
    Ranges
  • 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
    Formulas

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
    Places
  • 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...

What previous delegates have said about our Excel 2007 Level 1 course

 

"Excellent day that exceeded expectations and really made me think about how to        
improve myself but pass onto other collegues."

Click to expand...