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 Outline
Upon completion of the course, participants will be able to accomplish the following:
- 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 and PivotCharts
- Start MS Query, define a data source and add a table to the query window, as well as add and manage fields in the data pane, return data to Excel, and import data from Web pages
- Import text files using the Text Import wizard
Sorting Concepts; Sorting Lists; Custom Sort Orders
Filtering Concepts; Using AutoFilter; Using Advanced Filter; Working with Filtered Data
Automatic Subtotals; Working with Subtotalled Lists; Using Functions to Summarize Data; Working with Lists
PivotTable Concepts; Creating PivotTables; Modifying PivotTable Layouts; Working with PivotTables; Additional PivotTable Information; PivotCharts
Using MS Query to Retrieve Data
Overview; Starting Query from Excel; Defining the Data Source; Query Wizard; Returning Data to Excel; Microsoft Query; Refreshing Data from a Query; Importing Query Data from Web Pages;
- Prerequisites & Certificates
Excel 2007 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 ]
ReviewsHere are some reviews of the training vendor.
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.
This course currently does not have any dates scheduled. Please call 1-877-313-8881 to enquire about future dates or scheduling a private, in house course for your team.
This page has been viewed 2408 times.