Learn: in:
» back to Search Results

Course rating of 0 Vendor rating of 4


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 ]

Reviews
 

This course has not yet been rated by one of our members.

If you have taken a course through this vendor please log into your account and leave feedback for this vendor. You will be helping ensure our members get directed to the best training facilities.

Here are some reviews of the training vendor.
We had individual projects with specific questions and the instructor was very flexible in the course presentation to address our issues.
Reviewed by 2012
We had the advantage of a very small class and very attentive lecturer to answer individual's questions
Reviewed by 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 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 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 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 2011
This was an awesome course. The trainer was fabulous, very hands on. I would highly recommend.
Reviewed by 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 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 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 2011
Excellent course! Excellent Training Provider! Stellar Instructor!
Reviewed by 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 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 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 2011
I thought that in some cases we could have practiced a bit more with the features that we learned about.
Reviewed by 2011
I am satisfied - in fact, I will go to another training within the few next weeks.
Reviewed by 2011
Good course and since I was the only participant I had the benefit of a one-on-one.
Reviewed by 2011
It was an excellent course, but I think it could be done in 1-day instead of 2-day course.
Reviewed by 2011
Instructor is very knowledgeable, patient and has a great rapport with her students.
Reviewed by 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 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 2011
Would love to receive course manual (not available at time of course).
Reviewed by 2011
This was a great course for beginers using Excel! Very well taught. Thank you.
Reviewed by 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 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 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 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 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 2011
I appreciated the course as well as the instructor who was very professional.
Reviewed by 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 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 2008

This course currently does not have any dates scheduled. Please call 1-877-313-8881 to enquire about future dates.