|
MICROSOFT EXCEL XP – Essentials
Course Aims:
Participants will learn to identify the elements of the Excel XP workspace, enter and edit data, enter formulas and functions, save, open and create workbooks, manipulate cell ranges, format sheet appearances, print, and manipulate the display of workbooks.
Contents:
Introduction
What is Excel
The Excel Workspace
Task Panes and Smart Tags
Excel Menus & Dialogue Boxes
Moving around a Worksheet
The Office Assistant and Ask a Question
Creating a Worksheet
Entering Information into Cells
Types of Data: Text/Numeric
Formulas
Writing Basic Formulae
AutoSum - Expanded Functions
Screen Tips for Functions
Editing Information
Saving and Deleting Worksheets
Modifying a Worksheet
Using Ranges
Absolute Addresses
Moving and Copying Data
Fonts and Styles
Lines, Colours and Borders Tool
Adjust Column Width
Inserting and Deleting Columns and Rows
Number and Text Formats
Fill Series
Printing Worksheets
Printing Worksheets
Establishing Print Ranges
Print Options
Page Setup Options
Headers and Footers
Apply Graphics
Changing the Margins
Managing Documents
Opening Existing Documents
Working with Document Windows
Working with Workbooks
Working with Smart Tags
Charts
Why Use Charts
Different Types/Styles
Chart Wizard
Sizing and Moving
Colours and Shading
Changing the Axis Scale
Adding Titles and Grid Lines
Enhancements
Adding comments
Creating a Text Box
Adding Graphics and Symbols
Target Audience:
Users needing to create attractive, readable workbooks that are easy to manipulate, calculate and recalculate.
Assumed Knowledge:
A knowledge of the Microsoft Windows working environment is desirable but not essential
Duration: 1 Day
Suggested follow-up course:
Excel XP Specifics
printer friendly version
|
