After learning the material in this tutorial, you'll become familiar with the fundamentals of creating precise and professional spreadsheets. You'll learn how to employ menu and toolbar commands, create a worksheet and import and combine data. You'll be able to work with cell ranges, manage rows and columns and implement formulas.

After learning the material in this tutorial, you'll not only be able to create your own spreadsheets, but you'll also know how to enhance the appearance of your data and protect it. This means you'll be able to create formatting effects such as, rotating text, applying frames, borders, and much more. You will be able to lock your workbook file to protect your data and even be able to create charts or maps for a worksheet.

After learning the material in this tutorial, you'll be able to create and work with named ranges, versions, databases or query tables as well as macros. You'll also learn how to embed data and make changes to it. Using 123's Internet tools, you'll be able to create hyperlinks to a Web site, use data from the Internet in your own spreadsheet, and convert a range of data to a Web page.

After learning the material in this tutorial, you will be able to use and work with a variety of formulas and functions ranging from financial to statistical. You will also be familiar with and be able to use Regression, What If tables, and the Backsolver to analyze data.

After learning the material in this tutorial, you ll be able to create charts and maps as visual references for your data that will not only enhance it, but also present it in an easy to understand format. You will also be familiar with and be able to use macros and scripts to make your day-to-day tasks in spreadsheets easier to perform.

After you learn the material in Discover the Internet, you'll be able to use an Internet connection and your computer to access the best of what the Web has to offer. You'll know the history of the Internet and be able to differentiate between the Internet and World Wide Web. You'll be aware of the protocols used on the Internet, be able to use a browser, download, search online or use File Transport Protocol (FTP). Finally, you'll know how to send and receive e-mail.

As an introduction to Excel 2000, this course presents the user with a general overview of the application. Featured in this course are topics including: number formats, workbook and worksheet organization, formulas and printing completed workbooks.

After learning the material in this tutorial, you will be on your way to creating, formatting, and setting up data; whether it's for tracking your company's profits or budgeting household expenses. In addition, you will be able to view and compare data; work with named ranges; and complete routine tasks quickly by using and creating your own templates.

Excel 2000 Advanced allows the user to perform a variety of tasks like outlining and consolidating data; working with lists and databases; importing and exporting data; and using workgroup features to share data.

After learning the material in this tutorial, you will be able to analyze data using a variety of tools such as Goal Seek, Solver, statistical analysis tools, as well as PivotTables and PivotCharts. You will also be able to collaborate and share your Excel data with others by using interactive Web tools and other features.

After learning the material in this tutorial, you'll be able to calculate data using a variety of formulas and functions ranging from basic formulas to financial, logical and statistical functions. You'll also be able to use Excel's auditing tools to track down formula errors and work with data validation.

Excel is a powerful software application that can be used to organize and present your data in a clear, concise manner. In this course, you will learn how to perform basic data analysis, use formulas and functions, and modify worksheets. Finally, we'll cover different options for printing your data, and learn how to post Excel documents on the web.

In this course, you'll learn techniques for increasing your proficiency in using Excel for more complicated operations. You'll learn to add and select a named range, name a single cell, use column and row labels, insert a row, use a named range in a formula, delete a named range, revise a formula, and list named ranges in a workbook. This course will introduce you to templates, teach you how to manage workbooks and folders, plus review workspaces, customize toolbars and menus, and format dates. You will also work with data and lists.

Increase your skills for working with functions and formulas, record and edit macros, assign macros to toolbar buttons and worksheet objects. You will also create charts and graphics.

Whether you are new to Microsoft Excel, need to brush up your skills, or just want to see what's new in the 2003 edition, this tutorial is for you. In this course, you will learn to: build and navigate spreadsheets, work with formulas, format cells and contents, apply styles and templates, set up pages for printing, organize workbooks, and more. Microsoft Excel's most critical features are taught in a simulated environment and reinforced through performance-based practices and testing. Enhance your performance on the job, in the classroom, or at home by brushing up on your Microsoft Excel 2003 fundamental skills. This course has received Microsoft Office Specialist certification. Use the Fundamentals, Intermediate, and Advanced courses to prepare for the Excel Specialist and Excel Expert exams.

This course will enable you to organize, manage, format, and customize data in a worksheet. In this course, you will learn to organize and manage data in a worksheet using ranges, filters, automated tools, and functions. You will also learn to audit and review data. In addition, you will learn to format worksheet components and customize Excel workbooks.

In this course, you will learn to import and export data, structure workbooks using XML, and protect workbooks, worksheets, and cells. You will also learn to apply data validation criteria, conditional formatting, and custom number formats to cells. You will learn to use the Lookup, Reference, and Database functions, the research tool, advanced filters, and macros. You will also learn to create PivotTables and PivotChart reports, share and merge workbooks, manage formulas and scenarios, and modify Excel default settings.

E-Z E-Mail provides instruction on developing e-mail writing skills through an interactive, self-paced learning experience that creates opportunities for business writers to improve their skills and adjust behaviors. E-Z E-Mail is an indispensable learning and reference tool for people seeking to improve their e-mail writing skills.

This title provides you with the knowledge and skills required for installing and configuring different types of input/output devices. You will also learn to diagnose and solve problems associated with these devices. In addition, you will learn about the standard devices used to connect a PC to peripherals and networks. Finally, you will learn about the best practices to keep your computers running satisfactorily and maintaining a high level of customer satisfaction.

This title provides you with the knowledge and skills required for installing and configuring PC modules such as the memory, CPU, motherboard and storage devices. You will also learn to diagnose and solve problems associated with these components. The title includes a section on handling the power supply unit.

Learn about the latest e-mailing features in Outlook 2000 in this tutorial. Creating an AutoSignature, flagging messages and mail attachments are just a few of the many topics presented in this course.

Use this course to learn how to do everything from creating journals in Outlook to sending meeting requests. You'll learn how to do things like organize folders, set reminders, set up NetMeetings, organize your tasks, and track the tasks you've assigned to someone else. In addition, you'll learn about Outlook's security and encryption features, as well as how to add new menu items, add and delete buttons from toolbars, and more.

This course on email using Outlook will teach you to do everything from navigating your way around the window, to color coding and organizing messages, to handling corporate workgroups and creating offline folders. You'll also learn how to work with contacts, use the Auto Signature, format settings and preferences, and a whole lot more. This is the essential course to manage your email, rather than letting your email manage you.

Use this course to learn how to do everything from creating journals in Outlook to sending meeting requests. You'll learn how to do things like organize folders, set reminders, set up NetMeetings, organize your tasks, and track the tasks you've assigned to someone else. In addition, you'll learn about Outlook's security and encryption features, as well as how to add new menu items, add and delete buttons from toolbars, and more.

Email has become a primary means of communication; make sure you are not left out of the communications loop by building your Microsoft Outlook 2003 skills. In this course, you will learn to create email messages, respond to email messages, create instant messages, use personal signatures, flag an important message, and format text. You will also learn to set message options, manage contacts, manage tasks, manage distribution lists, and more. Microsoft Outlook's most critical features are taught using a simulated environment and reinforced through performance-based practices and testing. Start communicating with Microsoft Outlook 2003. This course has received Microsoft Office Specialist certification. Use the Fundamentals, Intermediate, and Advanced courses to prepare for the Outlook Specialist exam.

You can create dynamic presentations using PowerPoint and this tutorial will get you on the right track, providing an introduction to PowerPoint 2000 and its newest features.

After learning the lessons in this tutorial you will be able to use templates and customize PowerPoint for more efficient use. You'll be able to automate and publish presentations for the web. You'll be ready to manage your presentations using a workgroup and create various types of output to prepare you for delivering a presentation.

There are several tools and approaches, which are proven methods to help create eye catching, interesting and informative presentations. In this tutorial, Effective Presentations Using PowerPoint 2000, we ll show you how to use some of these important tools and concepts to help make your next presentation a showstopper. You ll learn how to develop and perfect your own personal style, what equipment is necessary to have and also what other whiz-bang presentation equipment is currently available. Next you ll learn how to jazz up your presentation using sounds, pictures and visual effects!

After learning the lessons in this tutorial you will be able to enhance a presentation using data from other sources and drawing features. You ll be able to use summaries, templates and PowerPoint s enhancing automation features.

Using PowerPoint will help you create effective, interesting, and easy-to-understand presentations. And the fun doesn't stop at your computer! With PowerPoint, you can design presentations for 35-millimeter slides, paper printouts, overhead transparencies, even the Internet! However you decide to use it, PowerPoint includes all the tools you'll need to include text, charts, tables, graphics, music, and animation. In this course, you will cover all the basics, including important changes to this version of the interface, most especially the Task Pane, so you don't want to skip this information.

In this course, you'll delve further into PowerPoint's capabilities. You'll learn to create and import charts and tables, both of which can be crucial to a well-rounded presentation. You will explore some formatting options as well, and spend some time creating custom graphics and designs. Finally, you will learn how to ensure an effective delivery by seeing to every last detail. This course assumes you're already able to navigate through the PowerPoint program, create a presentation using templates and from scratch, use the online Media Gallery to add multimedia clips, and are comfortable with PowerPoint's review and collaboration features.

Make your next PowerPoint presentation a show stopper. In this course, you'll learn how to develop and perfect your own style and jazz up your presentation using sounds, pictures, and visual effects. You ll learn how to ensure your message is effectively received catering to your audience's needs and hold its attention from your first word to your last.

Discover just how easy it is to add some panache to your next presentation with PowerPoint. This course will take you through the basics of creating a PowerPoint presentation from templates; inserting, editing, and formatting text, tables, charts, diagrams, pictures, shapes, graphics, and objects, and more. Microsoft PowerPoint's most critical features are taught using a simulated environment and reinforced through performance-based practices and testing. Give that next presentation an extra boost by brushing up on your Microsoft PowerPoint 2003 fundamental skills. This course has received Microsoft Office Specialist certification. Use the Fundamentals, Intermediate, and Advanced courses to prepare for the PowerPoint Specialist exam.

Learning Windows 2000, Getting Acquainted This tutorial is designed to acquaint an end-user who is new to Windows or Windows 2000 Professional with the environment. It's an ideal course for people who are less confident and proficient at the computer. After learning the material in this course a user will be able to perform typical functions within Windows 2000 with ease. The individual will understand how to use the desktop to maneuver through Windows 2000. They will be able to use the Start menu, open programs and use many of the Accessories, get Help, search for files, and use the Windows Explorer to navigate through their system.

Learning Windows 2000, Desktop Management. This tutorial is designed to help Windows 2000 Professional network administrators get up and going with their network. It's a great follow-up course to Installation & Configuration because both of these courses are especially targeted to the person taking responsibility for the network. This course teaches how to administrate using Windows 2000 Professional without the server. It's ideal for smaller networks. After learning the material in this course the administrator will understand how a network using Windows 2000 Professional is operated using workgroups and the basics of how to go about setting up this network. The administrator will be able to use the Network ID Wizard, add workstations to the network, and make groups. They'll understand how to implement security measures and take advantage of network sharing. They will become familiar with where to access the Administrative tools and how to take advantage of these tools day to day.

Learning Windows 2000, Installation & Configuration This tutorial is designed to teach anyone who would like to create a network using Windows 2000 Professional how to install and configure Windows 2000 Professional for use. People who will benefit from this course include owners of small or home businesses that would like to have a reliable, user-friendly network; or any other user who has reason to set up a network or install Windows 2000 Professional onto a machine. Highlights of this tutorial include teaching how to determine what type of installation to use based on the machine that is being used. The learner will be prepared to make a clean install, an upgrade, a dual-boot installation, and will understand the basics of a installation over a network. The learner will understand how to partition their drives and be able to determine which type of partitioning will work best for them.

Learning Windows 2000, Internet Functionality. This tutorial is designed for any user who is ready to take advantage of the simple Web tools in Windows 2000 and to progress into some of the more advanced tools like software based VPN. After learning the material in this course the user will be able to set up various types of Internet connections such as virtual private networks, dial-up and LAN connections. They'll know how to schedule and broadcast live presentations over the Internet using Windows Media Player. And, users will be able to take advantage of some of the highly praised features of Windows 2000 which include offline web page, offline file and folder viewing.

Learning Windows 2000, Security. This tutorial is designed to teach users how important security measures are on their own workstation and to educate them in ways to use Windows 2000's security features. After learning the information here, someone will be able to create and edit user account information, utilize all sorts of passwords, and understand how to take advantage of access levels. They will know how to set up a shared folder, and provide printer permissions for other users on the network. They'll be familiar with EFS (Encrypting File System) and how to encrypt files or folders as well as be familiar with smart cards and how they are used.

In this tutorial we ll learn how to use a mouse, the Desktop; multi-task; use shortcut menus, the Windows Explorer, and Find. We ll place a program in Startup, add a Folder, Copy files into a folder, learn to Rename a folder or file, and Format a disk. We ll install a printer, use Run, explain Add/Remove Programs, use the Recycle Bin and finally Shut-Down Windows 98.

In this tutorial we will examine the new Active Desktop technology. Including adding, updating, and removing elements to and from the Active Desktop. We'll add a new toolbar and then work with the Windows 98 Explorer. Next, we'll work with hard drive properties. We'll customize Send To, customize our Mouse, and adjust mouse. We'll work with the Taskbar then with Windows 98 multimedia.

In this tutorial, we'll learn about the Desktop, and how to modify it. We'll talk about the menus and modifying them. We'll look at the many faces of folders, customize a folder, discuss file types, and association of files. Then we'll use some of the numerous options for system maintenance. We'll also discuss the control panel and the display properties. Then we'll discuss the Internet Applet, the Keyboard Applet, and the Mouse Applet. Finally, we'll look into the Windows 98 advanced features, like Scripting hosts, support for multiple video cards, and the advanced Dr. Watson utility.

In this tutorial we'll learn where the Internet came from and how it's exploding with growth, then discover how to connect to the Internet. We'll explore the new Active desktop option in Windows 98 and how it brings the Internet and our computer together. We'll add a Web page as a desktop and explore the power of Active Web components. We'll learn about the power of the Internet and the World Wide Web, along with two new features; NetMeeting and NetShow. Finally we use FrontPad to create a Web page then discuss how Windows 98 can turn your PC into a Internet Server.

In this tutorial we'll discuss some of the fundamentals of networking. We'll learn about physical media like cables and network adapter cards. We'll explore the many networking protocols supported by Windows 98 and see how much of the work in using protocols is automated. We'll set up a network and demonstrate just how simple Windows 98 makes the task. We'll learn how to administrate a network using Windows 98 while utilizing the many powerful tools and options available. Finally we'll address the concern of security on a computer network.

This introductory tutorial will teach you the basics of the Windows XP Professional operating system. You'll be introduced to the Windows interface and become familiar with the desktop, Start menu, taskbar, folders, and icons. You'll learn to navigate open windows by scrolling, minimizing, maximizing, and multi-tasking. You'll become familiar with Windows Explorer by finding, opening, saving and deleting files. You'll learn about folders and how to create, rename, move, and delete them.

This tutorial will expand your basic knowledge of Windows XP Professional. You'll learn to customize its interface by working with the desktop, taskbar, Start menu, and My Documents. You'll become familiar with Windows programs by learning their basic components and functionality features. You'll take a look at the Control Panel by changing settings and adding/removing hardware and software.

This tutorial will take a look at more complex features of Windows XP Professional. You'll become familiar with system tools and learn to utilize them to maintain a healthy computer. You'll learn to use mobility tools, like Remote Desktop and Remote Assistance. You'll explore Windows Messenger and learn to communicate using your PC.

In this tutorial you'll learn the fundamental of networking by looking at network architectures, protocols, and topologies. You'll learn about physical media like cables, network interface cards, and hubs. You'll learn how to configure a network by using tools available in Windows XP Professional. You'll become familiar with sharing, securing, and managing resources, as well as maintaining users and groups.

In this tutorial features of Word 2000 are highlighted and timesaving techniques presented focusing on such topics as formatting text, using text effects, page layout and using datasheets.

After learning the material in this tutorial you will be able to create your own desktop publication whether it is a flyer, a card, newsletter, or book. You ll be able to get the most out of templates, use fonts for art, outline, and more!

This course will guide you to schedule meeting requests and manage tasks in Microsoft Outlook 2003. Microsoft Outlook 2003 enables you to send and receive email messages. You can also use Outlook 2003 as a personal organizer to schedule meetings, appointments, and tasks. In this course, you will learn to create and update meeting requests, and set calendar options. You will also learn to create and delegate tasks in Outlook 2003.

In this course, you will learn to customize presentations and collaborate with colleagues on presentations. To make a presentation effective and interesting for the audience, you need to format slides, and apply animation schemes and transition effects to slides. To ensure consistency in presentations, you should know how to apply a design template to slides and customize the master slide. To efficiently collaborate on presentations, you should know how to review, compare, and merge presentations.

In this tutorial we'll learn how to use the address book then create a mail merge document as well as labels and envelopes. We'll also see how to create a table, make abbreviations, and use quick formatting. Then we'll learn how to create a page for the World Wide Web and add hypertext to that page.

After learning the material in this tutorial you'll be able to create and delete columns, add page dividers, page numbers, and hyphenations, print publications and much more. We'll learn how to work with graphics, drawings, saving graphic images, and we'll use TextArt. We'll also learn how to create watermarks, use text boxes, and develop a newsletter.

After learning the material in this tutorial, you'll be able to select the layout of your pages and files, and save time by manipulating reusable blocks of text. You'll be able to undo or redo commands. You'll use WordPerfect template tools and macros when doing repetitive tasks. Lastly, you'll be able to organize an outline, and prepare a table of contents to easily locate information.

Learning WordPerfect 9, Introduction will give you a basic understanding of WordPerfect's word processing capabilities and will be ready to start creating your own documents. You'll be able to use WordPerfect's tools to edit, format and enhance the appearance of your documents, save and check your work for errors and also be able to print what you have created.

In this tutorial we'll focus on time-saving techniques shortcut keyboard functions, the Go To command, as well as the Cut, Copy and Paste commands. We'll also learn about Find and Replace, fast ways to format text, and how WordPerfect checks our documents for spelling and grammar. We'll use shortcut keys to record a macro, discuss the difference between a regular macro and a quick macro, and much more!

After learning the material in this tutorial you'll feel confident around a computer. You will be able to look at a computer, name its pieces, and perform many of the simple tasks the will lead you down the road to being a capable computer user.

In this tutorial, we'll cover the basics of the modems, sound cards, and video cards. We'll give tips for making your own purchases. Then we'll show how to install new hardware.

In this tutorial, we'll cover the basic configuration of a current system and we'll discuss SIMMs, DIMMs, and Cache memory. Then show how to add more memory to our system. We'll discuss Motherboards, Processors (CPU's), and demonstrate how to properly install each. Then we'll discuss the types of mass storage devices. Like IDE (Integrated Drive Electronics), and EIDE (Enhanced Integrated Drive Electronics) Hard Drives. Then we'll discuss Tape Drives, Zip drives, Floppy drives, and the different types of CD-ROMs. Next we'll discuss adding Input/Output devices to our PC.

Internet Explorer 5 not only displays Web pages faster, it's designed to save you time on the things you do most often. It's never been easier to get online, find the information you need, and just do stuff faster.