Thales Training & Consultancy
Search
Developing People for Success
THALES - Training & Consultancy
Email Thales Traing & Consultancy THALES - Training & Consultancy
Newsletter Sign-up
 
ILM Approved Courses Investor In People
Institute of IT Training
EXCEL MODULE 1 - ESSENTIALS
 
Book this Course Printer Friendly Version
Duration: 1 day
Price: £175.00
Locations Available:
Basingstoke
13 Aug 08
23 Sep 08
10 Oct 08*
03 Nov 08
08 Dec 08
Crawley
19 Aug 08
11 Sep 08*
01 Oct 08
10 Nov 08
01 Dec 08
 

Suitable For

This course introduces the basic features of Excel focusing on creating spreadsheets, adding different types of formula, formatting and printing.  It is aimed at new Excel users who are PC literate.

Objectives

By the end of the course participants will be able to:· 

  • Create, save and print worksheets, e.g. timesheets, sales figures, invoices, etc· 
  • Create different types of formula· 
  • Use basic Excel functions· 
  • Edit and manipulate information· 
  • Format worksheets for professional presentation

 

Related Courses In Our Range· 

  • Excel Module 2 – Gathering & Presenting Data 
  • Excel Module 3 – Data Analysis
  • Excel Module 4 – Advanced Formulas & Functions
  • Excel Module 5 – Advanced Data Management
  • Excel – Pivot Table Expert

Versions Available

2000, XP, 2003 and 2007

All courses marked with * are now available in Microsoft Office 2007 in addition to our usual choice of versions

 

 

 

 

 

 

Course Outline:

Creating a Worksheet

  • Adding text, numbers, dates and times
  • Using automatic features
  • Renaming worksheets
  • Saving a workbook
  • Compatability with earlier Excel Versions (2007 only)
  • Using the Ribbon and the Office Button (2007 only)

Creating Simple Formulas

  • Basic formulas
  • Ordering calculations

Handling Formulas

  • Editing formulas
  • Using absolute references in formulas

Using Basic Functions

  • The function wizard
  • Autocalculate

Working with Workbooks

  • Navigating and editing worksheets
  • Moving and copying 
  • Deleting data
  • Inserting and deleting columns and rows
  • Zoom
  • Freeze panes

Text and Number Formatting

  • Changing text attributes
  • Changing number formats
  • Using list autofill
  • Adjusting column widths and row heights
  • Adding simple borders
  • Using the Mini Toolbar (2007 only)
  • Applying Cell Styles (2007 only)

Printing Worksheets

  • Using print preview
  • Amending page setup options
  • Printing a worksheet
  • Using Page Layout View (2007 only)


Management & People Development Training | Senior Management Development | Training Management Services | Information Technology Training
Technology Training | Health and Safety Training | Thales Case Studies

Home | About Us | Course Booking | Thales News | Site Map
Copyright © 2004 Thales Training & Consultancy. All rights reserved. Site by Fresh Egg Web Design & Search Engine Promotion