Custom Search
Home > Computer > Microsoft Office > Last Minute Training > Computer and IT Certification Seminars > Excel Datalist Management 2007
Provided by: Last Minute Training

Excel Datalist Management 2007

Excel

 Last Minute Training
Training Provided by Last Minute Training 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 subtotalled 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
This is primarily ilt training
Contact Last Minute Training for more information
Course Level:basic
Duration:1 days
Training Presented in:English

Excel Datalist Management 2007 Seminar Schedule

Date   Location    
5th Nov, 2009   Winnipeg, MB   [Register]
Excel Datalist Management 2007 Sorting Lists
Sorting Concepts
Sorting Lists
Custom Sort Orders

Filtering Lists
Filtering Concepts
Using AutoFilter
Using Advanced Filter
Working with Filtered Data

Summarizing Data
Automatic Subtotals
Working with Subtotalled Lists
Using Functions to Summarize Data
Working with Lists

PivotTables
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

Supplemental Topics
Data Parsing
About The Training Provider: Last Minute Training
Last Minute Training - Last Minute Training Corp. works similar to last minute discounted travel. We sell training seminars at deep discounts on a last minute basis. If you want to save 30 - 60 off high quality training seminars and have the flexibility to attend with only a few days notice check out our website and see if the training you are looking for is on sale. While your there set up and free account...
Home > Computer > Microsoft Office > Last Minute Training > Computer and IT Certification Seminars > Excel Datalist Management 2007
Advertise With Us
Do you offer excel training?
tcw11-gfc-v396M-11/24/09-22:33:05-()[B]-[B]-[B] -18:08:56