it2 spreadsheets using ms excel 2000 netg

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.

it2 spreadsheets using ms excel 2000 netg- uk (England, Scotland, Wales)

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.

Please Note: In order to practise the skills learned from this course, you will need to have purchased Microsoft Excel 2000.

On completion of this course learners should be able to:
Create and save a new workbook.
Add and manipulate worksheets.
Enter and manipulate data in single and multiple cells.
Use formulae and functions.
Format workbooks, worksheets and cells.
Change fonts and data formats.
Format and print data in a worksheet.
Make worksheet calculations by using the advanced formulas and functions provided by Excel.
Manipulate data in a worksheet.
Create and edit workbooks for integrating with Web technology.
Add and modify charts, graphics and 3D shapes to a worksheet.
Course Modules:
Microsoft Excel Fundamentals.
Microsoft Excel Proficient User.

Previous experience required:
Learners should have a basic understanding of Microsoft Windows and the Internet. No experience with current or previous versions of Excel is required

Northern Ireland and Ireland it2 spreadsheets using ms excel 2000 netg