|
Courses >
Computer Applications > Intermediate Microsoft Excel 2003
Syllabus:
All
courses run for six weeks, with a two-week grace period at the end. Two
lessons are released each week for the six-week duration of the course.
You do not have to be present when the lesson is released, but you must
complete each lesson within two weeks of its release.
A new
section of each course starts on the second or third Wednesday of each
month. If enrolling in a series of two or more courses, please be sure
to space the start date for each course at least two months apart.
| Week One |
| Wednesday - Lesson 01 |
Charting Fundamentals
|
| Friday - Lesson 02 |
Advanced Charting
|
| Week Two |
| Wednesday - Lesson 03 |
Data Management
|
| Friday - Lesson 04 |
AutoFilter; Goal Seeking
|
| Week Three |
| Wednesday - Lesson 05 |
The Pivot Table: Part 1
|
| Friday - Lesson 06 |
The Pivot Table: Part 2
|
| Week Four |
| Wednesday - Lesson 07 |
The Solver: Part 1
|
| Friday - Lesson 08 |
The Solver: Part 2
|
| Week Five |
| Wednesday - Lesson 09 |
Macros
|
| Friday - Lesson 10 |
Text Functions
|
| Week Six |
| Wednesday - Lesson 11 |
Math Functions
|
| Friday - Lesson 12 |
Lookup Functions
|
This
course includes a knowledgeable and caring instructor who will guide
you through your lessons, facilitate discussions, and answer your
questions. The instructor for this course will be Craig Power.
 Craig
Power has worked in adult continuing education for more than 18 years.
A UCLA graduate, he created custom accounting software for state and
local governments; developed an online course delivery and marketing
platform currently used by more than 1,500 colleges and universities in
the US, Canada, and Australia; developed an interactive cellular
biology video for the Los Angeles Unified School District; taught
college-level information technology courses; started and grew a
thriving small business; and served as an executive with a large
academic publishing corporation.
Requirements:
Completion of Craig Power's online Introduction to Microsoft Excel 2003 course (or equivalent experience), Microsoft Windows XP or 2000, Microsoft Excel 2003 or Microsoft Office 2003 (Student and Teacher Edition, Standard Edition, Small Business Edition, or Professional Edition
are all acceptable - please be sure to install the software on your
computer before the course begins), Internet access, e-mail, and the
Microsoft Internet Explorer or Mozilla Firefox Web browser.
This course is not suitable for Macintosh users, nor for users of any of the 2007 versions of Microsoft Excel.
Student Reviews:
"After completing both the Intro & the Intermediate
Excel courses, the financial management of my company from now on will
be a breeze! Thank you for a great opportunity to learn the advanced
skills that I needed!"
"Craig Power has written this course to be clear and
concise. His writing style conveys casualness yet it respects the
reader's intellect, which established then maintained my interest
throughout the past 6 weeks."
"Great course, great instructor. I cannot think of any possible improvements. Thank you!"
"He is an excellent instructor and walks you through each
step thoroughly. You can tell he is passionate about teaching and is
well versed with the subject matter. His sense of humor is right on."
"I enjoyed the taking the course, and each lesson, very
informative and useful in the real world usage with timely and up to
date information in every lesson and tip. Well worth recommending to
others. Outstanding."
"I found this course to be entertaining and useful."
"I found this course to be very interesting and a challenge
at the same time. Mr. Power lays this course out so that you can see
what you have done wrong if you make any mistakes. I will be signing up
for the Advanced Course."
"I have found this course, as well as the beginning Excel,
to be a good reference tool. I'm not required to use Excel regularly on
my job, so having the printed lessons and quizzes at my disposal, allow
me to reference the material and to solve Excel problems when they
arise."
"I have taken several courses with this instructor and have
always been amazed at the quality of the course content and the ability
of the instructor to understand and help with my questions. When
deciding on the next course to take I try to choose his classes first
because I have confidence that I will be able to learn a difficult
course with him. Before taking the first two Excel courses, I had never
worked with this program, and now I am able to do things I didn't even
know existed - plus I actually understand why and how to do it. Thank
you."
"I really enjoyed Intermediate Excel. Even though I've been
using spreadsheets for years--and tested as an Excel "expert" according
to an employment agency's assessment--I learned a lot of new and useful
skills. Can't wait to put them to use on the job and for my personal
projects!"
"I really enjoyed the course. I got so excited about what I
had learned after some of the lessons I could hardly wait to try them
out in my own spreadsheets. Thank you so very much for making this
understandable and easy to follow. It was great!"
"I thoroughly enjoyed this course and it makes me want to take more classes on line."
"I thoroughly enjoyed this course, the instructor was very
helpful and I appreciated the way he seemed genuinely concerned and
willing to help with any question I had. I would definitely take
another online class with this instructor."
"I value the knowledge that I got from taking this course and would recommend to many of my workmates."
"Mr. Power, thank you! This was just what I needed to
improve my existing skills. This class was very informative and
challenging. I can't wait to start using my new knowledge and tools at
my office job and my home."
"Overall, the course was great and will really help me in my current position. Thank you for the great program."
"Thanks for the great course. I enjoyed learning more about Excel and am now confident I can set up my own databases."
"The information I learned in this course was very helpful.
I am already finding ways to apply the information in my work. Thanks!"
"This class is a lot of fun."
"This course was much more benifical than the one day courses offered by [another provider]."
"This is a highly complex program with awesome features. It
will take me a long time to get it down really well. I am very glad I
took this course with you and very grateful that you have this (and
other programs)available online. I really enjoyed the instructors
character and sense of humor that came out in the information."
"This is an excellent course, which exceeded my
expectations. The material was well organized and easy to follow. The
instructor’s clear writing style and humor made the material easy to
read, and his responses to questions were very prompt, friendly and
thorough. Very encouraging!"
"This was my second course and it was just as exciting as
the first one. The instructor was great. I really enjoyed this class
and I am planning on taking the access course also from the same
instructor. Thank you for these exciting courses."
"This was my second online course with the same instructor
and again, I was very happy with the lessons, discussion and quizzes
that have helped me learn so much about Excel. The instructor was
always very quick to answer any questions I might have and he was
always easy to understand and made learning so much fun and
interesting. I would recommend these computer online classes to all my
friends and coworkers!"
"Very interesting course. I've used what I've learned in
this course at work and I've impressed many people with my new
knowledge of excel. I definitely feel more comfortable using excel at
work."
To purchase this course, click the Enroll Now button below:
|
Have
you been using Excel 2003 to its fullest potential? Learn how to work
faster and more productively. Discover how the Pivot Table and
AutoFilter can help you rapidly create reports and analyses. Learn
advanced graphing techniques and how to use functions to get Excel 2003
to perform complex math, make decisions, and look up values in a table.