Focus Project Management - Welcome
Email: Click here to email us | Tel:


Home"" Home
About Us About Us
Search Courses Search Courses
Which Course? Which Course?
Company Training Company Training
Distance Learning Distance Learning
Links & Resources Links & Resources
FAQs FAQs
Contact Us Contact Us




course outline
Microsoft Excel 2002 Fundamentals

Duration: 1 day
Provider: Parity Training
• Enquire about this course
• Download a Booking Form
Request a Course
Which Course?
Back to Previous Search Results
• Print Course Outline
This course will suit anyone wishing to learn the essential skills in using Excel 2002 proficiently for the creation of spreadsheets, data manipulation and presentation.

< Click here to go directly to Course Outline Details >

Next available Non-Residential courses:-

  Venue  Date  Price  Availability
Arrow Birmingham-Hagley Road, Birmingham 20th Feb 06 £175
+VAT
Spaces
  [Enquire] [Book] [Venue Information]

Arrow Birmingham-Hagley Road, Birmingham 30th May 06 £175
+VAT
Spaces
  [Enquire] [Book] [Venue Information]


Notes:
Course Objectives
 
By the end of this course you will be able to design spreadsheets utilising basic functions, formulas and graphs.
 
What skills will the delegate gain?

This course will enable delegates to:
Navigate around Microsoft Excel.
Enter and Edit data.
Print spreadsheets.
Use Copy, Cut and Paste in Excel.
Create basic formula using functions.
Create charts and graphs.
Understand the Web functionality of Excel.

Who will the course benefit?

Anyone wishing to learn the essential skills in using Excel 2002 proficiently for the creation of spreadsheets, data manipulation and presentation.
 
Prerequisites

This course requires that you have a good working knowledge of Microsoft Windows. 
 
Examinations

This course, along with Intermediate and Advanced, covers the curriculum for the ECDL exam.
 
Additional Notes

Training is available on previous versions.
 
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 set up options.
 
Modifying a Worksheet:
Moving and copying data.
Moving and copying formulas.
Using absolute references.
Inserting and deleting ranges.
 
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.


footer bar

Focus Project Management, 57a Church Street, Market Deeping, Peterborough, PE6 8AN

[ Terms & Conditions ] | [ Tel: ] | [ Email: Click here to email us ]