This covers a wide range of topics, including advanced formula tasks, working with named ranges, using advanced functions, resolving formula errors, managing data, outlining and grouping data, working with scenarios, using Solver, the Analysis ToolPak, P

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.

Seats Available: YES

Category:Microsoft Excel Training

Course Outline

Microsoft Excel 2013 has lots of time-saving tools. Do you know how to make the most of them? The modules in the course will show you how! This advanced course covers a wide range of topics, including advanced formula tasks, working with named ranges, using advanced functions, resolving formula errors, managing data, outlining and grouping data, working with scenarios, using Solver, the Analysis ToolPak, PivotTable features, using PowerPivot, and developing macros.

Module 12: Using MacrosRunning a MacroWriting a Macro using the Visual Basic EditorEditing a MacroRecording a Macro

Prerequisites & Certificates

Pre-Requisites

Excel 2013 Level 1 or equivalent experience

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.

F.A.Q's...
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.

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

Parking
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.
http://www.grainexchangebuilding.com/leasing/parking.html

Reviews

Everything was excellent. The questionnaire doesn't mention cost or value but I thought it was excellent value for the cost. I already have a co-worker attending another course there in the next few weeks.

Reviewed byJodie S.2018

Excellent course to take. I have learned some short cuts with excel that I have never used before.

Reviewed byNenita V.2017

It would be nice to have some of these spread over two days possibly or offered on a weekend as I own my own business and getting away for full days is not easy and also a lot to digest in one day..I do realize we can take a refresher at no extra cost within a time period and you offer all sorts of support which is great option....

Reviewed byNicolette .2015

the book was very helpful and continues to be helpful

Reviewed byjodi v.2015

The course should be broken down into a longer timeline. There was alot of content to cover and because of this fact we did not have a thorough opportunity to develop our skills to suit what was proposed to be taught in the course and thus did not get to cover every section of each module. :(

Registration is fast, and will take approximately 3 minutes. There is no membership fee.» You are also welcome to Make an Offer

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!