Add, edit, search for & delete records in a data list using a form & look up data; Sort records in a data list using a variety of methods; Filter data in a list using a variety of methods, work with filtered data; Create & work with subtotalled lists...
- Course Start Date: Jan. 31
- 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
- Seats Available: YES
- 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
Upon completion of the course, participants will be able to accomplish the following:
- Create and use Excel tables, as well as add, edit, search for, and delete records in a data list using a form, as well as look up data
- Sort records in a data list using a variety of methods
- Filter data in a list using a variety of methods, as well as work with filtered data
- Create and work with subtotaled lists, as well as use various database functions to summarize data
- Create, modify, and work with PivotTables, PivotCharts and Slicers
- Import external data from a variety of sources into Excel
Data List and Excel Table Concepts; Using Data Forms; Using Lookup TablesSorting Lists
Sorting Concepts; Sorting Lists; Custom Sort OrdersFiltering Lists
Filtering Concepts; Using AutoFilter; Using Advanced Filter; Working with Filtered Data
Automatic Subtotals; Working with Subtatalled Lists; Using Functions to Summarize DataPivotTables
PivotTable Concepts; Creating PivotTables; Modifying PivotTable Layouts; Working with PivotTables; PivotCharts; SlicersExternal Data
External Data Concepts; Importing Query Data from Access; Importing Query Data from Web Pages; Importing Query Data from Text Files
- Prerequisites & Certificates
Excel 2010 Level 2
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 5 times.