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
Welcome to Excel 2000: Worksheets, a hands-on instruction book that will introduce you to worksheet basics.
Prerequisites
Excel 2000: Worksheets is designed for the student who has had no previous spreadsheet experience. Students who are not familiar with the Windows environment will probably want to first take the following Content course:
Target Student
Students enrolling in this course should understand how to use Windows 98.
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: Worksheets is the first course in this series. Excel 2000: Charting and Organizing Data, the next course in this series, teaches students how to use the charting and list management capabilities in Excel. Students who want to learn advanced features can take Excel 2000: Advanced.
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 use an electronic spreadsheet to create basic data reports.
Course duration
1 Day(s)
Course outline
Lesson 1: Excel Basics
- Topic 1A: The Paper Spreadsheet
- Topic 1B: The Excel Program
- Topic 1C: The Workbook Environment
Lesson 2: Entering Data and Navigating in a Worksheet
- Topic 2A: Entering and Correcting Data
- Topic 2B: Saving a File
- Topic 2C: Using Formulas
- Topic 2D: Opening a Second File
- Topic 2E: Navigation and Movement Techniques
Lesson 3: Modifying a Workbook
- Topic 3A: Working with Ranges
- Topic 3B: Working with Functions
- Topic 3C: Editing Cell Contents
Lesson 4: Moving and Copying Data
- Topic 4A: Inserting Rows and Ranges
- Topic 4B: Moving Data
- Topic 4C: Copying Data
- Topic 4D: Absolute References
- Topic 4E: Using the Fill Series Feature
Lesson 5: Formatting a Worksheet
- Topic 5A: Formatting a Worksheet
- Topic 5B: Number Formats and Text Alignment
- Topic 5C: Copying and Pasting Formats
- Topic 5D: Special and Custom Formatting
Lesson 6: Printing a Worksheet
- Topic 6A: Checking Spelling
- Topic 6B: Using the Print Preview Command
- Topic 6C: Printing a Large Worksheet
- Topic 6D: Additional Print Options
Lesson 7: Introduction to the Workbook Environment
- Topic 7A: Using a Multiple-sheet Workbook
- Topic 7B: Creating a Chart
- Topic 7C: Outlining
- Topic 7D: Spreadsheet Solutions
Lesson 8: Creating Excel Web Pages
- Topic 8A: Using Excel as a Web Tool
- Topic 8B: Other Web Options
Hardware/software Requirements
You will need:
- A minimum of 32 megabytes (MB) of Random Access Memory (RAM).
- A minimum of 500 MB of available hard-disk space for Office
2000, after Windows 98 is installed.
- A Pentium 90 or higher processor.
- A typical installation of Windows 98.
- A full-suite installation of Microsoft Office 2000 for Windows
98.
- Though printers are not required, you’ll need an installed
printer driver.
