Quasar Courses Page

Course Information

Duration:

1 day

Microsoft Excel 2000
Controlling and Improving your Workbooks

This one day course is designed to build on basic skills in Excel.

Delegates will learn to control their worksheets through navigation techniques, calculate using more advanced logical functions and increase presentation impact using charts, graphs and maps.

Delegates should have previously attended the 'Essential Skills for the Spreadsheet Novice' course or have equivalent knowledge through their own usage of the product.

By the end of the course delegates will be able to:

Apply freeze panes in large worksheets to control navigation.
Define and apply range names to speed navigation and calculation within the worksheet.
Attach printable comments to cells in the worksheet.
Arrange worksheet and workbook windows to compare two sheets or two books on screen.
Calculate using date functions.
Calculate using IF functions.
Calculate using SUMIF and COUNTIF functions.
Calculate using nested IF, AND and OR functions.
Calculate using LOOKUP functions.
Create charts, graphs & maps using Excel data.
Insert pictures and graphics in to the worksheet.