Microsoft Excel 2002 Plain & Simple
暫譯: Microsoft Excel 2002 簡明易懂指南

Curtis Frye, The Epic Software Group

Microsoft Excel 2002 Plain & Simple
  • 出版商: 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

商品描述(中文翻譯)

描述：
您的快速解答、無術語的 Excel 2002 指南！

獲取讓學習 Excel 2002 變得簡單明瞭的快速資訊！
您將學到的內容：
• 找到在 Microsoft® Excel 中完成任務的最簡單方法
• 自訂您的電子表格：格式、公式、函數
• 添加圖表、圖形和樞紐分析表® 使數據生動
• 將電子表格嵌入到網頁中
• 將 Excel 與其他 Microsoft Office 程式一起使用

您將如何學習：
• 編號步驟清楚顯示該做什麼
• 彩色螢幕截圖幫助您保持進度
• 方便的提示教您簡單的技巧和捷徑
• 快速的「試試看！」練習讓您的學習付諸實踐
• 注意事項幫助您避免麻煩

目錄：
致謝 xi
1 關於本書 1
• 無電腦術語！ 1
• 快速概述 2
• 幾個假設 3
• 最後的話（或兩句） 4
2 開始使用 Excel 2002 5
• 瀏覽 Excel 螢幕 6
• 瀏覽 Excel 工具列 7
• 啟動 Excel 8
• 介紹任務窗格 9
• 使用任務窗格 10
• 排列工具列 11
• 查找和打開現有工作簿 12
• 使用檔案屬性 13
• 創建新工作簿 15
• 打開可用的工作簿 15
• 使用多個工作簿 16
• 調整和排列視窗 17
• 在工作表上放大或縮小 18
• 以全螢幕模式查看工作表 18
• 儲存和關閉 Excel 工作簿 19
• 使用「詢問問題」框獲取幫助 20
• 使用 Excel 幫助 21
• 在列印前預覽工作表 22
3 建立工作簿 23
• 理解 Excel 如何解釋數據輸入 24
• 瀏覽工作表 25
• 選擇儲存格 25
• 在儲存格中輸入文本 27
• 在儲存格中輸入數字 28
• 在儲存格中輸入日期和時間 29
• 使用填充輸入數據 30
• 使用其他捷徑輸入數據 31
• 編輯儲存格內容 32
• 格式化儲存格內容 33
• 格式化包含數字的儲存格 34
• 格式化包含日期的儲存格 35
• 對齊和定位儲存格內容 36
• 在儲存格中插入符號 37
• 創建超連結 38
• 剪下、複製和粘貼儲存格值 40
• 清除儲存格內容 41
• 使用 Office 剪貼簿 42
• 撤銷或重做操作 43
• 查找和替換文本 43
• 檢查工作表的拼寫 44
4 管理和查看工作表 47
• 查看和選擇工作表 48
• 重新命名工作表 49
• 移動工作表 49
• 複製工作表 51
• 插入或刪除工作表 53
• 同時在多個工作表上輸入數據和格式化 54
• 更改查看 Excel 工作簿的方式 56
• 命名和使用工作表視圖

類似商品