You are here: Home > IT Training > Excel Introduction

Excel Introduction

Microsoft Office 2000, 2002, 2003

Next available Norwich date:  05 August 2010
Book Now

Course Aims

This course is designed to give an introduction to the essential aspects of this powerful integrated spreadsheet product from Microsoft. It is entirely 'hands on' and those attending will gain a good basic understanding of spreadsheet production including formatting, editing and printing.

Assumed Knowledge

A basic understanding of PCs, use of a keyboard and mouse plus knowledge of Microsoft Windows is required, gained either by previous experience or by attending a Jarrold Training Getting Started with Computers course.

Version:

Microsoft Office 2000, 2002 and 2003

Excel 2007 Introduction course profile

What people say:

  

Excellent course.

I came to fill in the blanks in my basic knowledge.....objective achieved.

British Sugar - Jan 2010

Special Offer

Book one person onto any two levels of Excel training and receive £30 off the total price.

 

Profile Outline:

Introduction to MS Excel

  • What is a spreadsheet?

Getting Started

  • Starting Excel
  • The Excel screen
  • Menus and shortcut keys
  • Formula bar and name box
  • Sheet tabs and the status bar
  • Active cell, column and row headers
  • Moving around the spreadsheet
  • Exiting Excel

Spreadsheet Basics

  • Creating a new workbook
  • Data types
  • Entering and editing data
  • Entering dates and times
  • Deleting data
  • Undo
  • Selection techniques
  • Saving and closing a workbook
  • Opening a workbook

Cut, Copy and Paste

  • The clipboard
  • Using cut, copy and paste
  • Drag and drop
  • AutoFill
  • Custom lists

Entering Basic Calculations

  • Entering calculations
  • AutoSum
  • Statistical functions

Formatting the Worksheet

  • Working with columns and rows
  • Formatting toolbar
  • Number formats
  • Date and time formats
  • Alignment and orientation
  • Borders and patterns
  • Format painter

Printing

  • Print preview
  • Page setup
  • Page breaks
  • Print titles
  • Printing

Working with Larger Spreadsheets

  • Splitting the screen
  • Freezing panes

Introduction to Charting

  • Creating a chart

DO NOT DELETE THIS TEXT

 

Profile Details:
  • Price: £155.00
  • Duration: 1 day
Norwich Dates:
  • 05 August 2010
  • 18 August 2010
  • 02 September 2010
  • 14 September 2010
  • 29 September 2010
Training Options
People who attended this course, also booked:
Information & print: