Microsoft Excel Introduction
Dates
The 1st day of the course is designed to let users get to grips
with the main features of Excel and realize the advantages of using
a powerful electronic spreadsheet. Day 2 of the course is designed
to advance users' knowledge of the features and functions within
Excel The course is entirely 'hands on', so those attending will
get practice in creating and modifying actual spreadsheets, enhancing
them with charts and graphics and using more advanced formulae.
This Excel 2000 course also instructs users in Year 2000 best practice.
Microsoft Excel Introduction
What is a spreadsheet?
Getting started with Excel
Starting Excel • Excel opening screen • The Title Bar
• The Menu Bar • Toolbars • Scroll bars • Active
cell, column and row headers • Sheet tabs • The Status
Bar • Menus and submenus • SpeedKeys • Dialogue boxes
• Exiting Excel
Getting assistance with Excel
Using the Office Assistant • Getting help without the Office
Assistant • Manipulating the help window • Finding out
what is on the screen
Starting a workbook
Creating a new workbook • Moving around the sheet • Scrolling
• The mouse pointer • Selecting cells with the mouse •
Selecting cells with the keyboard • Spreadsheet data types
• Year 2000 best practice • Entering and editing data
• Editing long entries • Undoing incorrect edits •
AutoFill • Custom lists • Saving, closing, opening and
deleting a workbook
Working with worksheets and cells
Using Go To • Moving data with Drag-and-Drop • Cut, Copy
and Paste • Moving entries (Cut and Paste) • Copying cell
contents (Copy and Paste) • Using the Office Clipboard •
Using find and replace
Entering basic calculations
AutoSum • Entering a calculation
Statistical functions
Using relative and absolute cell addresses • Circular references
Formatting cells
The formatting Toolbar • Enhancements • Alignment •
Formatting numbers • Resizing columns and rows • Clearing
a worksheet
Structuring the worksheet
Inserting and deleting rows and columns • Inserting and deleting
worksheets
Printing worksheets
Print Preview • Changing the page set-up • Printing
Formatting the worksheet
Adding borders and shading • · AutoFormats • Copying
formats • Text formatting • Indented lists
Using styles
Creating and applying a new style • Modifying styles
Navigating worksheets and workbooks
Opening a second workbook • Working with large sheets •
Using Zoom • Worksheet linking
Using more advanced formulae
Preventing rounding errors • Conditional formulae (IF, AND
and OR) • The Formula Palette • Financial functions (PMT,
FV, PV)
Productivity features
Protecting the worksheet • Hiding data • AutoCorrect •
The spelling checker
Charts and pictures
Creating charts • Changing chart elements • Changing chart
data • Printing charts • Inserting ClipArt and pictures
• Drawing objects • Manipulating objects
Excel and the Internet
Creating hyperlinks • Saving a worksheet as a Web page •
Web page preview • Sending worksheets and workbooks via e-mail
|
