Online Pivottable eLearning Training
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...
Advanced Data Manipulation and Analysis in Excel 2002
To provide an overview of the advanced data manipulation and analysis features in Excel 2002 End-users seeking proficiency in the use of Microsoft Excel 2002 at an advanced level; end-users seeking to obtain Microsoft Office User Specialist (MOUS) certification in Microsoft Excel 2002 at Expert level
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
...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 required results from formulas by determining the data the formula requires. You can also use additional
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...
Advanced Data Analysis in Excel 2003
To provide an overview of the advanced data manipulation and analysis features in Excel 2003 End users seeking proficiency in the use of Microsoft Excel 2003 at an advanced level or seeking to obtain Microsoft Office Specialist (MOS) certification in Microsoft Excel 2003 at Expert level or an equivalent
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...
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...
SQL Server 7.0 Data Warehousing SQL Part I
This course is designed to help students gain knowledge of the core components of data warehousing application development tools and SQL management tools. The course introduces basic concepts terminology for understanding SQL Server 7.0 relational databases Structured Query Language and new or improved features. It builds on this foundation to cover client/server web applications programming
more...
Microsoft Excel 2002 Expert User


This course covers skills particular to the expert user of Excel 2002. The course teaches template and database integration, shared workbooks, and consolidating data across workbooks. This course also teaches, Data Analysis and Automation, data importing and querying, pivot tables, macros, and data analysis tools.
more...
From 123-CBT Computer Based Training
Office 2000 - Web Integration

...e.
Add a chart component to a FrontPage Web page.
Add a PivotTable to a FrontPage Web page.
Unit 2: Publishing and Editing Documents
Duration: 2 - 3 Hour(s)
Preview Office documents as Web pages.
Save an Office document as HTML.
Save an Excel document as interactive HTML.
Save an Outlook calendar as Web page.
Publish an Office document to a Web folder.
Publish an Office
more...
Excel 2003 Expert Part 1

This course, along with the Excel 2003 Expert: Part 2 course, maps to the Microsoft Office Expert certification objectives for the Excel 2003 Expert exams. Learners completing these courses should be well prepared for the certification exams, and have a solid foundation in basic Excel skills. Learn To To format a worksheet. To manipulate
more...
From The Virtual Training Company
Microsoft Excel 2000
... allows you to easily analyze data with charts, Microsoft PivotTable, and graphs. You can even use automatic formatting to create data-rich spreadsheets. In this tutorial, you are guided from basic thorough advanced techniques by author Lorie Flenner. She easily explains need-to-know topics such as columns and rows, workbooks and worksheets, basic and advanced formulas, and even how to insert
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...
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...
