Online Formulas eLearning Training

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 Level 1 This course familiarizes students with the basic features of Microsoft Excel 2000. Selected topics include understanding formulas and functions, working with columns and rows, using absolute references, and printing worksheets. 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...

Excel 2000 Proficient 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 learn how to save and work with files as Web pages. more...

Excel 2002 This course introduces students to basic spreadsheet features and acquaints them with the tools used in Microsoft Excel 2002. As the course becomes more advanced, students will learn how to customize workbooks by changing worksheet attributes, use lists to store and organize data, use functions in financial and logical formulas, and format worksheets using AutoFormat and predefined styles. more...

Excel 2002 MOUS This comprehensive course teaches students the basic and intermediate features of Excel 2002 so they can easily create and modify spreadsheets. Some skills users will acquire include learning to manage workbooks, working with cells and cell data, formatting and printing worksheets, creating and revising formulas, creating charts from worksheet data, learning about objects and their roles in more...

Microsoft Excel 2002 Level 1 This course introduces students to basic spreadsheet features and acquaints students with Microsoft Excel 2002 tools. Students will become familiar with Excel`s introductory-level new features, such as smart tags and speech recognition, as well as workbooks, cells, worksheets, and formulas. more...

Microsoft Excel 2002 Level 2 This course introduces students to an additional set of basic spreadsheet features and acquaints students with the tools used in Microsoft Excel 2002. Some skills taught are customizing workbooks by changing worksheet attributes, using lists to store and organize worksheet data, using functions in financial and logical formulas, and formatting worksheets using AutoFormat and predefined styles. more...

INDIVIDUAL Training for Lotus 1-2-3 Millennium This course presents the basic concepts for Lotus 1-2-3: Millennium Edition. This course also has an optional Skill Assessment mastery test that measures the participant's skill level. more...

Microsoft Excel for Windows 95 Advanced Topics This multimedia self-paced learning course will instruct you on working with the advanced skills of Excel 95 necessary to maximize your productivity. The unique Skill Builder instruction uses text, voice, questioning, practice, quizzes and multiple study paths to create a learning environment that enhances your enjoyment and comprehension. Mastery tests at the end of each unit allow you to verify more...

Microsoft Excel 2000 Fundamentals This course provides participants with the fundamental skills to use Microsoft Excel 2000 on a daily basis in their workplace. At the completion of this course, students will learn how to create and save a new workbook; add and manipulate worksheets; enter and manipulate data in single and multiple cells; use formulas and functions; format workbooks, worksheets and cells; and change fonts and data more...

Microsoft Excel 2000 Proficient User This course provides participants with the skills to use Microsoft Excel 2000 on a daily basis in their workplace. At the completion of this course, students will learn how to format and print data in a worksheet; make worksheet calculations by using the advanced formulas and functions provided by Excel; manipulate data in a worksheet; create and edit workbooks for integrating with Web technology; more...

Microsoft Excel 2000 Basic ...edit, and format worksheets, and how to work with charts, formulas, and functions. 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 after course completion. Related Exam: MOUS Excel 2000 Expert. This course is designed to help more...

Microsoft Excel 97 Basic This highly interactive CBT contains five units that cover basic Excel skills. Through step-by-step instruction within a realistic simulation of Microsoft Excel 97, students learn how to build, edit, format, and manage worksheet and charts. 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 more...

Microsoft Excel 97 Intermediate ...on of Microsoft Excel 97, students learn how to work with formulas and functions, 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 each learner covering only the topics not yet mastered. A searchable index and online glossary make the CBT a great reference more...

Microsoft Office 2000 - Advanced Excel To bring proficient users of Excel 2000 to an advanced level of competence End-users seeking proficiency in the use of Microsoft Excel 2000 at an advanced level; end-users seeking to obtain Microsoft Office Specialist (MOS) certification in Microsoft Excel 2000 at Expert level more...

Troubleshooting and Closing the Project ...nt. Conducting meetings and using advanced tools, such as formulas and graphs, allow the project manager to properly define the health or status of the project. This course outlines how to conduct effective meetings and presents some troubleshooting tools that can be used during the project life cycle. It also presents the information required to close the project, which is the last stage in more...

Strategies for Facilitating Critical Thinking ...longer thrive on the unexamined repetition of established formulas. Today, people at all levels of the organization are asked to think in new ways about themselves, their work, and their organizations. In this course, managers can learn a variety of strategies to encourage the development of critical thinking skills within their organizations, for both individuals and teams, and to ensure that more...

Inventory Management In today's economy, companies must be able to move large quantities of product quickly to locations across the globe. Overnight delivery methods have drastically altered customers' expectations regarding delivery times. Lead times of four to six weeks are no longer acceptable. In light of these changes, effective Inventory Management is no longer static- the emphasis is on movement, and quick more...

VoIP Network Engineering Management and Support ...ples. We review the Erlang and Poisson traffic estimation formulas. We learn the steps necessary to plan, design, and engineer a converged network. We discover methods we can use to measure the converged network s voice quality, and how we can determine the effects the final network design has on overall network performance. We review network security issues and threats, and discuss means we more...

Traffic Engineering This WestNet e-Learning module discusses traffic engineering concepts, traffic data sources, and busy-hour engineering. more...

Managing Data using Works 6 0 The Managing Data using Works 6.0 course is the first course in the Works Suite 2002 curriculum. This course acquaints the users with the applications of the Works Suite and the different components of the Works application. It teaches the users to use the Task Launcher to start various tasks in Works and complete them using different wizards and templates. Additionally, it explains the different more...

Microsoft Works Suite 2005 - Creating Spreadsheets This course will cover the basics of Works Spreadsheet including spreadsheet essentials such as the interface, templates, and Help options. It will also include working with formulas and functions in a spreadsheet as well as how to perform common tasks such as copying, pasting, and printing. A home computer user with basic to intermediate skills and wants to use a personal computer competently and more...

Microsoft Excel 2002 Training Excel 2002 Core Training will provide the learner with the core skills necessary to efficiently use Excel 2002, Microsoft's popular spreadsheet program. It is also excellent preparation for the Microsoft Office User Specialist (MOUS) certification exam. Designed for learners who currently use or are beginning to use Microsoft Excel 2002 more...

Optimizing Excel 2002 To provide an overview of the calculation, chart-creation, and web-enabled features in Excel 2002 Personnel at all levels of the enterprise; end-users seeking competency in the use of Microsoft Excel more...

Analyzing Data in Excel 2007 ... and Solver enables you to retrieve required results from formulas by determining the data the formula requires. You can also use additional what-if analysis components, data tables and scenarios, to view how value changes in formulas affect the formula results and to forecast worksheet outcome models respectively. This course covers advanced data analysis features, such as PivotTable and more...

Excel 2003 Formulas and Functions To provide an overview of the calculation features in Excel 2003 Personnel at all levels of the enterprise; end-users seeking competency in the use of Microsoft Excel; end-users seeking to obtain Microsoft Office Specialist (MOS) certification at core level in the use of Microsoft Excel 2003; end-users seeking basic IT certification such as ECDL, ICDL, IC3, or an equivalent 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...

ECDL ICDL 4 Module 4 Spreadsheets - Formulas and Functions in Excel 2003 ...formulas and functions in Excel 2003. Note: the exercise items included with this ECDL-approved training are not ECDL certification tests. See www.ecdl.com for further details. End users wanting to attain competency in using a spreadsheet application; end users wanting to attain competency in using Microsoft Excel 2003; end users wanting to attain an ECDL or ICDL certification or equivalent; more...

Microsoft Works Suite 2004 - Creating Spreadsheets This course will cover basics of a Works Spreadsheet including spreadsheet essentials such as interface templates and Help options. It will also include working with formulas and functions in a spreadsheet as well as how to perform common tasks such as copying pasting and printing.  more...

WordPerfect Office 12 - Quattro Pro This course will enable learners to understand and use Quattro Pro to perform simple tasks such as opening existing notebooks creating new notebooks saving notebooks and formatting data. This course will also equip learners to insert charts in their notebooks use formulas and functions and set printing options.  more...

Microsoft Excel 2002 Fundamentals This course presents learners with the fundamental elements of Excel 2002. The course covers the Excel interface and navigation, how to create and format worksheets. Topics such as creating formulas, copying, inserting and deleting a range of cells are covered in the course. more...

Microsoft Excel 2002 Fundamentals This course presents learners with the fundamental elements of Excel 2002. The course covers the Excel interface and navigation how to create and format worksheets. Topics such as creating formulas copying inserting and deleting a range of cells are covered in the course.  more...

Crystal Reports 8.5: Introductory Report Design Part 2 This is the second course in a two part series that builds on the information taught in the first course Crystal Reports 8.5: Introductory Report Design Part 1 (13889). Learners will be working with formulas linking reports working with Cross-tabs formatting sections creating charts and creating geographical maps. After completing this course learners will be able to use some of the advanced more...

Lotus Domino R5 Development Part 4: Making Your Application Run This is the fourth course in a nine part series for webmasters application developers and graphic designers that will introduce Notes/Domino features web-specific tasks and basic system administration tasks to be up on the web quickly and to use Domino to create Web sites and Web applications. At the completion of this course students will learn how to identify the object-oriented hierarchy for more...

Data Management in MS Excel 2000 This course is the second course in a series of three in the Excel 2000 curriculum. This course 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. more...

MS Access 95 In this course, students will learn to use the various features of Microsoft Office and Microsoft Access (version. 7.0) for Windows 95. The focus is on the creation of a database for a retail store which includes creating and using tables, formulas, forms, OLE objects, and reports. more...

MS Excel 95 In this course, students will learn to use the various features of Microsoft Office and Microsoft Excel (version. 7.0) for Windows 95. The focus is on the creation of a home budget which includes advanced formatting, formulas, linked worksheets, OLE objects, and charts. more...

MS Excel 97 This course is easy to use whether you are a new or experienced user. Effectiveness is our number-one priority in developing our tutorials. Instructions are presented in easy to understand graphical formats instead of just on screen text; applications simulations offer realistic practice opportunities; and interactive exercises keep people engaged throughout the lesson. more...

Microsoft Excel 97 Training Excel 97 Training will provide the learner with fundamental skills and advanced techniques needed for Excel 97, Microsoft's premiere spreadsheet program. It is also excellent preparation for the Microsoft Office User Specialist (MOUS) certification exam. more...