Instructor Led Summarize Training - Training Resources

Microsoft Excel 2007 Pivot Tables and Data List Management Learn how to add, edit, search for, & delete records in a data list using a form. How to sort data in a data list, creating & working with subtotaled lists, using various database functions to summarize data, creating &working with pivot tables & charts  more...

Microsoft Excel 2003 Pivot Tables and Data List Management - uofa Learn how to add, edit, search for, & delete records in a data list using a form. How to sort data in a data list, creating &working with subtotaled lists, using various database functions to summarize data, creating &working with pivot tables & charts.  more...

Microsoft Excel 2000 2003 Level 3 Data List Management - nexient 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  more...

Excel Datalist Management 2007 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  more...

Excel 2003 Analyzing Summarizing Data with Pivot Tables Do you want learn why and when you can use a pivot table or pivot chart to analyze and summarize data. This workout covers creating and modifying pivot tables, filtering and formatting data, customizing pivot table options, and creating pivot charts.  more...

Access 2003 Working with Reports Do you want to summarize data from your database in a report you can print? Do you want to learn some of the different ways to view and generate Access reports and to modify, enhance, and sort the data you capture in a report?  more...

Excel 2007 Analyzing and Summarizing Data with Pivot Tables Do you need to analyze data? Learn why and when you can use a pivot table or pivot chart to analyze and summarize data. This workout covers creating and modifying pivot tables, filtering and formatting data, customizing pivot table options, and creating pivot charts.  more...

Access 2007 Working With Reports Do you want to summarize data from your database in a report you can print? Do you want to learn some of the different ways to view and generate Access reports and to modify, enhance, and sort the data you capture in a report?  more...

Excel Datalist Management 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  more...

Microsoft Excel - Module 2 Functions and Multiple Worksheets This course is the second of six modules (levels) that we have to offer for Microsoft Excel 2000/2002/2003... Objectives * Use labels and reference names in formulas * Use simple and complex mathematical * functions * Manage workbook worksheets * Perform calculations with references to multiple * worksheets and multiple workbooks * Summarize data with data  more...

Dive Into Microsoft Excel Spreadsheets and Workbooks Keeping track of sales figures, statistics or mortgage payments has never been easier, or more difficult. Microsoft Excel gives you the power to develop formulas using built-in functions, Use charts and graphs to predict trends and understand relationships, Consolidate data from several worksheets into one, Find and organize information by filtering, sorting, and grouping, Summarize and analyze  more...

Dive Into Microsoft Excel Worksheet Intermediate Editing a Spreadsheet Tips, Tricks and Shortcuts Enter and format your data, and write formulas Develop Formulas using Built-in Functions Use charts and graphs to predict trends and understand relationships Create a template to speed up your work Using the AutoFill and Custom Fill Create and Edit Forms Consolidate data from several worksheets into one Find and organize information by filtering,  more...