Learn: in:
» back to Search Results

Course rating of 4 Vendor rating of 4


This course will teach you how to use formulas and advanced functions,� create, sort and filter, add and format graphics, and protect and finalize a workbook.


 
Course Outline
 
This course will teach you how to use formulas and advanced functions,  create, sort and filter, add and format graphics, and protect and finalize a workbook.
Course Outline

EXPLORE THE USER INTERFACE (IF REQUIRED FOR UPGRADE STUDENTS)

  • Office Button
  • Ribbon Overview
  • Mini Toolbar
  • Status Bar
  • Shortcut Key Tips
  • Contextual Tabs

 OPTIONS

  • Change Excel Options
  • Manipulate data
  • Use Automatic Outlining
  • Display and Collapse Levels
  • Manually Group Data
  • Create Subtotals

 PIVOT TABLES

  • Create a Pivot Table
  • Change and Rearrange Pivot Table Data
  • Modify Pivot Table Format and Structure
  • Chart a Pivot Table
  • Create a Pivot Table from External Data

 USING EXCEL WITH OTHER PROGRAMS

  • Link to an Access Database
  • Transform Excel into an Access Database
  • Import and Export Data to and from Text and CSV files
  • Import Data from External Sources
  • Link and Embed from Other Sources

 ADVANCED CALCULATIONS

  • Create and Use Scenarios
  • Create a Scenario Summary Report
  • Save Multiple Scenarios
  • Use a One and Two Input Data Table
  • Use Goal Seek
  • Use the Solver

 EXCEL AND THE INTERNET

  • Add, Modify and Remove Hyperlinks
  • Save Workbooks, Sheets, Charts and Ranges as Webpages
  • Create, Save and Refresh a Web Query
  • Publish to a Document Server

 ADVANCED TASKS

  • Create, Open and Edit a Shared Workbook
  • Track Changes in a Shared Workbook
  • Create, Use and Modify Custom Lists
  • Use VLOOKUP
  • Consolidate Workbooks
  • Link Workbooks
  • Combine Worksheets

 MACROS

  • Macro Security
  • Record and Play a Macro
  • Record and Run a Relative Reference Macro
  • Assign a Macro to a Keystroke or Quick Access Toolbar

 FORMS

  • Create a Blank User Form
  • Add and Use Form Controls
  • Assign a Macro to a Control

Additional Details
Pre-Requisites

The prerequisites for this course are an intermediate Excel course, or equivalent working knowledge of the software

Certificates offered

Certificate 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
 

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

Excellent instructor and it was a smaller group of students so the instructor really tailored it to the students attending the course.
Reviewed by 2012
We had an excellent instructor! She was very knowledgeable and would take the extra time to assist you if you needed extra instruction.
Reviewed by 2012
I enjoyed the Access 2010 course. the instructor was very knowledgeable and presented the topic well. The only negative aspect was that no written training materials were offered until the course was completed. Would have liked to be able to make notes as we went along for future reference.
Reviewed by 2012
My teacher was wonderful, and i have already singed up for more classes at this location.
Reviewed by 2012
The course was initially scheduled for 2 days but due to instructor availability it was shortened to one day. I am very computer literate, work full time in an office, and go to business school in the evenings and it was a little tough to learn everything in one day because there was no time for practice. Yes it was useful to find out what the program is capable of, but since it was shortened there was no time for individual practicing or trying things out on your own. Next time the class would be much better suited for the initial 2 day class.
Reviewed by 2012
All in all, this training was not that great. The first part moved very slowly, and then toward the end, the instructor plowed through to get finished. Possibly the most incredible part was that the course taught how to create forms, but not how to deploy or use them. The instructor said for that, participants would have to take the follow up course. What use is it to create forms if they can't be used? No handouts at all? Other courses I've taken provide full books with step by step coverage of everything done in the classroom. It's impossible to go back and review things.
Reviewed by 2012
My most significant feedback is that the course was advertised as Working with Data using SQL for the 'non-database administrator'. Of the 10 course modules, nearly half were presented by the instructor as tasks that would be completed by a database administrator. While it is helpful to have a general understanding of a database administrators interaction with SQL, far too much of the course content was aimed at the database administrator level. Otherwise, use of technology for remote teaching and the instructor himself were both excellent.
Reviewed by 2012
Very helpful course. Excellent instructor.
Reviewed by 2012
I only rated the location bad because i don't like driving down town. Otherwise it was a good course.
Reviewed by 2012
The course was great.
Reviewed by 2012
Excellent Instructor ,Excellent location,
Reviewed by 2012
excellent trainer really knows her stuff
Reviewed by 2012
The instructor was excellent and very knowledgeable! I found the course information extremely useful for the business world and I am looking forward to putting together presentations that impress!The facilities and snacks and drinks provided were great too!
Reviewed by 2012
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.

 

This page has been viewed 1150 times.