Introduction
This 1-day course is an introductory programme for all persons wishing to learn Excel spreadsheet techniques
and functions.
This is a very hands-on, non-intimidating, course - delegates work through various exercises under the
supervision, and with the help, of the facilitator to get to grips with the various basic functions and structure of
Excel.
Who Should Attend
- All persons wishing to use Excel spreadsheets
Pre Requisite(s)
- Delegates need not be familiar with Microsoft Excel (though exposure to MS Word and similar MS programs will be
advantageous).
It is recommended that delegates have basic computer experience, use of a mouse, and keyboard and understanding of
computer file storage
Excel knowledge required:
- No prior knowledge is required.
Outcomes
By the end of the course delegates will be able to use Excel to create spreadsheets and carry out a variety of Excel
tasks.
Course Content
MODULE 1
- What Is a Spreadsheet
- What You Can Create & Manage with a Spreadsheet Application
- Benefits of Using Spreadsheets Programs
- Types of Spreadsheet Programs
- What is Excel?
- Getting Started with Excel
- Understanding the Excel Screen
- Using Menus and Toolbars
- Using the Task Pane and Dialog Boxes
- Using Smart Tags
- Getting Help
- Quitting the Program
MODULE 2
- Understanding Text, Numbers & Formulas
- Entering Data
- Inserting the Date Automatically
- Entering the Same Data Over and Over with AutoComplete
- Editing Data
- Deleting Data
- Undoing Your Changes
- Moving the Cell Pointer
- Using the Keyboard
- Using the Mouse
- Understanding the Mouse Pointers
- Selecting Cells, Columns, Rows & Sheet
MODULE 3
- Saving a New Workbook
- Saving a Workbook as you Work
- Saving a Workbook with a New Name
- Saving a Spreadsheet to a Different Format
- Closing a Workbook
- Creating a New Workbook
- Opening a Workbook
- Zooming a Workbook
MODULE 4
- Entering Data Quickly with AutoFill
- Entering Formulas
- Revising Formulas
- Changing Column Widths
- Dragging Column Borders
- Using AutoFit
- Changing the Width of Multiple Columns
- Changing Row Height
- Moving and Pasting Data
- Copying and Pasting Data
MODULE 5
- Inserting Columns, Rows and Cells
- Deleting Columns, Rows and Cells
- Using the AutoSum Button
- Copying Formulas
- Copying using the Copy and Paste Buttons
- Copying using AutoFill
- Check Spelling
- Finding and Replacing Data
- Previewing your Worksheet
- Printing your Worksheet
- Deleting a Print Job
MODULE 6
- Changing the Appearance of your Data
- Changing Fonts, Style, Size, Colour & Effects
- Formatting Values
- Changing the Currency Symbol and Thousand Separator
- Aligning Data in Cells
- Adding Borders to Cells
- Adding Shading to Cells
- Clearing Formats
- Selecting a Paper Size and Orientation
- Scaling your Spreadsheet
- Setting Margins
- Printing Column and Row Headings
- Printing Gridlines
- Freezing Columns and Row HeadBigs
Learning Method
Our training approach is lecture based, highly individualised and practical. Each learner must have access to a
Pentium PC workstation. Comprehensive course material is supplied for future reference.
All learners will complete a Pre and Final Evaluation.
|
Print