Online Pivottables eLearning - Training Resources
Pivottables Training Provider? - Tell us about your Training!
From Online Training Directory
Office 2000 Advanced



...and export data.
Students will also be taught how to use PivotTables, PivotCharts, and how to merge and link workbooks. In Microsoft Access 2000, students will gain a more complete understanding of how to effectively create and use the primary database objects including tables, queries, forms, reports, and data access pages.
The course also teaches strategies for protecting data by enacting
more...
Excel 2000 Expert



...t, outline, and filter lists; import and export data; use PivotTables, PivotCharts, and data analysis tools; as well as how to merge and link workbooks.
Students will learn how to apply the advanced features of Microsoft Excel 2000 to work with records and ranges; sort, outline, and filter lists; and import and export data. In addition, students will be taught how to use PivotTables,
more...
Excel 2000 Level 3



Students will learn how to apply the advanced features of Microsoft Excel 2000 to work with records and ranges, sort records, outline and filter lists, and import and export data. The importance of proper management and password protection is also stressed.
Students will learn how to apply the advanced features of Microsoft Excel 2000 to work with records and ranges, sort records, outline and
more...
Excel 2000 MOUS



This course familiarizes students with many features of Microsoft Excel 2000, including entering text and formulas, moving data, formatting worksheet appearance, and manipulating charts. Students will also be able to apply the advanced features of Excel 2000 to work with records and ranges; sort, outline, and filter lists; and import and export data.
This course familiarizes students with many
more...
Excel 2000



This course begins by introducing students to the basic features of Microsoft Excel 2000, including entering text and formulas, moving data, formatting worksheet appearance, and manipulating charts. As students become more advanced, they will be able to work with records and ranges, sort records, outline and filter lists, and import and export data.
This course familiarizes students with the
more...
From Serebra Learning Corporation
Microsoft Excel 97 Advanced
... students learn how to perform "what-if" analysis, create PivotTables, exchange Excel data with other programs, control worksheet properties and calculations, and program with Excel. Performance-based Pre- and Post-Assessments create a custom course path for each learner covering only the topics not yet mastered. A searchable index and online glossary make the CBT a great reference tool long
more...
Introduction to Access 2002
To demonstrate the basic tools and features in Microsoft Access 2002 End-users seeking to become familiar with Microsoft Access 2002; end-users seeking to obtain Microsoft Office User Specialist (MOUS) certification in the use of Microsoft Access 2002 at Core level
more...
Analyzing Data in Excel 2007
Excel 2007 provides powerful data analysis tools that enable you to explore large amounts of data and to make educated business decisions based on that data. With PivotTable reports you can interactively summarize data, making it easier to analyze and present the results. PivotChart reports provide a graphical view of PivotTable report data. Using Goal Seek and Solver enables you to retrieve
more...
Working with Data and Presentation in Access 2003
To use PivotTables, PivotCharts, and other applications to present and handle database data Anyone wishing to become familiar with Microsoft Access 2003 at an advanced level; students seeking to obtain Microsoft Office Specialist certification in the use of Microsoft Access 2003
more...
Microsoft Excel 2000 Intermediate
This highly interactive CBT contains six units that cover intermediate Excel skills. Through step-by-step instruction within a realistic simulation of Microsoft Excel 2000, students learn how to manage workbooks, automate tasks, use and analyze list data, enhance charts and worksheets, and work with Excel and the Internet. Performance-based Pre- and Post-Assessments create a custom course path for
more...
Microsoft Excel 2000 Advanced
... students learn how to perform "what-if" analysis, create PivotTables, exchange Excel data with other programs, control worksheet properties and calculations, and program with Excel. Performance-based Pre- and Post-Assessments create a custom course path for each learner covering only the topics not yet mastered. A searchable index and online glossary make the CBT a great reference tool long
more...
Creating Queries Forms with Access 2002
The Creating Queries and Forms with Access 2002 WBT is the second course of the Office XP: Access 2002 curriculum, which familiarizes users with the advanced features of Access 2002 that they can use while retrieving and presenting data stored in an Access database. These features include formulating simple and advanced SQL queries, and creating and designing forms. Additionally, this course
more...
Using Advanced Data Management Techniques
The Using Advanced Data Management Techniques WBT is the third course in the Office XP: Excel 2002 curriculum. This course teaches the users how to create lists in Excel and manage them by filtering, sorting, subtotaling data, and specifying validation criteria. Additionally, it explains the procedures involved in importing data in Excel from external sources, such as Access databases, text files,
more...
Advanced Tools of MS Excel 2000
This course is the third course in a series of three in the Excel 2000 curriculum. This course covers the creation of PivotTables, PivotCharts, macros, and databases. The course introduces students to maps and templates in Excel. The course also describes linking of office documents with object linking and using hyperlinks with other office documents.
more...
From Software Training Academy, Inc
Microsoft Excel - Advanced

... functions such as DSUM. They will learn how to work with PivotTables and PivotCharts, how to import and export data, and how to query external databases. Finally, students will learn about the analytical features of Excel (such as Goal Seek and Solver), running and recording macros, and sharing Excel data via the Web.
Designated as Approved Courseware for the Microsoft Certified Application
more...
From Teach Me IT
Advanced Tools of Excel 2000

... 2000 curriculum. This course teaches the users to create PivotTables, PivotCharts, macros, and databases. The course introduces students to maps and templates in Excel. The course also describes linking of office documents with object linking and using hyperlinks with other office documents. After completing this course, the student will be able to:
Create and format charts
Create and
more...
Creating Queries & Forms with Access 2002

...urse guides users in efficient presentation of data using PivotTables and PivotCharts. After completing this course, the user will be able to:
Create simple queries
Perform calculations in queries
Specify selection criteria
Create special purpose and action queries
Create SQL specific queries
Identify the components of a form design window
Create a form and add data controls, Object
more...
Using Advanced Data Management Techniques

...kes the user through the process of creating and managing PivotTables and PivotCharts as well as scenarios and reports to analyze data. Users can also learn how to create and use macros to automate long and repetitive tasks in Excel. After completing this course, the users will be able to:
Build, sort, and filter lists
Validate data and calculate subtotals
Use functions to analyze list
more...
From Skillspride Online Training
Microsoft Excel 2002 (XP) Professional
This course will give readers the ability to analyze and manipulate data and to share workbooks in a team workgroup environment. Readers will learn how to audit and analyze data using outlines, PivotTables, Goal Seek, Solver and Scenario Manager and to use the workgroup features of Excel 2002.
more...
Microsoft Excel 2002 (XP) Professional
This course will give readers the ability to analyze and manipulate data and to share workbooks in a team workgroup environment. Readers will learn how to audit and analyze data using outlines, PivotTables, Goal Seek, Solver and Scenario Manager and to use the workgroup features of Excel 2002.
more...
ECDL AM4 Advanced Spreadsheets with Excel 2002
This course is designed to help you to obtain the skills and knowledge required for ECDL AM4 " Advanced. You will learn to use Excel 2002 to create an advanced spreadsheet, incorporating different functions, linked data, and custom formats. You will learn to add PivotTables and apply complex chart formatting. You will also be able to use spreadsheet tools, including PivotTables, scenarios,
more...
