Learn: in:
» back to Search Results

Course rating of 4 Vendor rating of 4

In this level you will learn to make formulas using single and multiple operators along with absolute references. You will name ranges and learn how to use these in array formulas, work with tables and view information as a database in Excel.

  • Course Start Date: Nov. 10
  • Location: Winnipeg (Map)
  • Time: 8:30 am - 4:00 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
  • 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.
  • Discount Seats Available:3
  • Category:Microsoft Excel Training

Course Outline
Microsoft Office Excel 2010 is the latest offering of Microsoft's spreadsheet program. Excel is a popular tool for creating spreadsheets, analyzing data, and charting information. This new version of Excel incorporates robust error checking, numerous file validation/verification tools, image editing, and Sparklines (charts within individual cells).

This Intermediate level is intended to help everyday users of Excel become more proficient by expanding their knowledge of functions, formulas, and new Excel features. This manual will also help more experienced users who have little to no experience with Excel 2007 and the ribbon interface.

Advanced File Tasks
This section teaches students how to use the Open and Save dialogs to create new files and folders. It also covers file types that are compatible with Excel, how to work with older file formats, and how to protect their workbook against accidental or intentional changes to the data. Finally, this section will discuss the many file management tools and checkers that are used to scan workbooks for personal information and compatibility issues.

Working with Functions and Formulas
In this section, participants will learn how to properly reference cells, use mathematical operators, and how to check their formulas for errors. This section also covers how to browse, insert, and use functions to perform complex mathematical operations. Students will learn how to use the IF function, use nested functions to perform multiple operations, and define and use range names. Finally, array formulas will be discussed.

Managing Tables
Tables are an important part of Excel because they inherently contain a lot of useful functionality, including sorting and filtering. This section teaches participants how to add and edit tables, edit table information, perform sort and filter operations, and even how to use Excel as a database.

Adding the Finishing Touches
This section details how to round off a spreadsheet by discussing how to check spelling and use the research pane to look up words, facts, and figures. Students will learn how to apply and use theme effects and create text boxes, pictures, and Clip Art. Basic image editing will also be discussed.

Showing Data as a Graphic
This final section will show how to turn data into informative visual aids. Students will learn how to add and edit SmartArt; how to add symbols, special characters, and equations; and also how to add and edit shapes. Finally, the new Sparkline feature will be discussed, showing participants how to add, edit, and customize these useful graphs-in-a-cell.

Prerequisites & Certificates

This manual presumes that the user has a good working knowledge of Windows, including concepts such as using the Recycle Bin and Control Panel, and is fully capable of using the keyboard and mouse. It also presumes that the user has completed Level 1 of this course (or has equivalent knowledge) and is familiar with concepts such as cut, copy, paste, navigating, using multiple worksheets and create basic charts.

Certificates offered

Certificate of Completion

Cancellation Policy
Cancellation Policy & Satisfaction Guarantee
You may cancel or reschedule your registration without penalty up to 5 business days before your class date.

Training Details
ASAP Training Ltd. is located at 950 - 167 Lombard Avenue, in Exchange District. A training manual is provided. We encourage all students to bring in a USB stick for student files as we no longer hand out course files on a CD.

Finding Us
ASAP Training Ltd. is located in the picturesque downtown Exchange District at 950-167 Lombard Avenue, in the Grain Exchange Building, you can access the building from Rorie Street and Lombard Avenue.

Class Times and Other Details
ASAP Training Ltd. classes begin promptly at 8:30 am and end around 4:00 pm. Our doors open at 8:00 am. Coffee and tea are provided for students. We have a kitchen with a microwave and refrigerator available for student use if they wish to bring their own lunch. Lunch break is one hour from approximately 11:30 to 12:30. A telephone and sitting area are available for student use. Our office is a non-smoking facility and is wheelchair accessible.

There are many restaurants available within walking distance of the school.

For your convenience, we have also provided a map of the available Parking Lots in proximity to the Grain Exchange Building, indoor and outdoor parking.
Map & Reviews
ASAP Training.ca
[ View Provider's Profile ]

ASAP - New Location
950 167 Lombard Avenue
Winnipeg, MB
Canada   R3B 0V3

This was a very useful course. Because they allow you to take the course again one time for free I believe within 6 months I will probably attend again for a refresh!
Reviewed by 2015
I think ASAP offers a better quality of training than their competitors here in Winnipeg.
Reviewed by 2015
The instructor was very knowledgeable regarding Excel. She provided some helpful tips that was not provided in the manual.
Reviewed by 2014
1) One hour for lunch is too long of a break. I would rather take a 1/2 hour and go through more material; 2) The electronic excel files pertaining to the exercises in part 2 of the manual should automatically be provided with the manual. I was provided only sections 2 & 3 excel examples after special request.
Reviewed by 2014
Competent trainers and course material was taught well.
Reviewed by 2013
I was very disappointed with the instructor, the environment & the material covered. I went in with expectations from reading the course outline, of certain topics to be covered, and they were not. The instructor was FAR from professional, in fact I was shocked she has been leading the course. I think I have limited knowledge of excel, yet still feel I could of done a better job leading the class. After my experience, I would NOT recommend this facility to anyone. Very disappointing, waste of money & time.
Reviewed by 2013
I felt the instructor was very unprofessional ie: shared way too many personal stories that really had nothing to do with excel, was very negative when classmates asked questions. Personal appearance was unprofessional. She put herself down constantly which creates a complete lack of confidence in those hoping to learn from her knowledge! Yawned all through class and didn't hesitate to give us several personal reasons why! Computers amounst the seven of us were configured differently which gave some of us different results. Keyboards, mouse etc. very dirty. Classroom very cramped. In my opinion, not enough time spent on "true" excel - formulas,etc. and way too much time on how to make things "pretty" ie - customizing your colors and headlines, inserting graphics etc. Instructor had a different book so she was unable to reference the page for us to follow along. On the positive size, 7 is a great class size and I feel I will be able to make great use of the book we were given.
Reviewed by 2013
I wasn't greeted at the door on arrival and had to find someone to ask what room I was supposed to be in. There was another instructor who arrived the same time as I did, but she was more concerned about looking after another client who was in the office. She didn't even bother asking what class I was scheduled to take. I view this as poor customer service. After waiting around for 15 minutes or more, I went to the back of the office to find someone to assist me. Once we got into the session, I discovered that the Excel 2010 did not cover anything to do with InfoPath - which was my main reason for attending. While I learned a few things about Excel 2010, I did not get answers to many questions I had regarding InfoPath. Following the session, I called the office and requested the class examples that were used be sent to me - I also noted this on the evaluation sheet. As well, I asked for step-by-step instructions for inserting additional icons on the Tool Bar when doing Excel documents. The person who answered the phone said she would pass my request on to Christina Bower, who was not available when I called. To date, I have not received anything from Presidio.
Reviewed by 2011
10-November-2016 $196 Regular Price $245 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!

Not interested in this Course?

Tell us why:

This page has been viewed 26 times.