Change font size

AJP IT Services

Training Menu

Main Menu

Customer Testimonials

Location Map

Site Map

Subscribe to Newsletter

Microsoft Office Excel Basics

This one day course will cover spreadsheet basics of Microsoft Excel. 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. 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 XP" course are an adequate prerequisite for this course.

Tour of the Excel screen

Navigating in a Worksheet

Entering Data

Entering Formulae
Order of Mathematical Operators in Formulae
Editing a Cell
Entering a formula using the Pointing Technique

Excel's Functions

Sum, average, max & min AutoCalculate

Autofill

Creating sequences
Custom Lists
Copying Formula

File Commands

Create, save, open close and delete a file

Printing

Understanding the print options

Explanation of how Excel oganises data for charting

Creating a Chart
Choosing Chart Types
Inserting Titles
Choosing the location of the chart

Modifying the chart type etc. once the chart has been created

Formatting the Chart

Changing the appearance of chart elements
Creating a chart with two data series

Chart "extras"

Adding text boxes & arrows
Altering the scale of axes

Databases

Sorting
Searching using the Autofilter command
Using the Sub-totals command

[ Back ]