Learn: in:
» back to Search Results

Course rating of 0 Vendor rating of 4


In this course, you'll extend your knowledge into some of the more specialized and advanced capabilities of Excel by automating some common tasks, applying advanced analysis techniques to more complex data sets, collaborating on worksheets with others..


 
Course Outline
In this course, you will extend your knowledge into some of the more specialized and advanced capabilities of Excel by automating some common tasks, applying advanced analysis techniques to more complex data sets, collaborating on worksheets with others, and sharing Excel data with other applications.

Learning objectives: You will automate some common Excel tasks, apply advanced analysis techniques to more complex data sets, collaborate on worksheets with others, and share Excel data with other applications.

Course Outline: Lesson 1: Streamlining Workflow
Topic 1A: Create a Macro
Topic 1B: Edit a Macro
Topic 1C: Apply Conditional Formatting
Topic 1D: Add Data Validation Criteria
Topic 1E: Update a Workbook's Properties
Topic 1F: Modify Excel's Default Settings

Lesson 2: Collaborating with Others
Topic 2A: Protect Files
Topic 2B: Share a Workbook
Topic 2C: Set Revision Tracking
Topic 2D: Review Tracked Revisions
Topic 2E: Merge Workbooks
Topic 2F: Administer Digital Signatures
Topic 2G: Restrict Document Access

Lesson 3: Auditing Worksheets
Topic 3A: Trace Cells
Topic 3B: Troubleshoot Errors in Formulas
Topic 3C: Troubleshoot Invalid Data and Formulas
Topic 3D: Watch and Evaluate Formulas
Topic 3E: Create a Data List Outline

Lesson 4: Analyzing Data
Topic 4A: Create a Trendline
Topic 4B: Create Scenarios
Topic 4C: Perform What-If Analysis
Topic 4D: Perform Statistical Analysis with the Analysis ToolPak

Lesson 5: Working with Multiple Workbooks
Topic 5A: Create a Workspace
Topic 5B: Consolidate Data
Topic 5C: Link Cells in Different Workbooks
Topic 5D: Edit Links

Lesson 6: Importing and Exporting Data
Topic 6A: Export Excel Data
Topic 6B: Import a Delimited Text File

Lesson 7: Using Excel with the Web
Topic 7A: Publish a Worksheet to the Web
Topic 7B: Import Data from the Web
Topic 7C: Create a Web Query

Lesson 8: Structuring Workbooks with XML
Topic 8A: Develop XML Maps
Topic 8B: Import and Export XML Data
Additional Details
Pre-Requisites

Excel 2007 Level 2 or equivalent knowledge

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.
I was the only participant so received one on one training. With a group you usually do exercises from a workbook which would have been beneficial to me but that didn't happen with one on one training. I was shown how to do something and then asked to do it too rather than starting an exercise from scratch in a workbook and having to figure it out myself.
Reviewed by 2012
No, all good to me !
Reviewed by 2012
An excellent faclity located in the heart of downtown Ottawa. Friendly instructor and staff. As this was a one on one instructional situation, the instructor tailored the workshop to my needs. She covered every one of the twenty-two topics that I had requested and sent via email the week previous. I would recommend this school to anyone needing to learn or augment their computer skills.
Reviewed by 2012
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 2012
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 course currently does not have any dates scheduled. Please call 1-877-313-8881 to enquire about future dates.

 

This page has been viewed 136 times.