The course provides a comprehensive introduction to Microsoft Excel. This beginning spreadsheet class will cover: getting started with Excel, entering and editing data, modifying a worksheet, formatting worksheets, working with charts, and printing.
|
|
|
|
Course schedule
Duration: 2 days.
To view the schedule for this class, click here.
Who should attend
This course is intended for all IT Professionals who want to learn the Excel XP or 2003.
Prerequisites
No previous knowledge of Microsoft Excel is required. You should be familiar with the Windows operating system.
Course Outline
Getting started
Spreadsheet terminology
Exploring the Excel window
Getting help
Opening and navigating workbooks
Closing workbooks
Entering and editing data
Creating workbooks
Entering and editing labels and values
Entering and editing formulas
Saving and updating workbooks
Modifying a worksheet
Moving and copying data
Moving and copying formulas
Using absolute references
Inserting and deleting ranges
Using functions
Entering functions
Using AutoSum
Using AVERAGE, MIN, and MAX
Formatting worksheets
Formatting text
Formatting rows and columns
Formatting numbers
Using Format Painter and AutoFormat
Printing
Preparing to print
Page Setup options
Printing worksheets
Creating charts
Chart basics
Modifying charts
Printing charts
Web features
Saving workbooks as Web pages
Hyperlinks
Sending workbooks via e-mail
|
|