Microsoft Excel (2000, XP, 2003) (Level 3 / Advanced)

Students will learn how to work with datasets by grouping data, creating pivot tables, adding hyperlinks, share workbooks, and create advanced macros.

Course Outline

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

Course Outline

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
• Compare and Merge Workbooks

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

OPTIONS

• Customize Toolbars
• Change Excel Options

FORMS

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

Additional Details

Pre-Requisites

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 ]

Ottawa Office
Suite 220, 350 Sparks Street
Delta Office Tower
Ottawa, Ontario
Canada   K1R 7S8

Reviews

 

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

   

excellent trainer really knows her stuff

Reviewed by Texas F. 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 Treena S. 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 Jacquie D. 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 Andrea B. 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 Rehan F. 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 Mindelle J. 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 Sheila D. 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 Martin R. 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 Rose . 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 Hala M. 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 Micheline A. 2011

   

All good. Enjoyed it very much.

Reviewed by Wendy P. 2011

   

I didn't fill out your form because I filled one out at the end of the course.

Reviewed by Carlina D. 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 Fred M. 2011

   

no, everything is ok

Reviewed by Ghassan A. 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 Yves J. 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 Shayne B. 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 Amy C. 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 Stephen V. 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 Cheryl Z. 2011

   

Ran on schedule, with knowledgeabe instructor. Small class allowed for specific questions that are relevant to my work. Thank you

Reviewed by Mary . 2011

   

No, everything was perfect, Thank you I learned alot.

Reviewed by Sharon K. 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 Beverley . 2011

   

No everything and everyone was excellent

Reviewed by Sharon K. 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 Stefanie C. 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 Kathryn M. 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 Paula S. 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 Zainab A. 2011

   

No, everything was excellent. I am even taking the next level course next week.

Reviewed by Sharon K. 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 Bev P. 2011

   

Good Environment and course format.

Reviewed by Randy T. 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 Nicole S. 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 Valroy A. 2011

   

I believe the seminar was just a little long - could have been done in 1.5 days. Otherwise - Excellent!

Reviewed by Christiane C. 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 Barbara F. 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 Larry P. 2011

   

instructor lack knowledge on the subject matter.

Reviewed by Rashed S. 2011