|
Courses >
Computer Applications > Introduction to Microsoft Excel 2003
 Work
with numbers? Then you need to learn Excel 2003. In this unique
six-week online workshop, you'll discover dozens of shortcuts and
tricks for setting up fully formatted worksheets quickly and
efficiently. You'll also learn the secrets behind writing powerful
mathematical formulas, using the function wizard to quickly and
automatically calculate statistics, loan payments, future value, and
more. You'll also learn the best ways to sort and analyze data, create
custom charts and graphs, create 3-dimensional workbooks, build links
between files, endow your worksheets with decision-making capabilities,
and automate oft-repeated tasks with macros and buttons.
Recommended Courses:
Students who enrolled in Introduction to Microsoft Excel 2003 were also interested in the following courses:
Advanced Microsoft Excel 2003
Accounting Fundamentals
Introduction to Microsoft Excel 2007
Intermediate Microsoft Excel 2003
Introduction to QuickBooks 2007
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 |
Excel Terminology; Navigation and Editing; Constant Values vs. Formulas
|
| Friday - Lesson 02 |
Creating a Worksheet: Labels, Values, Formulas, and Formatting
|
| Week Two |
| Wednesday - Lesson 03 |
Time-Savers
|
| Friday - Lesson 04 |
Relative, Absolute, and Circular References
|
| Week Three |
| Wednesday - Lesson 05 |
Sheet References; Creating 3-Dimensional Workbooks; Linking Files
|
| Friday - Lesson 06 |
Sorting and Subtotaling
|
| Week Four |
| Wednesday - Lesson 07 |
Creating Graphs: The Chart Wizard
|
| Friday - Lesson 08 |
Advanced Graphing Techniques
|
| Week Five |
| Wednesday - Lesson 09 |
Statistics Made Easy: The Function Wizard
|
| Friday - Lesson 10 |
Financial Functions; Amortization
|
| Week Six |
| Wednesday - Lesson 11 |
Worksheet Automation: Creating Macros and Customizing Toolbars
|
| Friday - Lesson 12 |
Creating Worksheets with Decision-Making Capabilities
|
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.
Student Reviews:
"As a working manager looking to enhance some of my skills,
this course was a perfect fit...I could work the lessons into my life
without interruption of my existing work activity."
"Even though I already used Excel before this course, I
learned a lot in the lessons. The step-by-step way in which things are
explained is great."
"Excellent class! The on-line format plus the consistent
interaction via the Discussion Area was a great combination for me. You
will definitely see me again. Many thanks!"
"Great class, learned a lot. Made my job a lot easier."
"Great course. Instructor takes the ho-hum of data and
brings it to life in real situations. Look forward to the Advanced
lessons."
"Great course. Well written and clear. Learned a lot."
"I am a teacher myself, and I feel the instructor did an
excellent job of making concepts understandable in a step-by-step
manner. His writing style was also conveyed professionally and yet a
friendly way. I would certainly like to take another on-line class with
this instructor."
"I enjoyed the practical, real world tie in that the
instructor used. I think this gave me a more of an advantage since I
don't work on Excel as much."
"I enjoyed this course very much. I am thankful that I took
this course when I did because I just applied for a job that you need
to know mirosoft excel."
"I found this course to be an excellent way to learn Excel
2003, and would recommend it to others. The curriculum had a good
organization and sequencing, was well written and easy to follow."
"I found this course very useful. I am self taught in excel
and have used it for many years. This course filled in the gaps that I
was missing. In addition opened my eyes to new uses of excel. I am
looking foward to the next level."
"I highly recommend the course, especially if you have to
travel and you time schedule is not normal. I also liked the
presentation style."
"I learned many new features of Excel which I had not
stumbled upon in my many years of using it. THANKS very much for a very
effective course."
"I really enjoyed this class and I found it very helpful for
my career as a teacher. I hope to take the intermediate excel class."
"I really enjoyed this course and the other one I took. Wish
I could have went through college taking online classes way back
when.... This has made a happy camper out of my employer and has given
me more knoweledge in the long run."
"I really liked the course. After being out school for
better than 13 years, I was afraid I would have trouble. It went very
well. I actually had fun. Thank You and I look forward to the next
course."
"I thought the course was great. I learned a lot, I didn't
realize how much info there was to excel. The Material was great and
walked you thru everything."
"I was surprised by how the instructor made the lessons seem easy when the information can be complex."
"I wish all instructors invested this much time in their
students. The course material was very easy to follow and understand. I
cannot say enough good about this instructor and this course material.
I have been a very positive experience for me. I will recommend this
course to others."
"Loved this course. I knew a little bit of Excel when I
started, but even from the first lesson I learned things that I didn't
know. I have taught my boyfriend how to link worksheets and this has
helped him with his job. I have now signed up for the intermediate
course."
"Overall, the syllabus is quite progressively designed to build up the basic excel skills and on. It is a very good class!"
"The course instructor was EXCELLENT!!! I am very satisfied
with this course. He was very interactive with the us-the students. And
I will recommend this course to everyone!!! His teaching style is
Awesome!!! I am eagerly looking forward to attending the online
Intermediate course in January. Thank you so much!!!"
"The course was easy to follow and covered a lot of information. I am very pleased with what I have learned."
"The course was very interesting and helpful. The instructor
made you feel comfortable asking questions. Every question was answered
in a timely and pleasant manner. I learned a lot and enjoyed doing so."
"The instructor had an excellent approach to teaching this
class. The material flowed nicely, keeping my interest. In short, the
instructor helped you to understand the how's and why's of a sometimes
complex subject."
"This course gave me the confidence to apply for a new
position and to see that applications are not difficult when you have
training."
"This course has helped me tremendously both at work and at home."
"This is an excellent on-line course which enabled me to save a lot of time and still get the classroom interaction I needed."
"This is a wonderful way to take a course. I can see the
many advantages Excel has and it is obviously a very powerful tool.
Thank you Craig for your easy to follow classes and the little bits of
humour that made it more fun!"
"This is my second class from Craig Power, and I'll be
signing up for another next month because I find the material
well-presented and relevant. I am enjoying these classes!"
"This is my second course with this instructor, and I like
the step by step presentation. I found it easy to correct mistakes I
may have made and the printed course is excellent reference material.
The course has already had a positive impact on my work environment!"
"This is the 3rd course I have taken by Craig Power. They
are concise, orderly and learning is so simple that you do not even
realize how much you ARE learning. I am looking forward to Excel
Intermediate. I have taken other courses [from another provider] and
they do not even come close to Craig Power's."
"This was a great course. I will recommend to my manager
that others in our department need to take this course. I was impressed
by what I learned that Excel can do for me. Thanks for the great work!"
"This was a GREAT course! The instructor really knows his
subject and can convey that expertise in an easily understandable way."
"This was my first online course, I was very pleased in how
easy the course was to be able to do. I have already begun the next
level."
"This was my first time taking an online course and I was
concerned about how it would work for me, but I really enjoyed it and
ifound it to be very effective."
"Working full time and keeping a household going, I didn't
think I would be able to complete this course. I have already started
using this program to help me at work and it has made a great
difference to getting work done faster. I can't wait to apply it at
home."
"Wow! I attended college 25 years ago, and had not been back
since. I had been tempted to try an online course, but was
worried...after about the 4th lesson, I felt I had already gotten my
money's worth."
To purchase this course, click the Enroll Now button below:
|
