Spreadsheets Using MS Excel - Level 2 (MS 2000)

General Information
Find better ways to analyse data and discover powerful solutions using Microsoft Excel 2000 with its super efficient spreadsheet creation tools, improved analysis tools and excellent Web integration. Excel 2000 provides you with a set of comprehensive tools to help you create, analyse, and share spreadsheets. Create high impact spreadsheets more easily than before using enhanced formatting features. Analyse your data with charts, PivotTable dynamic views, and graphs and learn how to post your results to the Web for viewing and collaboration.
To get the best from Excel you really need to be up to speed with its features and short cuts.
Over two sections this course introduces you to the fundamental and more advanced spreadsheet capabilities of Excel so you can make it work for you.
Fundamentals - looks at basic worksheet and workbook management, entering and editing data, formatting worksheets, using simple formulae and manipulating worksheets by copying, inserting and deleting ranges of cells.
Proficient User - teaches you some of the more advanced capabilities including managing display properties, advanced calculation techniques such as using functions, consolidation of data, data validation and security, along with web integration and creating and modifying charts and other graphics.


Outline and Learning Objectives

On completion of this course you will be able to:

• Be able to launch Excel & manipulate a workbook
• Know how to enter data & user simple formulas
• Know how to format & sort workbooks & cells
• Know how to customise Excel toolbar
• Know how to do advanced calculation functions
• Know how to import & export workbook data
• Know how to integrate workbooks with the web
• Be able to add in charts, graphs 3D shapes
• Know how to debug, protect, save & print

Course Modules

• Microsoft Excel Fundamentals
• Microsoft Excel Proficient User

Previous Knowledge Required

You should have a basic understanding of Microsoft Windows and the Internet. No experience with current or previous versions of Excel is required.
What''s Involved
Online
How Long Does It Take?
15 Hours
Qualifications

Taking this course can count towards part of the following qualifications:

• CLAIT Plus - with Microsoft Certification

Course Level
Level 2