Learn: in:
» back to Search Results

Course rating of 0 Vendor rating of 4


This course will consist of the following lessons: Using Formulas In Excel Exploring Excel Functions Using Functions In Excel Working With Names And Ranges Working With Array Formulas Working With Lists and more!


Course Outline
Lesson 1.1 Using Formulas In Excel
Understanding Relative And Absolute Cell References
The Basic Mathematical Operators
Using Formulas With Multiple Cell References
The Formula Auditing Bar
Fixing Formula Errors
Displaying And Printing Formulas

Labs

  • Practice Exercise
Lesson 1.2 Exploring Excel Functions
What Are Functions?
Finding The Right Function
Some Useful And Simple Functions

Labs

  • Practice Exercise
Lesson 1.3 Using Functions In Excel
Inserting Functions
Using Functions And Autofill To Perform Difficult Calculations
Using The If Function
Working With Nested Functions

Labs

  • Practice Exercise
Lesson 1.4 Working With Names And Ranges
What Are Range Names?
Defining And Using Range Names
Selecting Nonadjacent Ranges
What Is Auto Calculate?

Labs

  • Practice Exercise
Lesson 1.5 Working With Array Formulas
What Are Array Formulas?
Using Basic Array Formulas
Using Functions With Array Formulas
Using The If Function In Array Formulas

Labs

  • Practice Exercise
Lesson 2.1 Working With Lists
What Is A List?
Creating Lists
Modifying Lists
What Is The Total Row?

Labs

  • Practice Exercise
Lesson 2.2 Working With Records And Fields
What Are Records And Fields?
Adding Fields By Inserting Columns
Adding Records By Inserting Rows
Adding Records With A Data Form
Finding And Deleting Records

Labs

  • Practice Exercise
Lesson 2.3 Working With Lists And Filters
Sorting A List
What Is An Autofilter?
Custom Autofilters
Using An Advanced Filter
Copying Filtered Records

Labs

  • Practice Exercise
Lesson 2.4 Using Excel As A Database
Filtering With Wild Card Characters
Validating Your Data
What Are Database Functions?
What Are Lookup Functions?

Labs

  • Practice Exercise
Lesson 3.1 Creating Macros In Excel
What Is A Macro?
Creating A Macro
Playing A Macro
Assigning A Shortcut Key To Macro
Macros, Buttons, And Toolbars

Labs

  • Practice Exercise
Lesson 3.2 Excel Form Controls
What Is A Form Control?
The Form Toolbar
Adding A Control To A Worksheet
Assigning A Macro To A Control
Using Form Controls

Labs

  • Practice Exercise
Lesson 4.1 Using Excel In Word
Inserting Excel Data In Word
Modifying Excel Data After Insertion
Linking Excel Data In Word
Linking An Excel Chart In Word

Labs

  • Practice Exercise
Lesson 4.2 Using Excel Other Programs And Files
Using Outlook To Send Excel Data
Opening An Excel File In A Different Format
Importing Data From A Text File
Importing Data From A Database

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.