Spreadsheets using MS Excel - Level 3 (MS 2000)

General Information

If you''''re already up to speed with Microsoft Excel but you''''d like to be able to handle advanced techniques, this is the course you need. It teaches you the procedures you need to know to be an advanced Excel spreadsheet user. You look first at entering, extracting and modifying data by using templates, lists and queries. You''''re shown how to create and modify shared workbooks and create links between them. And you''''re taken through data analysis using Data Map, Pivot Table, Data Table, Scenario and Data Analysis tools. Post-Assessments after each unit help you identify quickly any areas of your knowledge that need extra work.
Please Note: In order to practise the skills learned from this course, you will need to have purchased Microsoft Excel 2000.
Outline and Learning Objectives

On completion of this course you will be able to:

• Be able to create and use templates
• Be able to retrieve and sort data from a list
• Understand how to manipulate data from a list
• Know how to create and modify shared workbooks
• Analyse data by using Data Map
• Analyse data by using Pivot Table
• Analyse data by using Data Table Scenario
• Analyse data by using Data Analysis Tools

Previous Knowledge Required

You should have a good understanding of Microsoft Windows and should have completed the IT2 Microsoft Excel course or have equivalent knowledge.
What''''s Involved
Online
How Long Does It Take?
9 Hours
Course Level
Level 3