|
Testing
All testing will be completed
online, you will need an internet connection for this.
Outcome of this course: Students learn to design, create, edit and
enhance Excel 2000 documents, as well as how to create tables, format
pages, insert graphics and much more. This course also prepares student
for Microsoft Office Specialist Core Test.
Student will take an online test of each chapter.
There will be 2 hands on application tests at certain points in your
lesson book.
Prerequisite: Minimal knowledge of Microsoft 98 or 2000.
Systems Requirements
Excel 2000 on your Computer
Student will also be able to interact with a live instructor online at
set times.
You will be able to type chat or voice chat.
When satisfactorily completed with the course you will receive a
certificate of satisfactory completion.
Tuition is $149.95, Text Book $40.95 + Shipping
TABLE OF
CONTENTS
v What's New in Excel 2000
v Start-Up Checklist
vi Preface
viii How to Use This Book
GETTING STARTED WITH EXCEL
2 Starting Excel
2 Identifying the Parts of the Excel Screen
4 Exiting from Excel
5 Working with Menus and Dialog Boxes
8 Customizing Excel
13 Getting Help with Excel
19 Using the Internet and the World Wide Web
20 Managing Documents and Files
26 Summary
LESSON 1
UNDERSTANDING WORKBOOK BASIC
30 Workbook and Worksheet Basics 42 Using Undo and Redo
35 Selecting Cells
37 Entering Data
43 Summary
LESSON 2
USING FORMULAS AND FUNCTIONS
46 Entering Formulas
49 Copying Formulas and Understanding Cell References in Formulas
51 Editing Formulas
52 Using Functions
53 Naming Ranges
56 Using Comparison Operators
56 Displaying Formulas
57 Summary
LESSON 3
CREATING, PRINTING, AND DISTRIBUTING WORKSHEETS
61 Creating a New Worksheet
65 Using AutoCorrect
66 Checking Spelling
67 Making Printing Easy
75 Using Web Features
80 Sending Documents Electronically
82 Summary
LESSON 4
FORMATTING AND EDITING THE WORKSHEET
87 Adjusting Column Width and Row Height and Columns
89 Formatting a Worksheet
95 Using Conditional Formatting
96 Copying Formats
96 Using Styles
98 Inserting and Deleting Cells, Rows,
100 Finding and Replacing Data
102 Copying and Moving Data
106 Summary
LESSON 5
USING EXCEL'S WORKBOOK FEATURES
110 Understanding Workbooks
111Grouping Worksheets
112 Inserting and Deleting Sheets
112 Moving and Copying Sheets
114 Consolidating Data
117 Using Windows Features to Change the Display
122 Saving a Workspace
123 Summary
LESSON 6
WORKING WITH CHARTS
127 Identifying Parts of a Chart
127 Creating Charts
132 Sizing, Moving, and Deleting Charts
133 Formatting the Chart
134 Changing Chart Values and Text
136 Enhancing a Chart with Graphics
138 Saving and Printing Workbooks with Charts
139 Summary
LESSON 7
AUTOMATING, PROTECTING, AND ENHANCING WORK
143 Recording and Running a Macro
145 Finding Cells with Special Types of Contents
146 Using the Validation Command154 Using Templates
147 Protecting Data
151 Sharing Workbooks
152 Inserting Comments on a Worksheet
153 Inserting a Hyperlink to another Workbook
155 Summary
LESSON 8
WORKING WITH DATA BASE FEATURES
159 Understanding Databases
160 Designing a List
161 Using a Data Formula With Your List
164 Sorting Data
165 Filtering Records
170 Summarizing Data in a List
172 Creating a Pivot Table
174 Summary
LESSON 9
EXPLORING EXCEL'S DATA ANALYSIS AND OTHER TOOLS
178 Creating a Worksheet Outline
180 Using Goal Seek
181 Using a Data Table
183 Using Scenarios
185 Using Solver
187 Converting Text to Columns
188 Using the Auditing Feature
189 Summary
181 Glossary
183 Index |