Microsoft Excel Introduction
Course Duration: 1 Day
 Printer-friendly
version
Course Objective
By the end of the course, delegates will be able to:
- Understand the
purpose and principal functionality of an electronic spreadsheet
- Start
and quit Excel
- Save, close and retrieve Excel files
- Use Excel Wizards and dialogue
boxes
- Move around the Excel screen and select cells and other objects
using both keyboard and mouse
- Enter and edit text and numeric values
- Create formulae
- Apply different types of cell formats
- Use AutoFill, drag and drop
and AutoSum to create spreadsheets quickly
- Create a chart from spreadsheet
data
- Use the page layout dialogue box facilities to control how a
worksheet is printed
Delegate Profile
Existing Windows users who are new to Excel who
wish to use the application to produce accurate spreadsheet information.
Pre-Requisites
Attendees should have experience
of using the mouse, and a working knowledge of the Windows operating
system, including file and folder structures.
Structure
Each delegate has the exclusive use of
a PC and training includes extensive hands-on activity.
Course Content
Moving around in Excel
The Excel screen
Cell-tips and scroll-tips
Selecting cells, columns and rows
Changing column width and row height
Commands, toolbars and dialog boxes
Building and editing worksheets
Opening, closing
and saving
Entering and editing text and numbers
Moving, copying and deleting
The undo command
Auto-fill, AutoComplete and AutoCorrect
Spell-checking
Creating simple formulae
Entering and editing simple formulae
Addition, subtraction, multiplication and division
AutoSum and AutoCalculate
Relative and absolute cell references
Sequence of operation in formula (use of brackets)
Worksheet Formatting
The difference between cell contents
and cell formats
Applying different types of cell format:
- Currency signs
- Decimal places
- Bold
- Italic
- Font size
- Colours
- Borders and shading
- Auto formatting
Viewing the formulas or viewing the data
Page set-up
Splitting panes, freezing panes and zooming
Selecting page orientation
Changing page margins
Headers and footers
Printing and print preview
Page breaks
Print Preview toolbar
Setting print areas and titles
Introducing Charts
Building simple charts
Using the Chart Wizard
Help
How to get help when you need it
Overview of additional features
Trainer demonstration
 Back
to the top
|
