Tools
You are here: Home » Training Courses » Microsoft » Excel » Excel 2007
Tuesday, 23 Oct 2018

Microsoft Excel 2007 - Introductory

Course Objectives

This one day course will cover all the basic commands of this powerful application. The topics introduced include an introduction to the spreadsheet, the graphics capabilities, and the database handling commands.

The broad objectives are to make clients aware of the full possibilities of the program and to give clients confidence to operate the program themselves.

Who Should Attend?

This course is designed for computer users with little or no previous experience of Excel, but who require a basic understanding of the product.

Some knowledge of computer basics and working with Windows is expected. The topics covered on our "Introduction to Microsoft Windows" course are an adequate prerequisite for this course.

Course Contents

Tour of the Excel screen

Navigating in a Worksheet

Entering Data

  • Entering Formulae
  • Order of Mathematical Operators in Formulae
  • Editing a Cell
  • Entering a formula using the Pointing Technique

Excel's Functions

  • Sum, average, max & min
  • AutoCalculate

Autofill

  • Creating sequences
  • Custom Lists
  • Copying Formula

File Commands

  • Create, save, open close and delete a file

Printing

  • Understanding the print options

Explanation of how Excel oganises data for charting

  • Creating a Chart
  • Choosing Chart Types
  • Inserting Titles
  • Choosing the location of the chart

Modifying the chart type etc. once the chart has been created

Formatting the Chart

  • Changing the appearance of chart elements
  • Creating a chart with two data series

Chart "extras"

  • Adding text boxes & arrows
  • Altering the scale of axes

Databases

  • Sorting
  • Searching using the Autofilter command
  • Using the Sub-totals command

Microsoft Excel 2007 Course DetailsDownload Course Details

(Page 2 of 5)

Contact Us

Telephone : 0117 929 1509
Send us a message or request a call back

1000 characters left

Microsoft Excel 2007 Courses

There are no courses scheduled