Microsoft Excel 2003 Level 2 - Intermediate

Upon completion, students will be familiar with: Advanced formulas, using range names in formulas, managing worksheets within workbooks, using advance formatting techniques, creating and printing charts as well as sorting data in alphanumeric order.

Course Outline

Upon completion of the course, you will be familiar with the following: Advanced formulas, using range names in formulas, managing worksheets within workbooks, using advance formatting techniques, creating and printing charts as well as sorting data in alphanumeric order.

Course Outline

ABSOLUTE / RELATIVE RANGE

• Creating and using an Absolute Range

USING RANGE NAMES

• Creating a Range Name
• Jumping to a Named Range
• Using Range Names in Formulas

ADVANCED FORMULAS

• Using some of the Logical Formulas
• Using some of the Financial Functions
• Date Formulas
• Linking Formulas

MANAGING WORKSHEETS

• Copying / Moving Worksheets
• Moving Data between Worksheets
• Copying Data between Worksheets
• Renaming Worksheet Tabs
• Consolidation Worksheets

ADVANCED FORMATTING

• Using Styles
• Templates
• Conditional Formatting
• Autoformat

CHARTS

• Chart Concepts
• Creating Charts
• Editing Charts
• Printing Charts

DATA SORT

• Sorting Lists
• Sorting in Ascending/Descending Order
• Sorting using multiple fields

DATABASE

• Enabling AutoFilter
• Using AutoFilter to Filter a Custom List

Additional Details

Pre-Requisites

Knowledge of Excel Introduction and Windows experience

Certificates offered

Certificate of completion

Cancellation Policy

RESCHEDULING POLICY

Registrants who wish to reschedule their course may do so at least 5 working days before the commencement of their course providing the course fee is paid within 30 days following the originally scheduled date of the course. Otherwise, a 20% surcharge is applicable.

CANCELLATION POLICY

Notice received less than 5 working days prior to the course date is subject to a 20% service charge. If the notice is given within 48 hours of the course date, the course is non-refundable. Notice of cancellation must be received by CompuEase 5 working days prior to the confirmed date to obtain a full refund.

Map & Reviews

CompuEase
[ View Provider's Profile ]

CompuEase Training Classroom
124 O'Connor, Suite 204
Ottawa, ON
Canada   K1P 5M9

Reviews

 

We have not received any reviews specific to this course as yet, however here are some reviews of the training vendor.

   

Our instructor was absolutely a delight. It made learning something that could have been boring in to something very fun and interesting. Dracy Whyte was great as a teacher!

Reviewed by Dona M. 2012

   

We had individual projects with specific questions and the instructor was very flexible in the course presentation to address our issues.

Reviewed by Sheryl M. 2012

   

We had the advantage of a very small class and very attentive lecturer to answer individual's questions

Reviewed by Lothar H. 2012

   

Great beginning for me.... I would have liked a longer basic course to cover some text data entry for templates, rather than just calculations...

Reviewed by Evelyn D. 2012

   

Would have preferred some practical exercises with the instructor going around and seeing if we understood the training. eg. complete a travel claim sheet. There were only 5 participants to probably would have been a good time to wander around the class and see how we were doing. Difficult to see the screen, esp in the a.m. with the sun hitting it.

Reviewed by Trudy . 2011

   

I had been using Word 2003 for several years. My software was recently upgraded to Word 2007. I found this course extremely interesting and useful for me. Sometimes, there are some really small tricks that can help immensely for our day-to-day work. The instructor was very knowledgeable and had a great personnality. This is one of the best courses I've taken and I've taken many... Marc

Reviewed by Marc R. 2011

   

I found the instructor at CompuEase "Desiree" very patient and helpful! She is very knowledgeable and takes the time to help me through this training - especially since I've never used it before. Thank you! Connie

Reviewed by Constance L. 2011

   

This was an awesome course. The trainer was fabulous, very hands on. I would highly recommend.

Reviewed by Judy K. 2011

   

The trainer mentioned that I could retake the course for free and that this is something that is normally offered there. I might do that because it was an off day for me. I was feeling tired and my concentration was a bit off. The trainer also was having an off day because of a back injury. I have taken training with Compuease before and I find it is a friendly environment and the trainers are excellent.

Reviewed by Sylvia B. 2011

   

I was trully satisfied with the services at CompuEase. I was lucky enought to receive a one on one training with no else then the founder, who is very knowledgeable. I will definitely watch out for future courses.

Reviewed by Natalie C. 2011

   

The room was kept at about 100 degrees. Also, we needed Photoshop CS5 on MACS. After we paid/registered, I was emailed and told they didn't have Macs. I said okay, we'll cancel. Then they said whoops sorry, we do have Macs. 12 hours before the course was to begin (we were travelling from out of town) they emailed to say they didn't have CS5 but only CS4 but that the instructor was "very knowledgeable." When we got there, there were in fact two computers that had CS5, but they weren't MACS, so we had to choose, either a PC with CS5 or a MAC with CS4. My PC kept crashing because it was so old and slow it couldn't handle a program like Photoshop. And since we were on CS5, everything the instructor told the class to do did not match what was on our screen and we had to hold the class up every half an hour saying "I don't have that option on my screen." The instructor made several references to sex (I appreciated his sense of humor, but not his taste or lack of) and he seemed more like a surfer dude than a teacher. He was very disorganized ,jumping all over the place, changing his mind about what he was going to talk about, etc. It was hard to follow what was going on in his head.

Reviewed by Shannon B. 2011

   

Excellent course! Excellent Training Provider! Stellar Instructor!

Reviewed by Cristiane P. 2011

   

The smaller class size allowed for more one-on-one time with the instructor during the hands-on exercises, which optimized the learning experience. The course manual was a bit lacking, but luckily our instructor was a true expert in the field and was able to go into detail and even treat us to more advance applications when he saw that we were ready to take on the more advanced applications. I will certainly be taking another course with the training provider, especially if they continue to provide the student with such stellar instructors!

Reviewed by Cristiane P. 2011

   

The course provided by CompuEase was great. The instructor was excellent and very knowledgeable. The course content directly applied to my needs. I would recommend this course to others and am considering taking the next level myself.

Reviewed by Eileen I. 2011

   

My instructor was very interesting and knowledgable. She took the time to explain things to me that were not covered in the course outline, but were relevant to my employment needs.

Reviewed by sarah w. 2011

   

I thought that in some cases we could have practiced a bit more with the features that we learned about.

Reviewed by Karl S. 2011

   

I am satisfied - in fact, I will go to another training within the few next weeks.

Reviewed by Suzanne R. 2011

   

Good course and since I was the only participant I had the benefit of a one-on-one.

Reviewed by Patricia R. 2011

   

It was an excellent course, but I think it could be done in 1-day instead of 2-day course.

Reviewed by Laura . 2011

   

Instructor is very knowledgeable, patient and has a great rapport with her students.

Reviewed by Rose P. 2011

   

The crse was very well paced, covering all aspects of Microsoft Excel that I wanted to learn / had questions on. The trg provider is very well versed in both the subject and teaching / instructing skills, ensuring that all questions are answered before moving on to the next lesson / exercise. The crse handout booklet used and will use in the future is a great ref.

Reviewed by Arthur K. 2011

   

Excellent instructor; flexible and willing to accommodate students by explaining specific details. Has great overview of MS office suite. Provides learning experience that enables.

Reviewed by Cathleen K. 2011

   

Would love to receive course manual (not available at time of course).

Reviewed by Sylvie J. 2011

   

This was a great course for beginers using Excel! Very well taught. Thank you.

Reviewed by Angela C. 2011

   

From the "get go" the day was filled with delays and set backs (crashing computers and time delays to upload material). It appears that zero time given to course preparation....photo's had not been uploaded onto computers; the computers had not been pre-tested for functionality. The training room was filled with static - likely contributing to the problems with the computers. There was student manual that was missing (mine). The instructor provided his copy to me, but was left with none himself until after the lunch hour. I do not beleive the instructor had any kind of tuturial/instructor manual prepared - certainly one was not followed. Students were not given the basic of this course in any formal training approach - it might have been useful to follow the manual but it all seemed very hap-hazard hard understand, confusing. I did not know should be learning and why. The terms or functions (tools/keys)in the software was not well explained leaving the student wondering what was and wasn't important to know and why... - The training area lacks professionalism and cleanliness....There is nowhere to go for "breaks" (ie no lounge areas / or lunch if you happen to bring your own... the stairways skinks...

Reviewed by Linda G. 2011

   

Extremly bad training. Company obviously not prepared for training--trainer's computer did not work and went down 4 or 5 times, my workstation did not work, I moved from computer to computer, none of these worked so had to share. Workstations not prepared prior to course with proper files (instructor had to load during break and this took over an hour). I could go on and on about how terrible this training was and this was not due to the instructor who was trying. We ended the session and asked for a re-take as the training was a complete disaster from start to end. One star for many of the above ratings is being generous.

Reviewed by Lee-Ann S. 2011

   

This was the first time ever that I can remember having a two instructors teach a course. The tag team approach to teaching kept me on the edge of my seat. The thought of having a new voice and personality teaching the course material was like a breathe of fresh air. We was so wrapped up the level of passion the instructors brought to the classroom regarding Excel that we only stopped for a 30 minute lunch and then spent an additional hour at the end of the day where the instrctors shared experiences which had even challenged them.

Reviewed by jonathan r. 2011

   

1. CompuEase does not have special ergonomic equipment (ie.. cordless mouse) When I arrived at the Centre, I spoke to the secretary at the front desk to say who I was and that there was supposed to be a cordless mouse set up for me (she went to check on

Reviewed by Diane L. 2011

   

The instructor was really new what she was dooing and we learned alote. However, we did not have access the the internet, the facility was hard to find and was not very clean and well organised. Only coffee was offered once (i don't drink cofee).

Reviewed by Lucie.Lacroix . 2011

   

I appreciated the course as well as the instructor who was very professional.

Reviewed by Gervais R. 2011

   

The first morning, there was nobody there 5 minutes before the course started. Of course we started late. The courses was with COMPUEASE in Ottawa. They advertise the course in French and they delivered it in English, without reason. The teacher, the

Reviewed by Jean-Pierre V. 2009

   

The class is very informative and easy to understand. The instructor, Pierre presents himself well and with an excellent attitude, he seems to really enjoy teaching and is very patient. We can ask as many questions as we wish or have him repeat without a

Reviewed by Jeanie G. 2008