Course Objectives
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.
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
Tour of the Excel screen
The Microsoft Office User Interface
- The Ribbon
- User Interface Tabs
- The Quick Access Toolbar
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
Flash Fill
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
