x

Contact Us


Please fill out this form to send us an enquiry.





01489 588453
Contact Us
Contact Us
icon

Project Management

icon

IT Courses

icon

Business Skills

Health & Safety

Microsoft Excel 1 - 2003

Print Page


Level Introduction
Date/Venue 25/08/10 - Salisbury
02/09/10 - Southampton
14/09/10 - Basingstoke
Duration 1 day
Time 09:30 to 16:30
Price Net - £150.00
VAT - £26.25
Gross - £176.25

Enquire

Introduction
 
You need to understand how to use the basic functions of Microsoft Excel 2003. You may have used Microsoft Excel in your job or be new to Microsoft Excel, but have never been given any formal training in setting up a spreadsheet, manipulting its data and editing its content. This course will cover the basics relating to spreadsheets with an aim to improve your confidence when working with them. It will also include shortcuts that will enable you to achieve tasks quickly and efficiently with minimum effort.
At the end of the course you will have your training manual, a copy of the training file created during the course, additional Excel training files to download from our website and a course certificate.
 
Course Aims
 
  • To create and edit basic Microsoft® Office Excel worksheets and workbooks.
  • To improve your confidence when using Microsoft Excel at this level.
Course Objectives
 
By the end of this level you will be able to:
 
  • Create a basic worksheet
  • Modify a worksheet and its simple formulas
  • Create and Edit simple formulas [Sum, Min, Max and Average]
  • Format the data, cells and sheet
  • Sort a list of data and answer more complex questions of that data
  • Filter a list of data and answer more complex questions of that data
  • Create and edit a simple vertical bar chart
  • Print the contents of a workbook
  • Learn useful shortcuts
Content
 

Get Started with Excel - An Overview of Excel - Navigate in Excel - Select Data - Enter Data - Save a Workbook - Obtain Help

 
Modify a Worksheet - Move and copy data between cells - Fill cells with series of data - Edit cell data - Insert and delete cells, Columns, and rows - Find, replace, and go - to cell data
 
Perform Calculations - Create basic formulas - Calculate with functions - copy formulas and functions - Create an absolute and relative Reference - Quick and easy calculation techniques
 
Sort data - Sort options - Single column sort - Multi column sort - Question sorted data - Things you don’t do
 
Filter data - Simple filter - Custom filter - Top ten filter - Filter by text , date, currency, number, colour - Answer questions of filtered data
 
Format a Worksheet - Edit font size and type - Add borders and colour to cells - Change column width and row height - Merge cells - Apply number formats - Create a custom number format - Align cell contents
 
Develop a Workbook - Format worksheet tabs - Reposition worksheets in a workbook - Insert and delete worksheets - Copy and paste worksheets - Copy a workbook
 
Print Workbook Contents - Set a print title - Create a header and footer - Set page margins - Change page orientation - Print large and small data sets including charts
 
Customize Layout - Split a worksheet - Arrange worksheets - Freeze and unfreeze rows and columns - Hide and unhide worksheets
 
Create a simple Chart - Shortcuts to charts - Edit charts - Update chart data - Delete charts - Link charts
 
Further Information

If you wish to discuss any part of the course please don’t hesitate to contact us on 01489 588453

Course Includes
 
Lunch/refreshments, training manuals, training file created during the course, additional training files to practice with, certificate, post course support.
 
Training Venues for scheduled courses at: Whiteley - Southampton, Salisbury, Basingstoke
 
Testimonials
Comment:  Excellent, well delivered.  Methodical and suited my style of learning.  Comfortable to ask and re-ask questions.  [AT]
Comment:  Very relaxed course, full explanations given for every section.  [SB]

Microsoft Excel Introduction

Enquire