Microsoft
Course Outline
Microsoft Excel - Introduction
Hands-on training in an instructor-led environment. One workstation per delegate
and exercises to consolidate learning.
Training Method:
A working knowledge of the Windows environment is required.
Prerequsites:
One day
Duration:
To introduce the basic concepts and features of Microsoft Excel. Upon successful completion of the course
delegates will be able to create simple worksheets.
Objectives
First time and/or inexperienced users of Microsoft Excel.
Designed for:
Module 1: The Fundamentals
Starting Excel
Understanding the Excel Program Screen
Opening a Workbook
Saving a Workbook
Moving the Cell Pointer
Navigating a Worksheet
Entering Labels in a Worksheet
Entering Values in a Worksheet and Selecting a Cell
Range
Calculating Value Totals with AutoSum
Entering Formulas, Using AutoFill
Previewing and Printing a Worksheet
Closing a Workbook and Exiting Excel
Module 2: Editing a Worksheet
Entering Date Values and using AutoComplete
Editing, Clearing, and Replacing Cell Contents
Cutting, Copying, and Pasting Cells
Moving and Copying Cells with Drag and Drop
Collecting and Pasting Multiple Items
Working with Absolute and Relative Cell References
Using the Paste Special Command
Inserting and Deleting Cells, Rows, and Columns
Using Undo, Redo, and Repeat
Checking Your Spelling
Finding and Replacing Information
File Management
Inserting Cell Comments
Content
Understanding Smart Tags
Recovering Your Workbooks
Module 3: Formatting a Worksheet
Formatting Fonts with the Formatting Toolbar
Formatting Values
Adjusting Row Height and Column Width
Changing Cell Alignment
Adding Borders
Applying Colours and Patterns
Using the Format Painter
Using AutoFormat
Creating a Custom Number Format
Formatting Cells with Conditional Formatting
Merging Cells, Rotating Text, and using AutoFit
Finding and Replacing Formatting
Module 4: Creating and Working
with Charts
Creating a Chart
Moving and Resizing a Chart
Formatting and Editing Objects in a Chart
Changing a Chartís Source Data
Changing a Chart Type and Working with
Pie Charts
Adding Titles, Gridlines, and a Data Table
Formatting a Data Series and Chart Axis
Annotating a Chart
Working with 3D Charts
* Public Courses
* Private Courses
* Customised Courses
* On site training available
Tel: 01625 549287 anne@firsttraining.net