|
Your Satisfaction
is Guaranteed! If
you are not completely satisfied after your first
week (7 days) of training, we will refund your money
- No questions asked!
-------------------------------------
|
All of our computer training courses
are approved for CEU's (Continuing Education Unit
Credits) through Otterbein College.
--------------------------------
|
|
Expert
Mentoring -
Live Chat 24 hours a day, 7 days a week |
|
Instant Mentoring provides 24/7 support while you are
enrolled in our online courses.
Our experts can clarify concepts, fine-tune solutions,
confirm a process, or simply provide assurance that
you are on the right track.
Instant Mentoring helps to ensure understanding and
synthesis of any of our online courses.
--------------------------------
|
 |
Certificate of
Completion |
When you have scored 80% or better
on the actual course, you will have the opportunity
to print out a certificate of completion.
If you would like to become a Microsoft Office Specialist
(MOS), our courses will help you prepare for the MOS
exams.
--------------------------------
|
 |
Smart-Tips
Weekly
e-Newsletter |
When you enroll,
you will also receive our weekly "Smart Tips"
E-Newsletter, which is designed
to update your skills even faster!
It's jam-packed with quick tips, short-cuts,
and timesaving guide-lines so you'll become more efficient
and more productive faster than you would have imagined!
--------------------------------
|
|
"I've really enjoyed taking
these courses and have found them really
valuable. Thanks for providing great computer courses."
-Allison W.
|
| |
|
 |
|
 |
Microsoft Excel 2007 Series
|
| Home
> Online Courses >
Business
Skills Package >
Microsoft Excel 2007 |
|
|
Estimated time to Complete:
11 hours
Continuing Education Units:
Yes
Self Assessment Tests:
Yes
Certification Prepartion:
Yes
24 / 7 Mentoring Service:
Optional
Training Method:
Online, Self-Paced
Subscription Term:
3/6 Months
This course is included
in the Business Office Skills Package
Cost: $99 for 3 Months Access or $149 for 6 Months Access
Summary:
The Excel 2007 series introduces learners to the newly
designed Ribbon interface of Microsoft Excel 2007. It
provides a basic introduction to Excel including entering
and editing cell data, selecting cell ranges, and formatting
worksheet data. Learners will also be able to print
worksheets, add comments, complete basic calculations
and formulas, and create charts using Excel 2007.
Audience:
This series is for anyone who wants to get the most
out of using Excel 2007.
Features:
- Exercises that allow users to practice the application
- Files containing the text of the exercises
- Simulations that allow you to practice course skills,
even if you don't have access to the application
- Glossary
- Skill Assessment Tests
Course Outline and Objectives: |
|
 |
| Getting
Started |
 |
| •
Identify tasks other than financial
calculations for which Excel can be
extremely helpful |
|
| •
Locate the position of the active cell
in a worksheet |
|
| •
Make changes to Excel's application
settings |
|
| •
Identify the sections of the Formula
bar |
|
| •
Add a new worksheet to an Excel 2007
workbook |
|
|
 |
|
|
|
| Create
/ Manage Worksheets |
|
| •
View information in a worksheet |
|
| •
Use several built-in functions, like
AutoComplete, AutoFill, Insert Function,
and AutoSum |
|
| •
Identify the default order of operations
used to calculate formulas |
|
| •
Identify different data types used in
the application |
|
| •
Manage multiple worksheets |
|
•
Share and protect your workbooks
|
|
|
|
|
|
|
| Creating
a Spreadsheet |
|
| •
Input text, values, and formulas |
|
| •
Edit data |
|
•
Use the speech and handwriting recognition
features
|
|
| •
Use AutoCorrect, AutoFill, and AutoSum |
|
| •
Retrieve backup files following a system
crash |
|
|
|
|
|
|
| Charts
and Databases |
|
| •
Create charts using Chart Wizard |
|
| •
Insert and modify text boxes, pictures,
SmartArt, and clip art to create eye-catching
and effective worksheets |
|
| •
Create your own graphics |
|
| •
Create a database |
|
•
Manage a database
|
|
|
|
|
|
|
| Formatting
Data |
|
| •
Use AutoFormat |
|
| •
Use various Excel tools to select groups
of cells |
|
| •
Adjust cell formatting and colors |
|
| •
Adjust cell sizes |
|
| •
Apply different types of data and cell
formats to make worksheets easier to
read and work with |
|
| •
Add borders, shading, and colors to
cells |
|
|
|
|
|
|
| Hypertext
and Tips |
|
| •
Adding hyperlinks to a workbook |
|
| •
Follow and edit hyperlinks |
|
| •
Save static and interactive Web pages
in Excel |
|
| •
Edit Web pages |
|
| •
Send Excel workbooks in e-mail |
|
|
|
|
|
|
| Editing
and Printing Worksheets |
|
| •
View workbooks in different modes |
|
| •
Copy a formula from one cell to another
|
|
| •
Delete cells individually and by rows
or columns |
|
| •
Insert a row or column of cells |
|
| •
Place headers and footers on printed
pages |
|
|
|
|
|
|
|
|
|
|
|
|
| And, with all our online courses, your Satisfaction
is Guaranteed! If you are not completely satisfied after
your first week (7 days) of training, we will refund your
money - No questions asked! |
|
|
|
