Excel 2000: Advanced (Windows)

This course is provided by Wintrac. Wintrac provides one stop shopping for all your IT training needs. Wintrac’s course catalog of over two thousand courses includes courses on Desktop Application Software training, E-Mail/Groupware training, Office Suite training, Operating Systems training, Presentations training, Spreadsheets training, Web Browsers training and Word Processing training

Overview

Students will learn various advanced techniques for analyzing and manipulating data in Excel.

Prerequisites

Windows 98: Introduction and Excel 2000: Worksheets, or equivalent knowledge.

Target Student

Students enrolling in this course should understand basic concepts involved in using Excel 2000. For example, they should be familiar with data types (text and values), copying data, basic formulas and functions, and opening and saving files. Performance-Based Objectives

Identify the disadvantages of paper spreadsheets and the advantages of electronic spreadsheets by exploring both.
Create a basic worksheet by entering text, values, and formulas.
Create formulas by using Excel’s built-in functions.
Move and copy data by using shortcut menus, drag-and-drop editing, and toolbar buttons.
Change the appearance of worksheet data by using a variety of formatting techniques.
Prepare a document for printing by using the spell checking feature and a variety of printing options.
Use the three-dimensional aspect of the Excel workbook environment by creating formulas that refer to cells on multiple worksheets.
Save Excel workbooks and selected data as Web pages.

What's next

Excel 2000: Advanced is the last course in this series

Delivery Method

Instructor-led, group-paced, classroom-delivery learning model with structured, hands-on activities.

Certification

Excel 2000: Worksheets is one of a series of courseware titles that addresses Microsoft Office Specialist (Office Specialist) skill sets. The Office Specialist program is for individuals who use Microsoft's business desktop software and who seek recognition for their expertise with specific Microsoft products. Certification candidates must pass one or more product proficiency exams in order to earn Office Specialist certification.

Benefits

Students will learn how to work with advanced features of Excel 2000.

Course duration

1 Day(s) Course outline

Lesson 1: Customizing the work area

Working with built-in toolbars
Using custom toolbars
Creating and using styles
Using templates

Lesson 2: Advanced formula construction

Using names
Using the IF function
Using the VLOOKUP function
Using IS functions and the Auditing features

Lesson 3: Using pivot tables

Creating pivot tables
Modifying pivot tables
Grouping and summarizing data in a pivot table

Lesson 4: Working with multiple worksheets

Working with workbooks
Linking cells in different workbooks
Workbook versus links and workspaces

Lesson 5: Consolidating and analyzing data

Consolidating data from more than one worksheet
Using the Goal Seek and Solver utilities
Using Scenario Manager to view a worksheet with different input values

Lesson 6: Using protection and display options

Using comments
Protecting workbooks
Using custom views

Lesson 7: Introduction to macros

Running macros
Recording a macro
Viewing and editing VBA code

Lesson 8: Working with interactive Excel Web documents

Saving Excel worksheets as Web documents
Spreadsheet Web Components

Hardware/software Requirements

You will need 32 megabytes (MB) of Random Access Memory (RAM) if you are using a Pentium 90 or greater processor. You will also need 500 MB of free hard-disk space, a local CD-ROM drive or access to a networked CD-ROM drive, a VGA or higher display adapter, Microsoft Windows 95 or later, and Microsoft Office 2000.

In addition, you will need printers if you want to print the reports created in the course. Otherwise, printers are not required; however, each PC must have an installed printer driver in order to use Print Preview.

Please contact your training representative for more details on having this course delivered onsite or online

Training Outlines - the one stop shopping center for IT training.
© Training Outlines All rights reserved