AJP IT Services

Course Objectives

This two day course will cover all the basic commands of this powerful application. The topics introduced include an introduction to the spreadsheet, the graphics capabilities, and the database handling commands.

The broad objectives are to make clients aware of the full possibilities of the program and to give clients confidence to operate the program themselves.

Who Should Attend?

This course is designed for computer users with little or no previous experience of Excel, but who require a basic understanding of the product. Some knowledge of computer basics and working with Windows is expected. The topics covered on our "Introduction to Microsoft Windows" course are an adequate prerequisite for this course.

Course Contents

An introduction to the product.

An introduction to working with Excel (the graphics interface).

Spreadsheet basics.

• Entering numbers, text and formulae
• An Introduction to Excel's special functions
• Copying information and formulae
• Using formats to improve the look of a table

Standard file commands.

• Saving
• Printing
• Opening and Closing

Excel's Charts.

• How Excel organises a chart
• Converting a table into different graphical representations

Quality presentations.

• Printing and producing top quality spreadsheets and charts

Workbooks.

An introduction to Excel's database capabilities.

• Sorting
• Searching
• The Data Form