Learn: in:
» back to Search Results

Course rating of 0 Vendor rating of 4


This course will consist of the following lessons: Outlining And Grouping Your Data Pivot tables Exploring Scenarios What If Analysis Excel And Hyperlinks Excel Workbooks As Web Pages Creating And Using Shared Workbooks and more!


Course Outline
Lesson 1.1 Outlining And Grouping Your Data
Using Automatic Outlining
Displaying And Collapsing Levels
Grouping Data Manually
Creating Subtotals

Labs

  • Practice Exercise
Lesson 1.2 Pivottables
What Is A Pivottable?
Creating A Pivottable Frame
Specifying Data In A Pivottable
Rearranging Pivottable Data

Labs

  • Practice Exercise
Lesson 1.3 More On Pivottables
Modifying Pivottable Calculations
Formatting A Pivottable
Refreshing A Pivottable
Charting A Pivottable
Creating A Pivottable Based On Data From An External Database

Labs

  • Practice Exercise
Lesson 1.4 Exploring Scenarios
What Is A Scenario?
Creating A Scenario
Creating A Scenario Summary Report
Saving Multiple Scenarios

Labs

  • Practice Exercise
Lesson 1.5 What If Analysis
Using A One And Two Input Data Table
Using Goal Seek
Using Solver

Labs

  • Practice Exercise
Lesson 2.1 Excel And Hyperlinks
Hyperlinks And The Internet
Inserting Hyperlinks
Modifying Hyperlinks
Using The Web Toolbar
Browsing Hyperlinks In Excel

Labs

  • Practice Exercise
Lesson 2.2 Excel Workbooks As Web Pages
Interactive And Non-Interactive Web Pages
Saving A Workbook As A Web Page
Saving A Worksheet As A Web Page
Saving A Chart As A Web Page
Saving A Range As A Web Page

Labs

  • Practice Exercise
Lesson 2.3 Getting Data From The Internet
Importing From An External Data Source
Creating A Web Query
Saving A Web Query
Refreshing A Web Query

Labs

  • Practice Exercise
Lesson 3.1 Creating And Using Shared Workbooks
Sharing A Workbook
Requesting Reviews
Reviewing A Workbook
Tracking Changes
Merging And Revising A Shared Workbook

Labs

  • Practice Exercise
Lesson 3.2 Visual Basic And Macros
Adding Code To Your Macro
Adding Comments To Vba Code
Declaring Variables
Prompting For User Input
Iteration Over A Range
Using If Then Else Statements

Labs

  • Practice Exercise
Lesson 3.3 Advanced File Management
Identifying File Properties
Searching For Files
Protecting Personal Information
Creating Back Up Files
Changing Auto-Recovery Settings

Labs

  • Practice Exercise
Lesson 3.4 Excel Security
Digital Signatures
Macro Security
Protecting Your Workbook With A Password

Labs

  • Practice Exercise
Lesson 3.5 Custom And Advanced Features In Excel
Customizing Excel By Changing Options
Using Custom Autofill Lists
What Is Text To Speech?
Using Detect And Repair

Labs

  • Practice Exercise

Additional Details
Pre-Requisites

Prerequisites include an introductory course in Excel or equivalent working knowledge with the software.

Certificates offered

Certification of Completion


Cancellation Policy
There is no consequence if you cancel/reschedule this registration with a minimum of 10 business days notice prior to the first day of this course. Full payment is required if you cancel/reschedule this registration within the non-cancellation period of 10 business days prior to the first day of the course. Substitutions are welcome.
Map & Reviews
ctc TrainCanada
[ 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.
The one and only issue I had was with parking, unexpectedly having to pay and not having enough cash for this as well as there not being very much parking. It made me late for the class, even though I actually arrived there early!
Reviewed by 2012
Esther (the instructor) was awesome. Her charisma and upbeat attitude really added to my experience and made it a pleasurable course to take.
Reviewed by 2012
This level of Excel should not be considered as advanced level. It is rather biginner level. I was expecting to learn more. 95% of the content I already knew.
Reviewed by 2012
A good seminar but quite a lot of info to take in during a one-day course for someone who hasn't done Word before. A bit overwhelming! Perhaps a two-day course would work better so could have time to actually practice what we're being taught. A little hard to see the projector from the back. Otherwise, very useful.
Reviewed by 2011
I signed up at one facility in Ottawa and it got switched to a different training facility location in Hull, Quebec. There were several emails confirming the course, however, I just happen to notice one email stating the new location. LastMinuteTraining was good to try to look into for me. In the end, the training provider provided me with taxi chits and it all worked out. I was not aware that the training provider had 2 locations and would switch the location at the last minute. I was upset because I do not know the bus system in Hull, Quebec.
Reviewed by 2011
Html lvl 1 and this course should be merged course can be extended to 2 days of instruction and include more in depth material. Do not recomend taking html lvl one.
Reviewed by 2011
I enjoyed the course thoroughly and learned as much as I could in a 3 hour class, however, I think I would have preferred a longer class as we were a bit rushed going through the material.
Reviewed by 2011
The course was 3 hours long becasue there was only the 2 of us in the office completing this course. 3 hours is very short to learn Outlook. More time is required.
Reviewed by 2011
Handouts were in pdf however, the screens were not big enough to open two files (handout and Project file) together and we had to toggle a lot. It was very annoying. Either give paper handouts or much bigger screens or two screens per student.
Reviewed by 2011
All good. Enjoyed it very much.
Reviewed by 2011
I didn't fill out your form because I filled one out at the end of the course.
Reviewed by 2011
MY BIGGEST BEEF IS THAT THE BOOK WAS VERSION 2010 AND THE SOFTWARE WAS 2007, WE MISSED A LOT OF WHAT 2010 COULD DO BECAUSE OF OLD SOFTWARE INSTALLED ON THE SERVER, THE INSTRUCTOR HAD SOME PROBLEMS NAVIGATING THROUGH THIS.
Reviewed by 2011
no, everything is ok
Reviewed by 2011
This two-day training was jam-packed with information, with a good balance between demonstrations and exercises to verify that the students understood the subject matter. I do not believe that the instructor could have used the time more efficiently then he did.
Reviewed by 2011
Project 2010 was a brand new course, as such there were a few things that the instructor could not find (in the new "ribbon" layout). He did spend extra time during his breaks to find what he couldn't before, then showed them to the class once we all returned. Overall, this was a very useful and enjoyable training course.
Reviewed by 2011
I took a course that was remote and I don't think that I would take a remote course again. The instructor didn't really make himself available for questions. Even when their was questions he would take them offline if they took more then 5 minutes to answer. Never brought the results back to the group. Never went over the labs just lectured in between. Didn't bother to learn anyone's name. I think the experience would be better if each user in the class had a headset and could speak to the instructor instead of it being a conference call.
Reviewed by 2011
CTC Train Canada was professional and helpful in ensuring I got the most out of my training course. Overall I am most happy with them.
Reviewed by 2011
The course was held via remote. The course it self was alright, all content was directly from the book. The teacher was in another time zone and he wanted to start the course before my location even opened. I told him that, he did it anyways. So I was out of sync the whole time. On the last day lunch was at 10 am! The instructor said he would watch screens to see when we got stuck. Not once did that happen. He couldnt even troubleshoot the labs. He only really talked to the student in the room, pretty much said nothing to rest of us. He even took personal calls!
Reviewed by 2011
Ran on schedule, with knowledgeabe instructor. Small class allowed for specific questions that are relevant to my work. Thank you
Reviewed by 2011
No, everything was perfect, Thank you I learned alot.
Reviewed by 2011
Alot of material to cover in the course. I would recommend that this be a 2-day course. Re. course content - should contain more examples to work on. Before moving to another section in the course the Instructor should summarize what was covered (i.e. go through the steps required to complete each task). Task and steps should be given on a handout for future reference.
Reviewed by 2011
No everything and everyone was excellent
Reviewed by 2011
Did not find it helpful that no course material was handed out. What was learned on that day was easily forgotten without the ability to make notes to refer to.
Reviewed by 2011
It is great to have access to the online training manuals, but it would be nice to have some handouts for reference. Not everyone has time to do the online training or to consult the manuals. The training location is very convenient to the highway. Lyse Brooks is an amazing instructor. She is extremely knowledgeable and patient. She spent time with each participant helping each person with their individual needs. She gave us a hands-on exercise that allowed us time to practice and learn. The instructor at the Intermediate Word course (same training facility) did not provide the same high level of training.
Reviewed by 2011
The instructor was very nice, personable and had a great sense of humour which made for a productive and pleasant day of learning.
Reviewed by 2011
The course is good for a basic overview of many advanced Excel features. The instructor and facilities were good. However, some of the items listed on the syllabus (new features in Excel 2010) were NOT covered and it wasn't due to a lack of time. I came to find out that the instructor had not planned to cover them at all. This was very disappointing, especially since we took very look breaks (easily almost 2 hours of combined break time in a class that went from 9-4) so there was ample time to cover the topics.
Reviewed by 2011
No, everything was excellent. I am even taking the next level course next week.
Reviewed by 2011
It was unfortunate that the local instructor was not available and I had to call in remotely to a class in Toronto. I did have the instructor screen available and I liked that. The first part of the course was helpful as the instructor moved through the functionality of MS Project and we could follow along on our own screen. I learned a lot about functionality with this instructor led demonstration, and the ability to follow along on my computer was great! I did find that after the first demonstration, a lot of time was spent working independantly, with the instructor available for questions. I thought there should have been more instructor led demonstration, perhaps one on our own, followed by another instructor led example. I didn't like spending well over 50% of the course time practicing on my own. If this is how all classes are run, I would not take another one, nor recommend this class.
Reviewed by 2011
Good Environment and course format.
Reviewed by 2011
With CTC can't go wrong. Although I've appreciated that this course took one day only. I really think that this course could be hosted for (1) day only. Two days is too long.
Reviewed by 2011
I think the course is excellent. Some of the thing I learn I am implementing in our warehouse as we speak. Our instructor was very knowlegeable, caring, a good listener, she was magnificent.
Reviewed by 2011
I believe the seminar was just a little long - could have been done in 1.5 days. Otherwise - Excellent!
Reviewed by 2011
course was cancelled due to a "family emergency" I was notified upon arriving at the facility - flew from Windsor to Toronto. Totally unprofessional!!
Reviewed by 2011
An excellent course with an excellent teacher. For me personally this course gives me some more options, and guidence into the job and its responsibilites. We here are constantly trying to improve on accuracy, of the inventory on a day to day basis.
Reviewed by 2011
instructor lack knowledge on the subject matter.
Reviewed by 2011

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