Microsoft Excel 2002: Simply Visual

• ISBN13: 9780782140064
• ISBN10: 0782140068
• Format: Paperback
• Copyright: 2001-06-01
• Publisher: John Wiley & Sons Inc

Summary

Demonstrates Microsoft Excel 2002's updated features while reviewing such Excel basics as calculating formulas and functions, analyzing data, customizing worksheets, and sharing data.

Table of Contents

Introduction	xiii
Getting Started with Excel	1	(24)
Starting Excel	2	(1)
Viewing the Excel Window	3	(2)
Starting a New Workbook	5	(1)
Opening an Existing Workbook	6	(3)
Navigating a Worksheet	9	(2)
Choosing Commands	11	(2)
Getting Help	13	(4)
Saving a Workbook	17	(3)
Previewing and Printing a Workbook	20	(3)
Exiting Excel	23	(2)
Basic Workbook Skills	25	(24)
Making Label Entries	26	(4)
Entering Values	30	(3)
Editing Cell Contents	33	(3)
Storing Cell Contents	36	(3)
Copying Cell Contents	39	(3)
Inserting and Deleting Cells	42	(2)
Checking Your Spelling	44	(3)
Using Smart Tags	47	(2)
Working with Formulas and Functions	49	(18)
Creating a Simple Formula	50	(1)
Editing a Formula	51	(3)
Understanding Cell Referencing	54	(3)
Naming Cells and Ranges	57	(5)
Displaying Calculations	62	(2)
Performing Calculations Using Functions	64	(3)
Modifying Worksheets and Workbooks	67	(22)
Selecting and Naming a Worksheet	68	(5)
Working with Columns or Rows	73	(8)
Inserting and Moving Page Breaks	81	(1)
Setting Up the Page	82	(7)
Formatting a Worksheet	89	(18)
Formatting Text and Numbers	90	(2)
Designing Conditional Formatting	92	(1)
Copying Cell Formats	93	(1)
Changing Fonts	94	(2)
Changing Data Alignment	96	(1)
Controlling Text Flow	97	(1)
Changing Data Color	98	(1)
Adding Color and Patterns to Cells	98	(1)
Adding Borders to Cells	99	(1)
Formatting Data with AutoFormat	100	(1)
Modifying an AutoFormat	101	(1)
Creating and Applying a Style	102	(2)
Modifying a Style	104	(1)
Finding and Replacing Formatting	105	(2)
Inserting Graphics and Related Materials	107	(16)
Inserting Pictures	108	(2)
Inserting Media Clips	110	(2)
Stylizing Text with WordArt	112	(3)
Editing WordArt Text	115	(2)
Applying WordArt Text Effects	117	(1)
Inserting an Organization Chart	117	(2)
Modifying an Organization Chart	119	(2)
Creating a Diagram	121	(1)
Modifying Graphic Images	122	(1)
Drawing and Modifying Objects	123	(16)
Drawing Objects	124	(1)
Drawing Lines and Arrows	124	(2)
Drawing AutoShapes	126	(2)
Inserting AutoShapes from the Clip Gallery	128	(1)
Moving and Resizing an Object	129	(2)
Rotating and Flipping an Object	131	(1)
Choosing Object Colors	132	(2)
Adding Object Shadows	134	(1)
Creating a 3-D Object	135	(1)
Aligning and Distributing Objects	135	(2)
Arranging and Grouping Objects	137	(2)
Creating Charts	139	(20)
Understanding Chart Terminology	140	(1)
Choosing the Right Type of Chart	140	(1)
Creating a Chart	141	(3)
Editing a Chart	144	(1)
Selecting a Chart	145	(1)
Changing a Chart Type	146	(1)
Moving and Resizing a Chart	147	(1)
Pulling Out a Pie Slice	148	(1)
Adding and Deleting a Data Series	149	(3)
Enhancing a Data Series	152	(3)
Drawing on a Chart	155	(1)
Formatting Chart Elements	156	(3)
Analyzing Worksheet Data	159	(16)
Understanding List Terminology	160	(1)
Creating a List	161	(1)
Understanding a Data Form	161	(2)
Adding Records Using a Data Form	163	(1)
Managing Records Using a Data Form	164	(2)
Sorting Data in a List	166	(2)
Displaying Parts of a List with AutoFilter	168	(1)
Creating Complex Searches	169	(1)
Entering Data in a List	170	(2)
Auditing a Worksheet	172	(1)
Correcting Formulas	173	(2)
Sharing Workbook Data	175	(14)
Exporting and Importing Data	176	(2)
Linking and Embedding Files	178	(4)
Linking Data	182	(2)
Getting Data from Queries	184	(2)
Getting Data from Another Program	186	(1)
Converting Excel Data into Access Data	187	(2)
Collaborating with Others	189	(12)
Sharing Workbooks	190	(1)
Creating and Reading a Cell Comment	191	(1)
Editing and Deleting a Cell Comment	192	(2)
Tracking Changes	194	(2)
Comparing and Merging Workbooks	196	(1)
Protecting Your Data	197	(2)
Sending a Workbook for Review	199	(2)
Taking Advantage of the Internet	201	(20)
Creating a Web Page	202	(2)
Opening a Workbook as a Web Page	204	(1)
Previewing a Web Page	205	(1)
Inserting an Internet Link	206	(3)
Getting Data from the Web	209	(1)
Copying a Web Table to a Worksheet	210	(1)
Understanding Web Discussions	211	(1)
Having a Web Discussion	212	(2)
Scheduling and Holding an Online Meeting	214	(3)
Sending Workbooks Using E-Mail	217	(3)
Accessing Office Information on the Web	220	(1)
Customizing the Way You Work	221	(26)
Changing Options	222	(2)
Viewing Multiple Workbooks	224	(1)
Creating a Toolbar	225	(3)
Customizing a Toolbar	228	(2)
Creating Groups and Outlines	230	(2)
Saving Time with Templates	232	(2)
Creating a Template	234	(1)
Working with Templates	235	(2)
Controlling Excel with Your Voice	237	(4)
Playing Back Worksheet Data	241	(1)
Recognizing Handwriting	242	(3)
Repairing Office Programs	245	(2)
Glossary	247	(8)
Index	255