Custom Search
Home > Last Minute Training > Computer and IT Certification Seminars > Microsoft Excel 2000 2003 Level 3 Data List Management - nexient
Provided by: Last Minute Training

Microsoft Excel 2000 2003 Level 3 Data List Management - nexient

 Last Minute Training
Training Provided by Last Minute Training Who should attend? This course is intended for participants who are familiar with Excel 2000/ 2002/ 2003. Performance Objectives 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, 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, 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, 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
Microsoft Excel 2000 2003 Level 3 Data List Management - nexient Course Outline
Maintaining Data Lists
Data List Concepts
Using Data Forms
Using Lookup Tables
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 > Last Minute Training > Computer and IT Certification Seminars > Microsoft Excel 2000 2003 Level 3 Data List Management - nexient
Advertise With Us
Do you offer microsoft training?
tcw11-gfc-v396M-11/23/09-20:57:07-()[A]-[B]-[A] -13:51:46