| A Division of Bridgewater Solutions
Excel 2003 (For Existing Users)

Course Information:

Course Duration: 3h30min Supplier
Main Audience: General Staff
Other Audiences: -
Credit Cost: * 10
NQF Alignment: No
NQF Level (approx) 4-5    (What is this?)


Course Details:

Microsoft Excel 2003 is a powerful spreadsheet program used predominantly to manage numerical data - organising it in a logical way, automatically calculating figures, graphically representing this information and a host of other functions. This has uses in business in such circumstances as preparing budgets, analysing trends, summarising results, assisting with common calculations and even as a database for storing information. In its most simple applications it can help to organise and display any kind of information (numbers or text) in a structured and usable way.

This course on Microsoft's Excel 2003 is aimed at those users who are comfortable with the basics of using the programme and would now like to learn about some of the more advanced features of the application such as the use of lists, the use of formulae, auditing those formulae to find errors, pivot tables, sharing Excel information with others and more.


Learning Outcomes :

By the end of this course the learner should know about the following:
  1. The use of labels
  2. The use of smart tags
  3. Customising your view of Excel
  4. Absolute versus relative referencing
  5. Functions and formulae
  6. Auditing your workbook to find errors
  7. The use of styles
  8. The use of Pivot Tables
  9. Charting and graphing
  10. Security and data protection



* Excludes official 3rd party assessment costs for qualifications


Go Back


 
Find out more