Etopia Computer Training
IT Computer Training Experts

Upcoming Courses

Call for any late availability offers on these upcoming courses.

Training Room Hire

Our Glasgow training room facilities are available for hire.

Microsoft Excel Fundamentals 2002/3

Duration:1 day
Price:£199.00
Locations:Glasgow, Edinburgh
Glasgow Dates:Fri 10th Sep 10,  Mon 11th Oct 10,  Mon 8th Nov 10,  Tue 7th Dec 10
Edinburgh Dates:Fri 10th Sep 10,  Mon 8th Nov 10

One Day Course

This course is aimed at people who have access to Microsoft Excel and would like to learn how to create spreadsheets and have a fundamental understanding of some of Excel's abilities to manipulate data.

Course Aims to enable delegates to:

Understand the ability and uses of Excel to produce spreadsheets. The training is intended for anyone wishing to use Microsoft Excel while currently unfamiliar with the application.

Course Content

Excel Basics

  • Spreadsheet terminology
  • Exploring the Excel window
  • Opening and navigating a workbook
  • Closing a workbook

Entering and Editing Data

  • Creating a new Excel Workbook
  • Entering and Editing labels and values
  • Entering and editing formulas
  • Saving and updating a workbook

Printing

  • Preparing to print
  • Page Setup options

Using Functions

  • Entering Functions
  • Using Autosum
  • Using Average, Min, Max and Count

Formatting Worksheets

  • Formatting text
  • Formatting rows and columns
  • Number formatting
  • Other formatting features

Creating Charts

  • Creating a chart
  • Printing charts

Web Features

  • Saving a worksheet as a web page
  • Adding hyperlinks
  • Sending a workbook via email

 

Follow-on Courses

Microsoft Excel Intermediate, Microsoft Excel Advanced

Requirements before booking this course:

People coming on the course should either have attended a Windows course or should have knowledge to an equivalent level – that is to be to use a keyboard and mouse, navigate in Windows, launch applications and understand how data is filed on a computer

Notes

Training is available on all versions