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
- 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
