|
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 Advanced
2007 Series
|
| Home
> Online Courses >
Business
Skills Package >
Microsoft Excel Adv 2007 |
|
|
Estimated time to Complete:
12 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 Advanced series teaches you to apply
filters, use formulas and analyze data. You will be
able to apply your knowledge to create complex business
applications and analyses in Microsoft Excel.
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: |
|
 |
| Exporting
and Sorting Data |
 |
| •
Filtering and Sorting Data |
|
| •
Remove duplicate records from an Excel
worksheet |
|
| •
Apply filters to an Excel worksheet
|
|
| •
Apply one-click, multiple-level, and
custom sorts to your data |
|
| •
Query a database |
|
|
 |
|
|
|
| Using
Pivot Tables |
|
| •
Create pivot tables |
|
| •
Modify pivot tables |
|
| •
Use pivot tables to quickly and easily
analyze complex data sets |
|
| •
Apply pivot tables for common uses |
|
| •
Use pivot tables for data analysis |
|
•
Create pivot chart reports
|
|
|
|
|
|
|
| Working
with Functions |
|
| •
Calculate results with math functions |
|
| •
Work with logic and information functions
|
|
| •
Adjust text with functions
|
|
| •
Work with logic and information functions
|
|
| •
Use statistical functions to determine
relationships |
|
|
|
|
|
|
| Using
Data Analysis Tools |
|
| •
Use What-If analysis in Excel 2007 |
|
| •
Create analyses with Scenario Manager
|
|
| •
Analyze data using Goal Seek |
|
| •
Install Solver |
|
•
Use Goal Seek to backsolve from a solution
to its values
|
|
|
|
|
|
|
| Automating
with VBA Macros |
|
| •
Enable the Developer tab on the Ribbon |
|
| •
Modify macro security settings |
|
| •Record
and run macros |
|
| •
Record a macro that uses an advanced
filter |
|
| •
Customize macros for everyday use |
|
| •
Combine elements of written code with
recorded code |
|
|
|
|
|
|
| Sharing
Work and Adding Security |
|
| •
Create, edit, and remove a cell comment
|
|
| •
Change workbook properties |
|
| •
Apply and remove worksheet and workbook
protection |
|
| •
Apply and remove file passwords |
|
| •
Create a shared workbook |
|
|
|
|
|
|
| Adding
Connections and Importing Data |
|
| •
Connect two worksheets in separate workbooks
|
|
| •
Use the Links tab on the Trust Center
|
|
| •
Set up a connection to a Web page |
|
| •
Import an XML file |
|
| •
Connect to an Access database using
Microsoft Query |
|
|
|
|
|
|
|
|
|
|
|
|
| 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! |
|
|
|
