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. more...
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...
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. 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. more...
Advanced Features of Outlook 2002 The Using Advanced Features of Outlook 2002 WBT is the second course of the Office XP: Outlook 2002 curriculum. It provides users with an in depth knowledge of customizing the Outlook 2002 interface and its various features based on individual requirements. It also provides students hands on training about the concepts and processes involved in using MS Outlook 2002 with the Exchange server and more...
Advanced Features of MS Project 2000 This is the second course in the Project 2000 curriculum. It acquaints the students with the advanced capabilities of Project 2000. It enables students to plan, create and assign tasks and resources. It also enables students to manage and generate project reports, and access risks. Additionally, it enables students to use Project Central 2000 for communicating information and managing the Projectmore...
MS SQL Server 2000: Design and Implementation Part 5: Distributed Data and Locks This is the final course in a five part series that teaches how to manage SQL Server 2000 transactions and locks. This course will cover how to import and export data, and how to transform data with DTS. Additionally, users will learn how to manage distributed queries and linked servers, create transactions, manage locks, and how to troubleshoot transactions and locking. more...
MS SQL Server 2000: Design and Implementation Part 5: Distributed Data and Locks This is the final course in a five part series that teaches how to manage SQL Server 2000 transactions and locks. This course will cover how to import and export data and how to transform data with DTS. Additionally users will learn how to manage distributed queries and linked servers create transactions manage locks and how to troubleshoot transactions and locking. more...
SQL Server 2000 Design Implement Databases Part 5 Dist Data Locks ...tions and locks. This course will cover how to import and export data, and how to transform data with DTS. Additionally, users will learn how to manage distributed queries and linked servers, create transactions, manage locks, and how to troubleshoot transactions and locking. Learn To: o Identify guidelines for importing and exporting data. o Match SQL Server 2000 tools used to import and more...
Excel 2000 Proficient User ...from an HTML file. Import data from other applications. Export data to other application. Match the different methods of consolidating data with their uses. Create validation criteria for entering data in a cell range by using a list. Create a message to prompt the user to enter valid data in the cell range of a worksheet. Create an error message to be displayed when incorrect data is more...
Excel 2003 Expert Part 1 ... To import data to Excel. To export data from Excel. To group, outline, and consolidate data from two or more worksheets in Excel. Audience The target audience will range from new users to power users. It is expected that the vast majority of learners will have at least had some exposure to previous versions of Excel. Fundamental PC more...
Advanced Features of Project 2000 ...ject to Import data
Import data from other applications
Export data from Project to other applications
Link and embed Project data
Customize Project 2000
Customize toolbars and menu bar
Create macros in Project 2000
Customize fields and create custom forms
Describe Project Central
List the use of the feature of Project Central
Work with tasks in Project Central
Create and send status more...
Advanced Features of Outlook 2002 ...nd customize existing views
Create new views
Import and export data from Outlook
Specify different printing options
Use Outlook with other Office applications
Use Outlook to access the Internet
Use Outlook templates
Create forms in Outlook
Create public folders and provide access to them
Share public and personal folders
Create shared outlook items and Office files
Configure Outlook more...
Introducing Office XP ...nd customize existing views
Create new views
Import and export data from Outlook
Specify different printing options
Use Outlook with other Office applications
Use Outlook to access the Internet
Use Outlook templates
Create forms in Outlook
Create public folders and provide access to them
Share public and personal folders
Create shared outlook items and Office files
Configure Outlook more...
Lotus Notes 4.6 Advanced User This course is an advanced presentation of some of the more technical user features of Lotus Notes. Users who appreciate a challenging experience will enjoy venturing into Notes database design and automation features. Readers will learn to use and create queries, full text indexes, agents and SmartIcons. To import & export data, link & embed objects and write basic formulas, plus understand more...
Lotus Notes 4.5 Advanced User This course is an advanced presentation of some of the more technical user features of Lotus Notes. Users who appreciate a challenging experience will enjoy venturing into Notes database design and automation features. Readers will learn to use and create queries, full text indexes, agents and SmartIcons. To import & export data, link & embed objects and write basic formulas, plus understand more...
Microsoft Access 2003 Intermediate This course is designed to help you to obtain the skills required to create a relational database. You will learn relational database concepts and practice and understand the importance of documenting and maintaining database files. You will learn to customise forms, reports, and Data Access Pages in design view. Finally, you will be able to calculate and summarise data and import and export data more...
Microsoft Excel 2002 (XP) Advanced This course will give readers the ability to create advanced spreadsheets using the full range of Microsoft Excel 2002's tools and features. Readers will learn to apply custom formatting and use templates; to import and export data in different formats; to use LOOKUP functions; and to create customized charts. Readers will also learn how to customize and automate Excel using macros and toolbars. more...
Microsoft Excel 2002 (XP) Advanced This course will give readers the ability to create advanced spreadsheets using the full range of Microsoft Excel 2002's tools and features. Readers will learn to apply custom formatting and use templates; to import and export data in different formats; to use LOOKUP functions; and to create customized charts. Readers will also learn how to customize and automate Excel using macros and toolbars. 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...