Microsoft Excel 2000 : Core and Expert Certification

by Rutkosky, Nita Hewitt

• ISBN13: 9780763802363
• ISBN10: 0763802360
• Edition: Spiral
• Format: Hardcover
• Copyright: 1999-08-01
• Publisher: Emc Pub

Table of Contents

Introduction	vi
Excel 2000 Core Level	1	(256)
Microsoft® Excel 2000 Core level MOUS Skills	2	(1)
Preparing and Formatting an Excel Worksheet	3	(54)
Creating a Worksheet	4	(6)
Saving a Workbook	10	(1)
Opening a Workbook	11	(1)
Printing a Workbook	11	(2)
Completing Computer Exercises	13	(2)
Selecting Cells	15	(2)
Applying Formatting with Buttons on the Formatting Toolbar	17	(1)
Previewing a Worksheet	17	(4)
Changing Column Width and Row Height	21	(6)
Formatting Data in Cells	27	(9)
Formatting Cells	36	(8)
Using Help	44	(13)
Chapter Summary	50	(2)
Commands Review	52	(1)
Thinking Offline	52	(2)
Working Hands on	54	(3)
Maintaining and Enhancing a Worksheet	57	(32)
Inserting/Deleting Rows and Columns	57	(4)
Formatting a Worksheet Page	61	(12)
Customizing Print Jobs	73	(2)
Completing a Spelling Check	75	(1)
Finding and Replacing Data in a Worksheet	76	(2)
Sorting Data	78	(11)
Chapter Summary	82	(1)
Commands Review	83	(1)
Thinking Offline	84	(1)
Working Hands-On	85	(4)
Maintaining Workbooks and Creating Web Pages	89	(24)
Maintaining Workbooks	89	(12)
Managing Worksheets	101	(3)
Company Intranets	104	(1)
Sending a Workbook by E-mail	104	(1)
Creating a Web Page	105	(8)
Chapter Summary	108	(2)
Commands Review	110	(1)
Thinking Offline	110	(1)
Working Hands-On	111	(2)
Moving Data Within and between Workbooks	113	(38)
Moving, Copying, and Pasting Cells	113	(3)
Creating a Workbook with Multiple Worksheets	116	(6)
Working with Windows	122	(6)
Formatting with format Painter	128	(1)
Formatting with Styles	129	(5)
Using Excel Templates	134	(17)
Chapter Summary	143	(1)
Commands Review	144	(1)
Thinking Offline	145	(1)
Working Hands-On	146	(5)
Inserting Formulas in a Worksheet	151	(44)
Using the AutoSum Button	152	(1)
Writing Formulas with Mathematical Operators	153	(5)
Inserting a Formula with the Paste Function Button	158	(1)
Writing Formulas with Functions	159	(15)
Working with Ranges	174	(8)
Automatically Outlining a Worksheet	182	(2)
Planning a Worksheet	184	(11)
Chapter Summary	185	(1)
Commands Review	186	(1)
Thinking Offline	187	(1)
Working Hands-On	188	(7)
Creating a Chart in Excel	195	(28)
Creating a Chart	195	(6)
Deleting a Chart	201	(1)
Sizing and Moving a Chart	201	(1)
Changing the Chart Type	202	(4)
Changing Data in Cells	206	(1)
Changing the Data Series	207	(2)
Adding Chart Elements	209	(5)
Formatting Chart Elements	214	(9)
Chapter Summary	218	(1)
Commands Review	219	(1)
Thinking Offline	219	(1)
Working Hands-On	220	(3)
Integrated Topic: Inserting Clip Art Images and Creating Maps	223	(34)
Adding Clip Art to Worksheets	223	(9)
Displaying Data in a Map	232	(15)
Drawing Lines and Objects	247	(3)
Changing Objects	250	(7)
Chapter Summary	251	(1)
Commands Review	252	(1)
Thinking Offline	252	(1)
Working hands-On	253	(4)
Excel 2000 Core Level Performance Assessments	257	(8)
Assessing Core Proficiencies	257	(5)
Writing Activities	262	(2)
Internet Activity	264	(1)
Excel Core Index	265
Excel 2000 Expert Level	1	(300)
Microsoft® Excel 2000 Expert Level MOUS Skills	2	(1)
Formatting Excel Worksheets using Advanced Formatting Techniques	3	(40)
Applying Number Formats	4	(1)
Creating Custom Formats	5	(3)
Formatting Large Labels	8	(1)
Automatically Adjusting Column Widths and Row Heights	9	(3)
Creating, Applying, and Editing Styles	12	(1)
Using the Format Painter Button	13	(1)
Applying Borders and Shading	14	(2)
Turning off Zeros	16	(4)
Using AutoFormat	20	(1)
Using conditional Formatting	21	(2)
Adjusting the Layout of a Worksheet	23	(4)
Using the paste Special Command	27	(1)
Hiding and Unhiding Rows, Columns, and Sheets	28	(3)
Using the Page Break Preview Command	31	(1)
Changing Page Order	32	(1)
Renaming Sheets	32	(11)
Chapter Summary	36	(1)
Commands Review	37	(1)
Thinking Offline	38	(1)
Working Hands-On	39	(4)
Working with Templates and Workbooks	43	(42)
Using Excel Templates	44	(5)
Creating a New Template	49	(2)
Editing a Template	51	(3)
Automating Data Collection with a Built-in Template	54	(4)
Using Multiple Workbooks	58	(2)
Consolidating Data from Several Worksheets into a list	60	(2)
Linking Workbooks	62	(5)
Sharing Workbooks	67	(18)
Chapter Summary	74	(1)
Commands Review	75	(1)
Thinking Offline	76	(1)
Working Hands-On	77	(8)
Using Advanced Functions	85	(32)
Entering a Function	86	(2)
Financial Functions	88	(4)
Math and Trig Functions	92	(3)
Statistical Functions	95	(4)
Lookup and Reference Functions	99	(3)
Logical Functions	102	(2)
Using Array Formulas	104	(13)
Chapter Summary	109	(1)
Commands Review	110	(1)
Thinking Offline	110	(1)
Working Hands-On	111	(6)
Working with Lists	117	(44)
Creating a List	118	(1)
Entering Data Using the Data Form	119	(2)
Using Data Validation	121	(6)
Sorting a List	127	(4)
Modifying Records	131	(4)
Outlining a Worksheet	135	(4)
Subtotaling a List	139	(4)
Filtering a List	143	(4)
Filtering a List Using Advanced Filters	147	(14)
Chapter Summary	153	(1)
Commands Review	154	(1)
Thinking Offline	154	(1)
Working Hands-On	155	(6)
Using Excel's Analysis Tools	161	(48)
Introduction to PivotTables	161	(20)
Creating PivotChart Reports	181	(8)
Creating Interactive PivotTables for the Web	189	(4)
Analyzing Data Using Goal Seek	193	(2)
Analyzing Data Using Solver	195	(4)
Creating Scenarios	199	(10)
Chapter Summary	202	(1)
Commands Review	203	(1)
Thinking Offline	204	(1)
Working Hands-On	205	(4)
Managing and Auditing Worksheets	209	(28)
Introduction to Macros	210	(12)
Working with Toolbars	222	(6)
Auditing Workbooks	228	(9)
Chapter Summary	232	(1)
Commands Review	233	(1)
Thinking Offline	233	(1)
Working Hands-On	234	(3)
Collaborating with Workgroups	237	(32)
Benefits and Limitations of Sharing Workbooks	238	(1)
Changing Workbook Properties	238	(2)
Protecting Workbooks	240	(8)
Tracking Changes	248	(10)
Working with Multiple Workhseets	258	(1)
Using the Report Manager	259	(10)
Chapter Summary	262	(1)
Commands Review	263	(1)
Thinking Offline	264	(1)
Working Hands-On	265	(4)
Integrated Topic: Importing and Exporting Data	269	(32)
Importing from and Exporting to Text files	270	(6)
Accessing and Placing Data on the Web	276	(7)
Importing Data from a Web Page into Excel	283	(3)
Using a Microsoft Query	286	(3)
Linking and Embedding Objects	289	(12)
Chapter Summary	294	(1)
Commands Review	295	(1)
Thinking Offline	295	(1)
Working Hands-On	296	(5)
Excel 2000 Expert Level Performance Assessments	301	(20)
Assessing Expert Proficiencies	301	(11)
Writing Activities	312	(4)
Internet Activity	316	(5)
Excel Expert Index	321