Microsoft Excel 2002 fast & easy Book

	Introduction	xix
Part I	Building Your First Worksheet	1
Chapter 1	Welcome to Excel 2002	3
	Starting Excel	4
	Entering Text and Numbers	5
	Moving Between Cells	7
	Entering a Formula	7
	Playing "What If?"	9
Chapter 2	What's on the Excel Screen?	11
	Using Menus	12
	Understanding Menu Items	13
	Using Shortcut Menus	14
	Using Toolbars	15
	Using Lists on Toolbars	15
	Working with Dialog Boxes	16
	Using the Task Pane	18
	Displaying Different Task Panes	18
	Working with the Status Bar	19
	Displaying Hiding On-Screen Controls	20
	Changing How Menus and Toolbars Work	21
	Moving Around the Screen with Scroll Bars	22
	Getting Help	22
Chapter 3	Saving, Printing and Exiting Excel	25
	Saving Your Work	26
	Changing the Save Location	28
	Printing a Worksheet	29
	Printing with the Print Button	29
	Printing with the Print Dialog Box	29
	Exiting Excel	31
Chapter 4	Managing Workbooks and Worksheets	33
	Creating a New Workbook	34
	Moving Between Workbooks	35
	Viewing Multiple Workbooks	35
	Closing a Workbook	37
	Opening an Existing Workbook	38
	Opening a Recently Used File	38
	Opening a File with the Open Dialog Box	39
	Opening a File from Another Location	40
	Working with Worksheets	41
	Naming a Worksheet	41
	Adding Worksheets to a Workbook	42
	Deleting a Worksheet	43
	Part I Review Questions	44
Part II	Constructing Larger Worksheets	45
Chapter 5	Editing Worksheets	47
	Selecting Cells	48
	Editing Cell Content	49
	Replacing Cell Content	50
	Removing Cell Content	50
	Adding Rows and Columns	51
	Oops!--Using Undo and Redo	52
	Undoing Multiple Actions	52
	Moving Data	53
	Copying Data	54
	Using Clipboard Copy Options	55
	Specifying Paste Options	56
	Using the Clipboard Task Pane	57
	Using Drag and Drop	58
	Filling a Range	59
	Filling with a Series	60
	Transposing Cells	61
	Adjusting Column Width and Row Height	63
	Resizing a Column to Fit	64
	Setting a Specific Column Width	65
	Checking Your Spelling	66
Chapter 6	Using Formulas and Functions	69
	Entering a Simple Calculation	70
	Using Built-In Functions	71
	Using the Formula Palette with the SUM Function	72
	Using AutoSum	75
	Creating an IF Function	76
	Copying Formulas with Relative and Absolute References	79
	Using AutoCalculate	83
	Inserting Today's Date	83
	Some Common Mistakes to Avoid	85
Chapter 7	Navigating Your Worksheets	87
	Naming a Range	88
	Moving Directly to a Cell or Range	90
	Finding and Replacing Cell Entries	91
	Finding Cell Entries	91
	Replacing Cell Entries	93
	Viewing Different Parts of Your Worksheet at the Same Time	94
	Hiding Rows and Columns	94
	Displaying Hidden Rows or Columns	96
	Splitting a Window	98
	Removing a Split	99
	Keeping Row or Column Labels Visible	99
	Removing the Freeze	100
Chapter 8	Working with Data	101
	Sorting Data	102
	Sorting the Order of Rows in a Range	102
	Sorting the Order of Columns in a Range	106
	Filtering Data	108
	Turning Off AutoFilter	110
Chapter 9	Working with Templates	111
	Creating a New Workbook with a Template	112
	Modifying a Template	113
	Modifying the Default Workbook Settings	116
Chapter 10	Exploring Print Options	121
	Setting Paper Size and Orientation	122
	Setting Margins	124
	Adding Headers and Footers	125
	Selecting Rows and Columns to Appear on Every Page	128
	Setting the Print Area	131
	Clearing the Print Area	132
	Previewing Your Worksheet	132
	Zooming	133
	Adjusting Margins	134
	Previewing Page Breaks	135
	Closing Page Break Preview	136
	Printing Your Worksheet	137
	Part II Review Questions	138
Part III	Making Your Data Look Good	139
Chapter 11	Formatting Text	141
	Using AutoFormat	142
	Removing AutoFormat	143
	Using Fonts	145
	Adding Bold, Italic, and Underline	146
	Aligning Your Text	148
	Centering a Heading Over More Than One Column	148
	Other Alignment Options	149
	Copying Text Formatting	151
Chapter 12	Formatting Numbers and Cells	153
	Applying Number Formatting	154
	Formatting Currency	154
	Formatting Percentages	155
	Adding and Removing Decimal Places	156
	Formatting Dates	157
	Applying Borders	160
	Applying Colors and Patterns	162
	Adding a Background Color	162
	Adding a Pattern	163
	Part III Review Questions	166
Part IV	Adding Pictures and Charts	167
Chapter 13	Adding Clip Art and WordArt to a Worksheet	169
	Adding Clip Art	170
	Opening the Clip Art Controls	170
	Searching for a Clip Art Image	171
	Adjusting then Size and Location of Clip Art	174
	Adjusting the Size of Clip Art	174
	Moving the Clip Art Image	176
	Adjusting the Quality of the Picture	177
	Inserting a Picture from a File	178
	Cropping an Image	179
	Adding WordArt	181
	Changing the Look of Your WordArt	183
	Rotating WordArt	183
	Changing the WordArt Shape	185
	Editing WordArt Text	185
Chapter 14	Generating a Chart	187
	Creating a Chart with the Chart Wizard	188
	Changing the Chart Type	194
	Changing How the Data Is Plotted	195
	Changing Which Cells Are Plotted	196
Chapter 15	Formatting Your Chart	199
	Making Labels Easier to Read	200
	Changing Label Size and Color	200
	Rotating Label Text	202
	Adding Data Labels	203
	Moving Labels	205
	Resizing the Legend	205
	Displaying or Hiding the Legend	206
	Displaying or Hiding a Data Table	207
	Formatting Chart Elements	207
	Changing Series Colors	208
	Setting a Number Format for an Axis	209
	Part IV Review Questions	212
Part V	Sharing with other Programs and People	213
Chapter 16	Integrating Excel with Word	215
	Creating an Excel Worksheet from within Word	216
	AutoFormatting an Embedded Worksheet	219
	Inserting Rows or Columns in an Embedded Worksheet	221
	Inserting an Existing Excel Worksheet into Word	223
	Linking a Part of an Existing Excel Sheet	225
	Importing Word Data into Excel	229
Chapter 17	Integrating Excel with Access	231
	Importing Excel Data into Access	232
	Beginning a Data Import from Excel to Access	232
	Importing Excel Data as a New Table	235
	Appending Excel Data to an Existing Table	240
	Linking an Excel Worksheet to Access	242
	Exporting an Access Table or Query to Excel	246
Chapter 18	Using Excel to Analyze Data from the Web	249
	Opening Web Documents in Excel	250
	Copying Data from a Web Page	252
	Creating a Simple Web Query	255
	Creating a Multi-Table Web Query	256
	Starting a Web Query from a Web Page	256
	Starting a Web Query from Excel	257
	Refreshing a Web Query	259
	Saving a Web Query	260
	Running a Saved Web Query	262
Chapter 19	Sharing Excel Data on the Internet	265
	Inserting a Hyperlink	266
	Inserting an E-Mail Link	271
	Saving the Worksheet for the Web	273
	Setting More Publishing Options	277
	Sharing Excel Data via E-Mail	281
	Including Excel Data in an E-Mail Message Body	281
	Attaching an Excel Workbook to an E-Mail Message	284
Chapter 20	Collaborating with Others	285
	Working with Comments	286
	Editing a Comment	287
	Deleting a Comment	288
	Working with Revisions	289
	Tracking Revisions	289
	Examining Tracked Revisions	291
	Accepting or Rejecting Revisions	291
	Sharing a Workbook	293
	Protecting Your Data	295
	Protecting a Worksheet	295
	Removing Password Protection from Worksheets	298
	Protecting Your Workbook	299
	Removing Password Protection from Workbooks	300
	Preventing Your Workbook from Being Opened	301
	Protecting Only Certain Cells	304
	Part V Review Questions	306
Part IV	Appendixes	307
Appendix A	Installing Excel	309
	Installing the Software	310
	Choosing Components	314
	Working with Maintenance Mode	314
	Adding and Removing Components	315
	Repairing or Reinstalling Office	318
	Removing Office from Your PC	319
Appendix B	Using Keyboard Shortcuts	320
	Working with Menus	321
	Opening Dialog Boxes	321
	Moving Around in a Worksheet or Workbook	322
	Typing Data into Cells	322
	Applying Number Formats	323
	Formatting Data Title:    Microsoft Excel 2002 fast & easy Manufacturer: WonderClub WonderClub Item Number: 9780761533986 Number: 1 Product Description: Microsoft Excel 2002 fast & easy Universal Product Code (UPC): 9780761533986 WonderClub Stock Keeping Unit (WSKU): 9780761533986 Rating: 3/5 based on 1 Reviews Image Location: https://wonderclub.com/images/covers/39/86/9780761533986.jpg Category: Media >> Books Weight: 0.200 kg (0.44 lbs) Width: 7.390 cm (2.91 inches) Heigh : 9.130 cm (3.59 inches) Depth: 0.780 cm (0.31 inches) Date Added: August 25, 2020, Added By: Ross Date Last Edited: August 25, 2020, Edited By: Ross Price Condition Delivery Seller Action $99.99 Digital Arrives between May 9 - Jun 8 Login to your account for a direct download. Some files are emailed from Dropbox. Continent $0.00 - World $0.00 WonderClub (9296 total ratings) Question Concerning Microsoft Excel 2002 fast & easy Ask a Question about Microsoft Excel 2002 fast & easy No Question found! Read Reviews for Microsoft Excel 2002 fast & easy Write review Fedor Teplukhin reviewed Microsoft Excel 2002 fast & easy on December 29, 2011 Microsoft Excel 2002 fast & easy Good Login   |   Complaints   |   Blog   |   Games   |   Digital Media   |   Souls   |   Obituary   |   Contact Us   |   FAQ CAN'T FIND WHAT YOU'RE LOOKING FOR? CLICK HERE!!! X You must be logged in to add to Wishlist E-mail address: Password:           Open Account Here X This item is in your Wish List View Wish List Remove from List Continue Shopping X This item is in your Collection Microsoft Excel 2002 fast & easy View Collection Remove from Collection Edit Collection Continue Shopping X This Item is in Your Inventory Microsoft Excel 2002 fast & easy View Inventory Remove from Inventory Edit Inventory Continue Shopping X You must be logged in to review the products E-mail address: Password:           Open Account Here X View Cart Checkout Continue Shopping X X Add Microsoft Excel 2002 fast & easy, Relax. Learning how to use Excel 2002 is now a breeze. With this book's easy to understand instructions, you'll be building professional-looking worksheets in no time. From the basics of creating a new workbook and using toolbars to the exciting new featu, Microsoft Excel 2002 fast & easy to the inventory that you are selling on WonderClub Product Condition Collectible - Good Collectible - Acceptable Collectible - Very Good Collectible - Like New New - New Refurbished - Refurbished Replica - Acceptable Replica - Good Replica - Very Good Replica - Like New Replica - New Used - Like New Used - Very Good Used - Good Used - Acceptable Price Condition Note Quantity 1 2 3 4 5 6 7 8 9 10 MSKU MSKU=Merchant Stock Keeping Unit, You can create any value you wish to help you keep track of your products Add X X Add Microsoft Excel 2002 fast & easy, Relax. Learning how to use Excel 2002 is now a breeze. With this book's easy to understand instructions, you'll be building professional-looking worksheets in no time. From the basics of creating a new workbook and using toolbars to the exciting new featu, Microsoft Excel 2002 fast & easy to your collection on WonderClub Condition Note Quantity 1 2 3 4 5 6 7 8 9 10 MSKU MSKU=Merchant Stock Keeping Unit, You can create any value you wish to help you keep track of your products Value This is the value of this item at today's market price Price Paid This is the price you paid for this item. Add