This one-day course teaches the basic functions and
features of Excel 2007. After an introduction to
spreadsheet terminology and Excel's window components,
students will learn how to use the Help system and
navigate worksheets and workbooks. Then they will enter
and edit text, values, formulas, and pictures, and they
will save workbooks in various formats. Students will
also move and copy data, learn about absolute and
relative references, and work with ranges, rows, and
columns. This course also covers simple functions, basic
formatting techniques, and printing. Finally, students
will create and modify charts, and learn how to manage
large workbooks. Designated as Approved Courseware. For
comprehensive certification training, students should
complete Excel 2007: Basic, Intermediate, and Advanced.
Contact us for further details.
After completing this course, students will know how to:
Getting started
Spreadsheet
terminology
Exploring the Excel window
Getting help
Navigating workbooks
Entering and editing data
Entering and editing text and values
Entering and
editing formulas
Working with pictures
Saving and
updating workbooks
Modifying a worksheet
Moving
and copying data
Moving and copying formulas
Absolute and relative references
Inserting and
deleting ranges, rows, and columns
Using functions
Entering functions
AutoSum
Other useful functions
Formatting worksheets
Formatting text
Formatting
rows and columns
Formatting numbers
Conditional
formatting
Copying formats and applying table formats
Printing
Preparing to print
Page Setup options
Printing worksheets
Creating charts
Chart basics
Modifying charts
Printing charts
Managing large
workbooks
Viewing large worksheets
Printing large
worksheets
Using multiple worksheets
Before taking this course, you should be familiar with personal computers and the use of a keyboard and a mouse. Furthermore, this course assumes that you've completed a Windows Basic course or have equivalent experience.
The target student for this course
should be comfortable using a personal computer and Microsoft Windows. You should have little or no
experience using Microsoft Excel or any other
spreadsheet program. You will get the most out of this
course if your goal is to become proficient in using
Microsoft Excel to create simple worksheets and charts
for internal reports and data tracking.
For comprehensive training, you should complete all of the following courses: Excel 2007: Basic, Excel 2007: Intermediate, and Excel 2007: Advanced.