Microsoft Excel 2002 Plain & Simple

Curtis Frye, The Epic Software Group

  • 出版商: MicroSoft
  • 出版日期: 2001-11-06
  • 售價: $700
  • 語言: 英文
  • 頁數: 239
  • 裝訂: Paperback
  • ISBN: 0735614512
  • ISBN-13: 9780735614512
  • 相關分類: Excel
  • 已絕版

買這商品的人也買了...

相關主題

商品描述

Description:

Your fast-answers, no-jargon guide to Excel 2002!

Get the fast facts that make learning Excel 2002 plain and simple!

HERE’S WHAT YOU’LL LEARN:
• Find the simplest ways to get stuff done in Microsoft® Excel
• Customize your spreadsheet: format, formulas, functions
• Add charts, graphics, and PivotTables® to bring data alive
• Embed a spreadsheet into a Web page
• Use Excel with other Microsoft Office programs

HERE’S HOW YOU’LL LEARN IT:
• NUMBERED STEPS show exactly what to do
• Color SCREEN SHOTS keep you on track
• Handy TIPS teach easy techniques and shortcuts
• Quick TRY THIS! exercises put your learning to work
• CAUTION notes help keep you out of trouble

 

Table of Contents:

Acknowledgments xi
1  About This Book 1
    No Computerese! 1
    A Quick Overview 2
    A Few Assumptions 3
    A Final Word (or Two) 4
2  Getting Started with Excel 2002 5
    Surveying the Excel Screen 6
    Touring the Excel Toolbars 7
    Starting Excel 8
    Introducing the Task Panes 9
    Working with Task Panes 10
    Arranging Toolbars 11
    Finding and Opening Existing Workbooks 12
    Using File Properties 13
    Creating a New Workbook 15
    Opening Ready-to-Use Workbooks 15
    Working with Multiple Workbooks 16
    Sizing and Arranging Windows 17
    Zooming In or Out on a Worksheet 18
    Viewing a Worksheet in Full Screen Mode 18
    Saving and Closing an Excel Workbook 19
    Getting Help with the Ask A Question Box 20
    Using Excel Help 21
    Previewing a Worksheet Before Printing 22
3  Building a Workbook 23
    Understanding How Excel Interprets Data Entry 24
    Navigating the Worksheet 25
    Selecting Cells 25
    Entering Text in Cells 27
    Entering Numbers in Cells 28
    Entering Dates and Times in Cells 29
    Entering Data Using Fills 30
    Entering Data with Other Shortcuts 31
    Editing Cell Contents 32
    Formatting Cell Contents 33
    Formatting Cells Containing Numbers 34
    Formatting Cells Containing Dates 35
    Aligning and Orienting Cell Contents 36
    Inserting a Symbol in a Cell 37
    Creating Hyperlinks 38
    Cutting, Copying, and Pasting Cell Values 40
    Clearing Cell Contents 41
    Using the Office Clipboard 42
    Undoing or Redoing an Action 43
    Finding and Replacing Text 43
    Checking the Spelling of Your Worksheet 44
4  Managing and Viewing Worksheets 47
    Viewing and Selecting Worksheets 48
    Renaming Worksheets 49
    Moving Worksheets 49
    Copying Worksheets 51
    Inserting or Deleting Worksheets 53
    Entering Data on and Formatting Many Worksheets at Once 54
    Changing How You Look at Excel Workbooks 56
    Naming and Using Worksheet Views 58
5  Using Formulas and Functions 59
    Understanding Formulas and Cell References 60
    Assigning Names to Groups of Cells 61
    Creating Simple Cell Formulas 63
    Using Names in Formulas 64
    Creating Formulas with Cells from Other Workbooks 65
    Summing a Group of Cells 68
    Creating a Summary Formula 69
    Summing with Subtotals and Grand Totals 70
    Exploring the Excel Function Library 71
    Using the IF Function 72
    Checking Formula References 73
    Debugging Your Formulas 74
6  Formatting the Worksheet 77
    Changing Row Heights and Column Widths 78
    Inserting Rows or Columns 79
    Moving Rows and Columns 81
    Deleting Rows and Columns 82
    Outlining to Hide and Show Rows and Columns 83
    Hiding Rows and Columns 85
    Coloring Sheet Tabs 86
    Setting Font Color 87
    Adding Cell Backgrounds and Shading 87
    Formatting Cell Borders 89
    Changing a Worksheet's Gridlines 91
    Formatting a Cell Based on Conditions 92
    Copying Formats with the Format Painter 94
    Protecting Worksheets from Changes 95
    Locking Cells to Prevent Changes 96
    Styling Cell Text 97
    Merging or Splitting Cells or Data 99
    Hiding or Showing a Worksheet 100
7  Printing Worksheets 101
    Previewing Worksheets Before Printing 102
    Printing Worksheets with Current Options 103
    Choosing Printers and Paper Options 104
    Printing Part of a Worksheet 106
    Printing Row and Column Headings on Each Page 107
    Setting and Changing Print Margins 108
    Setting Page Orientation and Scale 109
    Creating Headers and Footers 110
    Adding Graphics to a Header or a Footer 112
    Setting and Viewing Page Breaks 115
8  Customizing Excel to the Way You Work 117
    Opening Several Related Workbooks 118
    Creating Documents Using Templates 119
    Displaying Additional Toolbars and Menus 121
    Customizing Toolbars 123
    Customizing Menus 124
    Working with Custom Toolbars 125
9  Sorting and Filtering Worksheet Data 127
    Sorting Worksheet Data 128
    Creating a Custom List 130
    Filtering Data Quickly with AutoFilter 132
    Creating an Advanced Filter 134
    Validating Data for Correctness During Entry 136
    Getting More out of Advanced Filters 139
10  Using Charts to Display Data 141
    Displaying Data Graphically 142
    Creating a Chart Using the Chart Wizard 144
    Changing a Chart's Appearance 146
    Formatting Chart Legends and Titles 147
    Changing the Body of a Chart 149
    Customizing Chart Data 151
    Working with Common Charts 153
    Working with Uncommon Charts 154
    Performing a "What If" Analysis 156
11  Enhancing Your Worksheets with Graphics 157
    Working with Graphics in Your Worksheets 158
    Adding Graphics to Worksheets 159
    Adding Drawing Objects to a Worksheet 160
    Adding Fills to Drawing Objects 161
    Adding Effects to Drawing Objects 163
    Customizing Pictures and Objects 164
    Aligning and Grouping Drawing Objects 164
    Adding AutoShapes 166
    Using WordArt to Create Text Effects in Excel 167
    Inserting Clip Art into a Worksheet 169
    Inserting and Changing a Diagram 171
    Creating an Organization Chart 173
12  Using Excel in a Group Environment 177
    Sharing Workbooks in Excel 178
    Commenting Cells 179
    Tracking Changes in Workbooks 181
    Accepting or Rejecting Changes 182
    Merging Workbooks 184
    Analyzing Alternative Data Scenarios 186
    Combining Scenarios into One Worksheet 189
13  Web Linking and Publishing 191
    Saving Worksheets to the Web 192
    Using Excel to Change Web Page Data 193
    Retrieving Web Data from Excel 196
    Introducing XML 198
    Interacting over the Web with XML 199
    Using Smart Tags to Dynamically Link Web Data to Excel 200
    Modifying Web Queries 202
14  Using Excel with Other Programs 203
    Turning Text into Speech 204
    Introducing Linking and Embedding 205
    Linking and Embedding Other Files 206
    Exchanging Table Data Between Excel and Word 208
    Copying Excel Charts and Data into PowerPoint 210
    Exchanging Data Between Access and Excel 211
    Sending E-Mail Directly from Excel 213
    Converting Files To and From Excel 214
    Importing a Text File 216
15  Introducing Advanced Excel Topics 219
    Surveying PivotTables 220
    Building PivotTables 222
    Editing PivotTables 223
    Working with a PivotTable 224
    Linking to PivotTable Data 225
    Publishing a PivotTable on the Web 226
    Using Goal Seek to Conduct a "What If" Analysis 228
    Creating a Macro 229
    Setting Macro Security 230
INDEX 231