Excel 2000 Expert Students will learn how to apply the advanced features of Microsoft Excel 2000 to work with records and ranges; sort, outline, and filter lists; import and export data; use PivotTables, PivotCharts, and data analysis tools; as well as how to merge and link workbooks. more...
Microsoft Excel 2000 Expert User This course provides participants the knowledge to use the advanced features of Microsoft Excel 2000. At the completion of this course, students will learn how to create and use templates; retrieve, sort and manipulate data from a list; create and modify shared workbooks; and analyze data by using Data Map, Pivot Table, Data Table Scenario and Data Analysis tools. more...
Customer Satisfaction Analysis and Implementation What you get out of a well-designed customer satisfaction survey will depend largely on the power of the analytical tools you apply to the data and the effectiveness of actions taken based on the resulting information. Although the analysis itself is best conducted by your statistical team, you'll be able to use survey results more effectively if you understand how key analytical tools are more...
Getting Started with Excel 2002 The Getting Started with Excel 2002 WBT is the first course of the Office XP: Excel 2002 curriculum. This course is designed to provide basic knowledge of Excel 2002. This course provides an overview of the new features of the Office XP suite and Excel 2002. Additionally, the course enables users to identify the components of Excel window and enter data in a worksheet. This course also describes more...
Analyzing Data in Excel 2007 ...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 required results from formulas more...
Data Management and Analysis with Excel 2002 The Data Management and Analysis with Excel 2002 WBT is the second course in the Office XP: Excel 2002 curriculum. This course teaches the user how to effectively manage data in Excel and analyse data based on certain functions. The functions dealt with in this course include mathematical, logical, date and time, text, lookup and reference, financial, and statistical functions. Additionally, the more...
Getting Started With Excel 2003 The Getting Started With Excel 2003WBT is the first course in the Excel 2003 curriculum. It familiarizes the students with the fundamentals of Excel 2003. This course teaches the students how to create and manage workbooks and enter data, and edit data in an Excel workbook. The course also teaches the user to apply various types of formatting and enhancements to data in a worksheet. This course is more...
Managing Worksheets and Customizing Excel 2003 The Managing Worksheets and Customizing Excel 2003 WBT is the second course in the Excel 2003 curriculum. It teaches the students how to effectively manage worksheets and customize them according to needs in Excel 2003. The tasks involved in managing worksheets and customizing them include navigating within worksheets and workbooks, organizing related information in worksheets, using various 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...
Using MS Excel 97 This course covers the basic features of Excel and teaches the student how to effectively perform numeric data analysis, maintaining data, performing complex calculations, and generating charts and reports. 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...
IBM DB2 Univ Database V7 1 Transition Part 1 Core Competencies ... DB2 family. Identify the techniques of multidimensional data analysis. Identify the functions of the star schema model. Identify the new OLAP SQL functions in DB2 version 7.1. Identify the features of declared temporary tables. Identify the factors to consider when using declared temporary tables. Identify the way in which savepoints control the outcome of transactions. Identify the new more...
IBM DB2 Univ Database V7 1 Transition Part 1 Core Competencies ... DB2 family. Identify the techniques of multidimensional data analysis. Identify the functions of the star schema model. Identify the new OLAP SQL functions in DB2 version 7.1. Identify the features of declared temporary tables. Identify the factors to consider when using declared temporary tables. Identify the way in which savepoints control the outcome of transactions. Identify the new more...
Advanced Six Sigma The Measure Analysis Phases of DMAIC ...data collection plan.
Discuss the features of different data analysis tools.
Identify the statistical methods used to analyze a problem area.
Understand the significance of root-cause analysis in identifying real issues.
Audience:
This course is intended for individuals pursuing a Six Sigma Green Belt or Six Sigma team members within organizations that have implemented or plan to more...
Excel 2000 Expert User ...a by using Data Map, Pivot Table, Data Table Scenario and Data Analysis tools. L earn To: Create and use templates. Retrieve, sort and manipulate data from a list. Create and modify shared workbooks. Analyze data by using Data Map, Pivot Table, Data Table Scenario and Data Analysis tools. C ontent Emphasis Skills-Based A udience This course is intended for end more...
Excel XP Expert User ...lidating data across workbooks. This course also teaches, Data Analysis and Automation, data importing and querying, pivot tables, macros, and data analysis tools. Learn To Create a new template file. Modify an existing template file. Create a new workbook by using a user-defined template. Create a shared workbook. Highlight changes in a shared more...
SAP R 3 QM Master Data Analysis The Computer Based Training course (CBT) SAP R/3 QM in Procurement aims to provide all the employees working in the inspections area of your company, who want to learn more about SAP software or who are planning to work with it, with the knowledge to deal with QM within the R/3 System. In the first unit, the trainee will learn how to activate the Quality Management functionality for a material, more...
Six Sigma Black Belt (ASQ) Certificate ...training program integrates online learning with hands-on data analysis. The course material provides an in-depth look at the DMAIC problem-solving methodology, as well as deployment and project-development approaches. The course flow follows the DMAIC methodology, with the appropriate tools and concepts taught at each stage of project deployment. Since software is used for data analysis, the more...
Data Management and Analysis with Excel 2002 ...lly, the course teaches the usage of the Analysis ToolPak Data Analysis tools to perform various calculations in a single step. After completing this course, the student will be able to:
Insert formulas in an Excel worksheet
Define and manage cell and range names
Use array formulas and array constants
Audit formulas
Identify and troubleshoot formula errors
Use selected mathematical more...
CLAIT Level 2 - Spreadsheets, Graph, and Chart Solutions with Excel 2002 This course is designed to help people to obtain the skills and knowledge required for New CLAIT Unit 2 " New CLAIT Unit 9 Graphs and Charts, and CLAIT Plus Unit 10 Spreadsheet Solutions. Readers will learn to use Excel to create worksheets and charts. Readers will learn to create formulas incorporating different functions, create and format charts, and use data analysis tools. Spreadsheets, more...
ECDL Advanced Spreadsheets with Excel 2000 This courses will teach the reader to use the spreadsheet application Microsoft Excel 2000 with a high level of competence. You will be able to create workbooks incorporating custom and conditional formatting, multiple worksheets and advanced formulae and charts. You will also learn to use data analysis and auditing tools, import and export data, use the reviewing tool to collaborate on editing more...