Microsoft Office Excel 2003 : Fast & Easy (Fast & Easy) (2ND)

  • ポイントキャンペーン

Microsoft Office Excel 2003 : Fast & Easy (Fast & Easy) (2ND)

  • ただいまウェブストアではご注文を受け付けておりません。 ⇒古書を探す
  • 製本 Paperback:紙装版/ペーパーバック版/ページ数 350 p.
  • 言語 ENG
  • 商品コード 9781592000791
  • DDC分類 005.54

Full Description


This book makes Microsoft Excel easy to learn with point-and-click instructions. There is no heavy jargon, just helpful information. The reader is guided through Excel at a rapid pace with an avalanche of screens to make learning easy. This book provides the tools needed to successfully tackle the sometimes overwhelming challenge of learning how to use spreadsheets. Designed to be user-friendly, "Microsoft Office Excel 2003 Fast & Easy" enables readers to quickly learn the variety of useful features included in this latest version of Microsoft Excel. Filled with screen shots and step-by-step instructions, users of all levels will be up and running in excel quickly.

Table of Contents

Introduction                                       xix
PART I BUILDING A BASIC WORKSHEET 1 (102)
Chapter 1 Exploring the Excel Screen 3 (18)
Starting Excel 4 (1)
Exploring the Worksheet Screen 4 (12)
Working with the Task Pane 6 (2)
Working with Menus 8 (3)
Using Toolbars 11 (5)
Moving around the Worksheet Screen 16 (3)
Using the Mouse 17 (1)
Using the Keyboard 18 (1)
Accessing the Go To Command 18 (1)
Using Excel Help 19 (2)
Chapter 2 Creating a Simple Worksheet 21 (18)
Entering Data 22 (5)
Entering Labels 22 (2)
Entering Values 24 (1)
Entering Dates 25 (2)
Saving a Worksheet File 27 (3)
Saving a File the First Time 27 (2)
Resaving a Worksheet 29 (1)
Closing a Worksheet 30 (1)
Enabling AutoRecover 31 (2)
Opening an Existing File 33 (2)
Displaying the Open Dialog Box 33 (2)
Opening a Recently Used Worksheet 35 (1)
E-Mailing a Worksheet 35 (2)
Starting a New Worksheet 37 (2)
Chapter 3 Editing a Worksheet 39 (22)
Editing Data 40 (2)
Replacing the Contents of a Cell 40 (1)
Editing the Contents of a Cell 41 (1)
Clearing Cell Contents 42 (1)
Learning Selection Techniques 42 (1)
Inserting Areas 43 (4)
Inserting Columns 44 (1)
Inserting Rows 45 (1)
Inserting Cells 46 (1)
Deleting Areas 47 (2)
Deleting Columns 47 (1)
Deleting Rows 48 (1)
Deleting Cells 48 (1)
Using Undo and Redo 49 (2)
Undoing the Previous Step 50 (1)
Redoing the Previous Step 50 (1)
Undoing a Series of Actions 51 (1)
Moving Data Around 51 (4)
Cutting and Pasting Data 51 (2)
Using Drag and Drop to Move Cells 53 (2)
Copying Data 55 (1)
Using the Office Clipboard 56 (2)
Using the Fill Feature 58 (3)
Chapter 4 Making the Worksheet Look Good 61 (28)
Using AutoFormat 62 (2)
Formatting Numbers 64 (7)
Formatting Numbers with the Toolbar 64 (4)
Formatting Numbers through the Menu 68 (3)
Formatting with Fonts 71 (4)
Selecting a Typeface 71 (1)
Selecting a Font Size 72 (1)
Adding Bold, Underline, or Italics 73 (1)
Working with Font Colors 73 (1)
Setting Font Options Using the Format 74 (1)
Dialog Box
Adjusting Column Width 75 (2)
Adjusting Row Height 77 (1)
Setting Worksheet Alignment 78 (5)
Adjusting Cell Alignment 79 (1)
Setting Vertical Alignment 80 (2)
Centering Headings 82 (1)
Adding Cell Borders 83 (1)
Adding Background Color 84 (1)
Using Cell Patterns 85 (2)
Copying Cell Formatting 87 (2)
Chapter 5 Selecting Printing Options 89 (14)
Setting Up the Pages 90 (7)
Setting Up Margins 90 (1)
Setting Page Orientation and Size 91 (1)
Setting Other Printing Options 92 (2)
Creating a Header or Footer 94 (3)
Selecting a Print Area 97 (1)
Printing a Worksheet 98 (4)
Using Print Preview 98 (2)
Printing the Worksheet 100(2)
Part I Review Questions 102(1)
PART II WORKING WITH FORMULAS AND LARGER 103(76)
WORKSHEETS
Chapter 6 Working with Formulas 105(14)
Creating Formulas 106(3)
Creating a Simple Formula 106(2)
Creating a Compound Formula 108(1)
Editing Formulas 109(1)
Copying Formulas 110(4)
Copying Using the Fill Feature 111(1)
Copying with Copy and Paste 112(2)
Creating an Absolute Reference in a Formula 114(2)
Viewing Formulas 116(1)
Understanding Common Formula Error Messages 117(2)
Chapter 7 Using Excel Functions 119(28)
Understanding Function Syntax 120(1)
Creating a Total with the SUM Function 120(5)
Entering a SUM Function 121(3)
Using the AutoSum Button 124(1)
Using Other Functions 125(17)
Calculating with Mathematical Functions 126(2)
Analyzing with Statistical Functions 128(5)
Using Date Functions 133(4)
Figuring with Financial Functions 137(2)
Understanding Logical Functions 139(3)
Getting Help with Excel Functions 142(5)
Chapter 8 Working with Larger Workbooks 147(12)
Moving from Worksheet to Worksheet 148(1)
Inserting Worksheets 149(1)
Naming Worksheets 150(1)
Hiding a Worksheet 151(2)
Deleting Worksheets 153(1)
Creating a Reference to Another Worksheet 154(2)
Creating Links to Other Workbooks 156(3)
Chapter 9 Managing Larger Worksheets 159(20)
Modifying Worksheet Views 160(8)
Hiding Rows and Columns 160(3)
Splitting a Window 163(2)
Freezing Panes 165(2)
Using Zoom 167(1)
Working with Ranges 168(4)
Creating Range Names 168(3)
Using Range Names 171(1)
Using Find and Replace 172(5)
Locating Data with Find 172(3)
Replacing Entries 175(2)
Part II Review Questions 177(2)
PART III ADDING VISUAL INTEREST 179(54)
Chapter 10 Working with Art Images 181(18)
Inserting Images 182(5)
Inserting Clip Art 182(2)
Inserting Saved Images 184(1)
Inserting Images from Your Camera 185(2)
Customizing Art 187(4)
Resizing Images 187(1)
Moving Art 188(2)
Cropping an Image 190(1)
Adding WordArt 191(3)
Making Adjustments to the WordArt 194(4)
Editing WordArt Text 194(1)
Changing WordArt Style 195(2)
Reshaping WordArt 197(1)
Deleting an Art Image 198(1)
Chapter 11 Creating Charts from Excel Data 199(18)
Creating a Chart 200(3)
Modifying a Chart 203(11)
Resizing a Chart 203(2)
Moving a Chart 205(1)
Changing a Chart Style 206(1)
Editing the Series Appearance 206(3)
Modifying Chart Text 209(4)
Displaying the Data Table 213(1)
Deleting a Chart 214(3)
Removing a Chart from a Data Sheet 214(1)
Deleting a Chart on Its Own Sheet 215(2)
Chapter 12 Using the Drawing Toolbar 217(16)
Drawing Shapes 218(7)
Displaying the Drawing Toolbar 218(1)
Creating Lines and Arrows 219(3)
Adding Text Boxes 222(2)
Working with AutoShapes 224(1)
Editing the Drawing Object 225(6)
Changing the Object Color and Fill 225(2)
Adding Text to AutoShapes 227(1)
Creating Shadows 228(1)
Making Shapes 3-Dimensional 229(2)
Part III Review Questions 231(2)
PART IV ANALYZING DATA 233(54)
Chapter 13 Working with Data 235(20)
Sorting 236(6)
Sorting with the Toolbar Buttons 236(1)
Sorting with the Sort Dialog Box 237(3)
Sorting by Dates 240(2)
Using Filters 242(6)
Working with AutoFilter 243(2)
Creating Custom Filters 245(3)
Data Subtotals 248(3)
Conditional Formatting 251(4)
Chapter 14 Discovering Tools for Speed and 255(18)
Quality
Checking the Spelling 256(2)
Working with AutoCorrect 258(3)
Activating AutoCorrect Features 258(2)
Adding AutoCorrect Entries 260(1)
Deleting AutoCorrect Entries 261(1)
Using the Excel Research Tools 261(5)
Navigating the Research Pane 263(2)
Translating Words 265(1)
Checking for Errors 266(2)
Understanding Smart Tags 268(5)
Chapter 15 Customizing Excel 273(14)
Setting Preferences 274(2)
Working with Templates 276(10)
Using a Predefined Template 276(3)
Saving a Template 279(2)
Editing a Template 281(2)
Deleting a Template 283(3)
Part IV Review Questions 286(1)
PART V INTEGRATING EXCEL TECHNOLOGY 287(64)
Chapter 16 Integrating Excel with Word 289(16)
Using Excel Worksheets in Word 290(6)
Creating an Excel Worksheet from Within 290(3)
Word
Resizing the Excel Worksheet in Word 293(3)
Inserting an Existing Excel Worksheet into 296(4)
Word
Inserting an Entire Workbook 296(3)
Copying a Workbook Portion 299(1)
Inserting Word Data into Excel 300(5)
Inserting Paragraphs 300(2)
Inserting Word Tables 302(3)
Chapter 17 Using Excel with Access 305(16)
Exporting an Access Table or Query to Excel 306(2)
Importing Excel Data into Access 308(9)
Beginning a Data Import from Excel to 308(3)
Access
Importing Excel Data as a New Table 311(4)
Appending Excel Data to an Existing Table 315(2)
Linking an Excel Worksheet to Access 317(4)
Chapter 18 Collaborating with Others 321(30)
Working with Comments 322(9)
Adding a Comment 322(1)
Editing a Comment 323(6)
Printing Comments 329(1)
Deleting a Comment 330(1)
Working with Revisions 331(6)
Tracking Revisions 331(2)
Examining Revisions 333(1)
Accepting or Rejecting Revisions 334(3)
Sharing a Workbook 337(2)
Securing a Workbook 339(11)
Protecting a Worksheet 339(3)
Removing Worksheet Protection 342(1)
Unprotecting Specific Worksheet Cells 343(2)
Preventing Others from Opening a Workbook 345(5)
Part V Review Questions 350(1)
Appendix A Excel Shortcut Keys 351(8)
Learning the Basic Shortcuts 352(2)
Working with Menus 352(1)
Getting Help 353(1)
Working with Workbook Files 353(1)
Working inside Workbooks 354(5)
Moving around a Workbook 354(1)
Typing and Editing Cell Data 355(1)
Selecting Ranges of Cells 356(1)
Formatting Data 357(1)
Miscellaneous Commands 358(1)
Glossary 359(6)
Index 365