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
- Course Start Date: Dec. 18
- Location: Winnipeg
- Time: 8:30 am - 4:00 pm (Note on end times)
- Duration: 1 Day
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.
- Delivery Method(s):Instructor Led
- Discount Seats Available:2
- Category:Microsoft Excel Training
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.
- 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 1: Advanced Formula Tasks
Understanding Relative and Absolute Cell References
Using Multiple Cell References
Using 3D References
Using Array Formulas
Module 2: Working with Named Ranges
Understanding Named Ranges
Defining Named Ranges
Editing Named Ranges
Deleting Named Ranges
Using Named Ranges in Formulas
Module 3: Using Advanced Functions
Using the PMT Function
Using the FV Function
Using VLOOKUP and HLOOKUP Functions
Using IF, AND, OR Functions
Module 4: Resolving Formula Errors
Tracing Formula Precedents and Dependents
Setting Error Checking Options
Using Error Option Buttons
Module 5: Managing Data
Configuring Data Validation
Converting Text to Columns
Module 6: Outlining and Grouping Data
Showing and Hiding Outline Details
Removing Outlining and Grouping
Module 7: Working with Scenarios
Creating a Scenario Summary Report
Module 8: Using Solver
Setting up the Worksheet
Generating Reports and Scenarios with Solver
Setting Solver Options
Running an Error Check
Module 9: Analyzing Data
Enabling the Analysis ToolPak
Using Data Analysis Tools
Using Goal Seek
Using Data Tables
Module 10: Advanced PivotTable Feature
Creating a Basic PivotTable
Creating a Basic PivotChart
Using the PivotTable Fields Pane
Adding Calculated Fields
Sorting Pivoted Data
Filtering Pivoted Data
Module 11: Using PowerPivot
Importing Access Data
Importing Excel Data
Integrating Data with Relationships
Creating a PivotTable with PowerPivot Data
Module 12: Using Macros
Running a Macro
Writing a Macro using the Visual Basic Editor
Editing a Macro
Recording a Macro
- Prerequisites & Certificates
Excel 2013 Level 1 or equivalent experience
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.
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.
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
[ View Provider's Profile ]
ASAP - New Location
950 167 Lombard Avenue
Canada R3B 0V3
Registration is fast, and will take approximately 3 minutes. There is no membership fee.
» You are also welcome to Make an Offer
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!
This course is also scheduled on the following dates:
Not interested in this Course?
Tell us why:
This page has been viewed 52 times.