Data Management in Excel 2000

Training Provided by Teach Me IT The Data Management in Excel 2000 WBT is the second course in the Excel 2000 curriculum. It teaches the students how to effectively work with and manage data in Excel 2000. The tasks involved in working and managing data include formatting data, performing calculations, using functions to perform calculations, and sorting, summarizing, and analyzing data using Excel. After completing this course, the student will be able to:

Format cells in a worksheet
Format data in a worksheet
Format data with styles
Perform simple calculations on data
Write custom formulas
Use financial functions to perform calculations
Use date and time functions to perform calculations
Perform advanced calculations using logical functions
Use Lookup functions to perform calculations
Sort and filter lists
Use the Query Wizard to extract data
Summarize details stored in Excel worksheets
Audit Excel workbooks
Use goal seek to make decisions
Create and compare scenarios
Create custom reports

Data Management in Excel 2000

Other Courses in the Curriculum  Getting Started with Excel 2000  Advanced Tools of Excel 2000 Course Name Data Management in Excel 2000 Audience End users who are familiar with the GUI environment and need to use numeric data for performing mathematical calculations and data analysis.  Course Requirements You need Microsoft Internet Explorer 5.0 or above OR Netscape Navigator/Communicator 4.78 or above. Plug-in Requirements  ØMacromedia Shockwave plug-in for Windows for IE/NN  ØMacromedia Flash plug-in for Windows for IE/NN Note: Macromedia Flash plug-in comes built in with IE 5.5 and above and NN 6.x. To download the plug-ins, click on the relevant icon below.   Pre-requisites The user should be familiar with Microsoft Office products and Windows 95/98 operating systems and be able to work in GUI environments. The student should also possess a basic knowledge of Excel 2000, and should be able to create basic Excel workbooks.  Course Duration 4.2  hours Course Objectives The Data Management in Excel 2000 WBT is the second course in the Excel 2000 curriculum. It teaches the students how to effectively work with and manage data in Excel 2000. The tasks involved in working and managing data include formatting data, performing calculations, using functions to perform calculations, and sorting, summarizing, and analyzing data using Excel. After completing this course, the student will be able to: Format cells in a worksheet Format data in a worksheet Format data with styles Perform simple calculations on data Write custom formulas Use financial functions to perform calculations Use date and time functions to perform calculations Perform advanced calculations using logical functions Use Lookup functions to perform calculations Sort and filter lists Use the Query Wizard to extract data Summarize details stored in Excel worksheets Audit Excel workbooks Use goal seek to make decisions Create and compare scenarios Create custom reports   Course Outline Data Formatting Basic Data Formatting Advanced Data Formatting Quiz Formulas and Functions Working with Formulas Basic Excel Functions Advanced Excel Functions Quiz Data Management Sorting Data Summarizing Data Quiz Data Analysis Auditing Data Working with Scenarios and Reports Quiz

About The Training Provider: Teach Me IT

More Excel 2000 Training from Teach Me IT

• Advanced Tools of Excel 2000
• Getting Started with Excel 2000