Learn: in:
» back to Search Results

Course rating of 5 Vendor rating of 5


In this course, you will build on your fundamental Excel skills to become proficient with more advanced Excel 2007 skills, such as using multiple worksheets, combining worksheets, linking formulas, creating & modifying charts & many more.

  • Course Start Date: Sep. 3
  • Location: Mississauga (Map)
  • Time: 8:30 am - 4:30 pm (Note on end times)
  • Please Note: End Times are approximate and depend
    on the number or students and pace of the class.
    It is important to allow for the class to run a little bit longer,
    or finish a little sooner, than expected.
  • Duration: 1 day
    08:30 AM - 04:30 PM
  • Delivery Method(s):Instructor Led
  • Mentored training is a revolutionary training method
    that provides you with the quality training that
    you have come to expect, and combines it with
    flexible learning and a self paced environment.
    For more information click here.
  • Seats Available: YES
  • Category:Microsoft Excel Training

 
Course Outline
In this course, you will build on your fundamental Excel skills to become proficient with more advanced Excel 2007 skills, such as using multiple worksheets, combining worksheets, linking formulas, creating and modifying charts, and applying styles to format worksheets.

What You'll Learn
  • Organize, protect, and display data, using various tools
  • Create linking formulas and use the IF function
  • Set up multiple worksheets, using information from other sources through consolidation, and copy and paste links to combine information into one worksheet
  • Create and modify charts to present data effectively
  • Customize charts to enhance their appearance
  • Create and apply styles to format worksheets consistently and quickly
  • Use conditional formatting, comments, and text boxes to highlight and explain data
Who Needs to Attend

Those who are familiar with Microsoft Office Excel 2007

Course Outline

1. Managing Multiple Worksheets and Workbooks

  • Using Multiple Worksheets
  • Working with Multiple Workbooks
  • Naming Cells and Ranges
  • Consolidating Data
2. Using Templates and Protecting Workbooks
  • Working with Workbook Templates
  • Protecting Workbooks and Worksheets
3. Nested Formulae and External References
  • Using the IF Function
  • Working with External References
  • Updating and Restoring Links
4. Working with Charts
  • Creating Charts
  • Updating Chart Data
  • Formatting a Chart
  • Creating Custom Chart Template
5. Formatting Excel Data
  • Using Cell Styles
  • Managing Cell Styles
  • Using Conditional Formatting
  • Working with Comments
  • Creating and Using Worksheet Outlines

Prerequisites & Certificates
Pre-Requisites

Microsoft Excel 2007 Level 1 (S171)

Certificates offered

Certificate of Completion


Cancellation Policy
We require 16 calendar days notice to reschedule or cancel any registration. Failure to provide the required notification will result in 100% charge of the course. If a student does not attend a scheduled course without prior notification it will result in full forfeiture of the funds and no reschedule will be allowed. Within the required notification period, only student substitutions will be permitted.

Reschedules are permitted at anytime with 16 or more calendar days notice. Enrollments must be rescheduled within six months of the cancel date or funds on account will be forfeited.
Map & Reviews
Global Knowledge
[ View Provider's Profile ]

Global Knowledge at TCP Mississauga
5060 Spectrum Way
Suite 502

Mississauga, ON
Canada   L4W 5N6


Reviews
 

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

Instructor was both knowledgeable and personable - I would definitely consider taking another class with him!
Reviewed by 2015
Only issue with the facility is that the image color of the projector in classroom 3 turned yellow and stayed yellow for 2.5 days.
Reviewed by 2015
This course is heavily loaded, it helps to have an overview of what "cognos manager framework" can do. It focuses on a dimentionnel approach. In my case I would have appreciated a the focus based on a relational approach.
Reviewed by 2015
The course was IT project Management. It really seemed like a Project management fundamentals course not so much IT.
Reviewed by 2015
Excellent facilitator. The course content was well balanced and spread over day.
Reviewed by 2015
Had GK before, last time was good. This time the instructor was a bit off with the teaching style. Both times they send the course materials to the wrong location, company had to re-route it.
Reviewed by 2015
The class room at GK on BAY was an oven, but they booked us at a local hotel, which was great.
Reviewed by 2015
The course was really very helpful Instructor and facility were good as well. Only the missing the hardcopies material, sometime this help a lot than electronics copy. I understood the environmental policies very well, I used to work with Alberta Health and Environmental group as well with so many project. But for the course material it was required tools. For the contractors if the course falling on weekend would be great.
Reviewed by 2015
I am not highly enthused about taking a course over a video link, however, I did find that this course was well presented. It's my feeling that there is no substitute for a classroom environment when it comes to learning and sharing ideas.
Reviewed by 2015
I have not received the training certificate.
Reviewed by 2015
I really liked the useful tip cards as well as the introduction to KUMA. I feel KUMA could be used is almost any circumstance.
Reviewed by 2015
Too basic materials!
Reviewed by 2015
The only issue I encountered is that this course was cancelled multiple times before it was finally held. I would ask if there is a way to avoid frustrations with cancellation of future postings.
Reviewed by 2015
Course was great. Training provider was even better.
Reviewed by 2015
I was nervous about taking my first online course but the instructor was amazing and thorough. I would love to take another course from him in the future.
Reviewed by 2014
The provider was very knowledge and very professional
Reviewed by 2014
Since this is an online training, there are some items not applicable for evaluation purpose.
Reviewed by 2014
Great course and great teacher but it would have been noce to fins out Global Knowledge moved from Scott Street to Albert. Found that out when I showed up at Scott street and got off the elevator into an empty floor. I was nt alone as most in my class foudn this out the same way as well.
Reviewed by 2014
The instructor was knowledgeable in Word 2010 and very pleasant to work with. My problem was with the technology used, being it was a virtual session. There were too many instances where I had to log on, too much lag, audio problems on both my end and the trainers side of things. Perhaps the pre-test should also include an audio aspect in order to trouble-shoot audio problems prior to the beginning of the class session.
Reviewed by 2014
I do not feel as though I learned any new skills from taking this course. I did enjoy some of the course material but there was something missing from it. Very basic, highly repetitive. Everyone knows how to make a "to do" list but how to you prioritize and create focus in your daily work? I still am not sure of that. Although the instructor was very good and knowledgeable, someone with more energy and enthusiasm would have been better suited to teach this course as it became a little dull in the afternoon.
Reviewed by 2014
I really enjoyed the on-line class. Very helpful
Reviewed by 2014
it was good just a bit too fast.
Reviewed by 2014
The course material was good, although I would strongly recommend that participants be quite familiar with the PMBoK (either PMPs or CAPMs etc.) The instructor Bruce was very knowledgeable and provided some real world experience and examples.
Reviewed by 2014
Could possibly have been a 4 day course rather than 5 but there were people going at different speeds so the pace accommodated everyone. Also the lab environment perfectly for most students but a few did run into technical difficulties that had nothing to do with their inexperience with SharePoint. This was frustrating. The instructor is very knowledgeable and very helpful. I would like the contents of this course to be something we could get a certification in.
Reviewed by 2014
N/A
Reviewed by 2014
I like the fact that we did the exercice together with the instructor to show the content/knowledge and by ourself after that. However, I would have like to do different exercices to make sure I understood the content.
Reviewed by 2014
The 3's are really not applicable as this was a webinar
Reviewed by 2014
Overall course content was good. Got behind in some of the sessions. Still need to go back to them.
Reviewed by 2014
The ONLY reason facilities is marked low is because you asked about parking. The location is not conducive to finding parking. Otherwise - fantastic! And I loved the coffee bar!
Reviewed by 2014
Training provider is good but I was particularly impressed with Mr. Gilles Marcil who was our instructor for this course. He is well prepared and explains matter very well.
Reviewed by 2014
I was truly impressed with the format and information given. Clear and precise.
Reviewed by 2014
Course was too long, ended up not really understanding anything after the afternoon break. Took a day with our IT to load Mozilla, and still had difficulty starting labs. Virtual computer did not always work and lab screens were challenging working from laptop having to scroll up and down to complete tasks and read instructions.
Reviewed by 2014
Trainer Robert Proulx was excellent! Very knowledgeable, great sense of humour and the pace of the course was exactly what I needed.
Reviewed by 2014
no take away booklet. they offer the digital copy only and I would have liked to have the booklet for quick reference
Reviewed by 2014
Hello, It may be useful to have either a telephone booth and/or a breakout room for private mobile telephone conversations during breaks from the course. Please provide a document identifying my name, date of course, and number of hours. Thank you. Bill McCreery
Reviewed by 2014
Different levels should be established for people using Word for the very first time and others who are there to learn updated application. Some of the content was too basic for intermediate users. The trainer seemed confused trying to explain certain features.
Reviewed by 2014
The labs were buggy and lacked adapted instructions for the non-standard setup being used. This caused several headaches and need to troubleshoot before most would function properly.
Reviewed by 2014
Instructor was exceptional
Reviewed by 2013
It was a great class where the instructor provided lots of relevant examples to apply to day to day use utilizing the course material as a guideline.
Reviewed by 2013
This course was absolutley amazing. It provided me with wonderful tools to use in my work and day to day activities. Ross Rennie was our instructer and he was phenommenal. He was knowledgable, entertaining and very welcoming to everyone in the course. Is it wrong to say that I was excited to get back to work in order to implement these new tools?
Reviewed by 2013
Perhaps a less experienced instructor would be better to teach the more basic material. While our instructor was very knowledgeable, she seemed lost in some of the more basis functions and interfaces at times (probably because she hasn't had to work with them regularly for years). Could have spent A LOT less time going off on stories/tangents or explaining the lab/e-reader interface quirks, but overall a decent class with a few good pointers here and there.
Reviewed by 2013
The textbook(s) given for this course (ICND1v2) do not do very well when it comes to explaining the various acronyms and abbreviations when they first show up in the text. Many of these acronyms / abbreviations are not industry standards but rather Cisco-specific terms and the Glossary at the end(s) do not contain a full suite of the terms that are referenced throughout the text, leaving the reader to search for their meanings elsewhere...
Reviewed by 2013
Was a virtual training therefore section one is N/A
Reviewed by 2013
I was very impress with the instructor. She was very knowledgeable and I really like the fact that she shared some of her own experience with the group.
Reviewed by 2013
the training provider was really good and patient. I just wish we would have gone a bit further with some functions as the level was very basic, more like a level 1 /beginner.. but in terms of presentation, he did very well :)
Reviewed by 2013
The Cloud course exam was a farce. I expected to sit the exam on the second day but had to schedule it for the following day. The exam itself asked questions not covered in the course and some of the questions were extremely subjective, and as such I was extremely disappointed to have failed it by only one mark.
Reviewed by 2013
Very good course.
Reviewed by 2013
Very good instructor! Really took the time to explain answers to questions that were asked.
Reviewed by 2013
great, terrific
Reviewed by 2013
The instructor was excellent and made the course.
Reviewed by 2013
The instructor regularly asked us about the pace and everyone else was fine with it so I didn't say anything. However, it really feels like a 3-day course stretched to 5 days.
Reviewed by 2013
I would have liked 1/2 to 1 hour to study the contents of the course we had covered on the last day prior to writing the exam.
Reviewed by 2013
The instructor only tought 4 sections, we have 7sections in total,so after class, I have to finish them by myself!
Reviewed by 2013
Jeff and Paul are awesome to work with. Very organized and knowledgable
Reviewed by 2013
Virtualization and Cloud Essentials is a good course. Instructor has an excellent presentation style, knowledge and provided lots of additional information that will assist when on-the-job. The manuals do need an update but the instructor provided a lot of the latest information and live examples to make up for the out-dated information. A bit intense having two back-to-back classes with exams but have the option to take exams at a later date. Would recommend this class
Reviewed by 2013
May be limit number per course to 8 max.
Reviewed by 2013
Too many typos in the course material, especially the lab book.
Reviewed by 2013
A lot of contents to cover and could be overwhelming but the instructor Ted Church made it look simple and very easy to understand. He is good and very knowledgeable about what he teaches.
Reviewed by 2013
Global Knowledge does not provide printed copies of the workbooks, and you can not print your own from the electronic file they provide. You can purchase a printed copy for an additional charge which is ridiculous after paying for the course already.
Reviewed by 2013
Employees were not as professional as they could in at least couple situation. The classroom was too hot in the first day, and freezing in the following days. This course should be a 5 days course, and not 4. Impossible to handle 100% of the content in 4 days.
Reviewed by 2013
This course was way more basic than the outline describes, I felt that we should have covered more of the functions of Visio and less of the basic windows/microsoft functions.
Reviewed by 2013
Instructor was very knowledgeable about the subject. He is natural teacher which makes subject easy to understand
Reviewed by 2013
Was disappointed with the course content. For a level two course felt the trainer focused far too much on basic skills and not enough on animation and advanced features. Class progress was slow during the day, yes I learned new skills and learned about new capabilities of PPT 10 but relied on google not this course to perfect them.
Reviewed by 2013
I would like to have had more in-depth work on the process analysis portion and less on modelling. From the outline, I thought there would be more focus on analysis than there was. I think the course could maybe be 5 days instead of 4, or maybe state that knowledge of modelling is a requirement to take this course. Other than that, it was a good course. Good for more entry-level BA types; if you have a lot of experience, you will probably find it doesn't add that much.
Reviewed by 2013
The course material was overly dense and contained a lot of redundant information.
Reviewed by 2013
The instructor was fantastic - very knowledgable and engaging. The "polestar" was used only briefly and in my opinion had no value add to this course.
Reviewed by 2012
You should always host your Montreal trainings at the Bonaventure Hilton.
Reviewed by 2012
As always, Global Knowledge has put together another great Microsoft course (Config, Manage & Maintain Windows Server 2008 R2). This is my fourth time taking a course through Global Knowledge and it likely won't be my last.
Reviewed by 2012
Trainer is very knowledgeable. He was able to resolve any issues we encountered in our office.
Reviewed by 2012
Very interesting course and trainer. This course should be mandatory for all government clerks.
Reviewed by 2012
Excellent course Excellent instructer
Reviewed by 2012
I was not able to take the course book with me. I payed for the course so i should not have to buy the course book. The downloadable PDF of the course book is not printable. I like a hard copy to read as opposed to the computer screen.
Reviewed by 2012
Room was very cold! However the facility itself was clean with a friendly environment. Instructor had average knowledge of Microsoft Project 2010 and often could not answer questions. Presentation was average - instructor read handout page by page from a photocopied document that was projected onto wall.
Reviewed by 2012
The dissappoint with this course, you can't print the maunal, I think we pay enough money to take the course. VERY dissapointed in this aspect and only this.. would definitely compare else where due to this one factor.. shame as I felt the the instructor and facility to be excellent.
Reviewed by 2012
Very informative course. Covered everything I was looking to learn about Access. Would be interested in taking the level 2 course to expand on what I learned in this one. Global Knowledge in Mississauga is very nice and my instructor was great. A bit of a long drive coming from Durham region but would return and would reccomend to others.
Reviewed by 2012
I found the course to be a bit too advanced for a level 1 Excel.
Reviewed by 2012
n/a
Reviewed by 2012
The instructor was excellent and very knowledgeable. The office manager was very friendly and helpful as well. Overall it was a fantastic course and I will recommend Global Knowledge to family and friends! :)
Reviewed by 2012
Content as expected. Additional materials and relevant examples to drive learnings were provided. Lots of exercises to practice. Will be able to apply knowledge.
Reviewed by 2012
Check computers and other electronics and its functionality before course start up. Have up to date slides (binder and its hand outs show year 2011).
Reviewed by 2012
This was a virtual class so I cannot comment on the facility (I have rated the facility as I could not submit this otherwise), and because the course was Eastern Standard Time, for myself it was a little early as Eastern Standard Time was 2 hours ahead of my time. The instructor Mark Husereau was very knowledgeable and a really great with being patient, (this was my first virtual class). Mark used real examples throughout the course which was really great.
Reviewed by 2012
Course is as described. Alot of time is allowed to practice the new skill-set learned. Instructor is very knowledgable and provided additional information and tips. Worth while course.
Reviewed by 2012
The course was mainly about application which is fine for level 1. In level 2 I hope to get tips on design.
Reviewed by 2012
Attending sessions provided by GlobalKnowledge has been useful and career enhasing. The Coach, Coach, Coach instructor was EXCELLENT and provided addional, relevant information during session with supporting handouts.
Reviewed by 2012
- do we get a certifiacate for completing the courseÉ - although the instructor did give us excercises to do I would have liked a few more - almost like a test, so that I made sure I retained and understood what was taught. I`m a learn to do by doing person and like the instrutor lead courses so I can have someone there to explain in my terms how things work. I`ll have to really use the online excercises to make sure Ì am confident when I need to do something in Excel.
Reviewed by 2012
Should be time allocated for questions and answer
Reviewed by 2012
The instructor was excellent as was the hands-on learning approach. The only thing I took issue with was the fact that there were a lot of bilingual persons taking the course and they tended to ask questions in French, during this English class. The instructor was trying very hard to explain everything in both languages, but I felt that these students should have requested a French-speaking classroom setting if they wanted to speak French.
Reviewed by 2012
Very professional. Facility clean and comfortable.
Reviewed by 2012
For the cost of this course, a hard copy of the course handout should be provided as the classes follows the handout word for word.
Reviewed by 2012
The facilities at Global Knowledge were great. The Instructor was very knowlegable and made it easy to learn the material. It was a very good experience:)
Reviewed by 2012
Note: We had 2 different trainers during this 3 day course. Course: Terminology should reflect North America and be consistent with our business lingo.
Reviewed by 2012
Found the course very informative. I had little exposure to Sharepoint and learned a number of things I didn't know. Plan to take the next level of training
Reviewed by 2011
A charged mannul would be provided for students to make notes whereever they think instructions are important as reminders
Reviewed by 2011
The course is so expensive to be payed by oneself. In almost all the others participants their companies pay the fee.
Reviewed by 2011
No course books were provided for us to take.
Reviewed by 2011
Course was very detailed but more time would be helpful during workshops. An additional day would help lessen the course load.
Reviewed by 2011
should have discuss some case studies,,overall A+
Reviewed by 2011
Our instructor was very knowlegable and he provided excellent real life stories.
Reviewed by 2011
The course was very relevant. I was able to apply the knowledge I aquired in the course to my job on the very next day. The only complaint I have is with the temperature of the room. It was freezing! Students has to wear a jacket or sweater. We were told the temp gage was shared with another classroom that was quite warm so they had turned the temp very low causing our room to be very uncomfortable.
Reviewed by 2011
Given the cost of the course, the hardcopy of the manual should have been provided. It would have been useful to make notes alongside the material as we went along.
Reviewed by 2011
I am very disappointed with the handouts. I was told I could go online and download a copy of the manual, the problem is that I would like the printed copy of the manual. I chatted online with one of your technitian who was unable to help me. Then I was told someone would contact me by phone to help me. That never happened. When taking a training course, a person EXPECTS to leave the course with ALL the material.
Reviewed by 2011
Great course provider, keep it on your roaster
Reviewed by 2011
Course content and labs were very good, everything worked as expected.
Reviewed by 2011
I really enjoyed this course and was surpised how ell everything was run...enjoyed the instructer very much (Par) and would like to take an other course with him. I wish we could have taken the work book home with us though!!!
Reviewed by 2010
3-September-2015 $275 Register for this course

Registration is fast, and will take approximately 3 minutes. There is no membership fee.
» You are also welcome to Make an Offer Make An Offer Help

Not enough budget for this course? Maybe you just love to make deals!
In either case, our Make an Offer feature gives you the opportunity to name
your own price. Try it out, you might get lucky, just keep in mind it can
take up to 1 full business day to get a response!
need-to-train-a-group-banner

Not interested in this Course?

Tell us why:

This page has been viewed 14 times.