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 worksheet basics.
Prerequisites
To ensure students’ success with this course, we recommend that they first take the following Content's course or have equivalent knowledge.
Target Student
Students enrolling in this course should understand how to use Windows 95.
Performance-Based Objectives
- Understand 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.
Delivery Method
Instructor-led, group-paced, classroom-delivery learning model with structured, hands-on activities.
Course duration
0.5 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
Appendix A: Working with HTML worksheets
- Saving and Opening Excel HTML FilesTopic
Hardware/software Requirements
You will need:
- a minimum of 8 megabytes (MB) of Random Access Memory (RAM).
- a minimum of 41 MB of hard disk space available for Excel, after Windows 95
is installed.
- a 386 DX or higher processor; 486 is recommended.
- a typical installation of Windows 95 with Excel version 97 from Microsoft
Office 97 for Windows 95.
