没有合适的资源?快使用搜索试试~ 我知道了~
首页Microsoft Office 2003 Super Bible - Excel 2003电子书详解
Microsoft Office 2003 Super Bible - Excel 2003电子书详解
需积分: 0 0 下载量 122 浏览量
更新于2024-07-17
收藏 35.3MB PDF 举报
"EXCEL2003 SuperBible 是一本关于Microsoft Office 2003的英文原版电子书,由Wiley Publishing, Inc.出版。本书详细介绍了Excel 2003的各种功能和使用技巧,是学习和提升Excel技能的参考资料。"
《Excel 2003 SuperBible》作为一本全面的指南,涵盖了Excel 2003的各个方面,包括基本操作、公式与函数、数据管理、图表制作、数据分析工具、宏和VBA编程等多个核心知识点。
1. **基本操作**:书中会讲解如何创建、打开和保存工作簿,设置单元格格式,以及应用各种类型的边框和填充。此外,还会介绍工作表的组织和打印设置,帮助读者掌握基础操作。
2. **公式与函数**:Excel的核心在于计算,书中会深入解析如何构建公式,使用基本数学运算符,以及掌握内置函数,如SUM、AVERAGE、MAX、MIN等统计函数,进一步还有IF逻辑判断、VLOOKUP查找引用等功能。
3. **数据管理**:学习如何有效地组织和管理大量数据,包括排序、筛选、条件格式化和数据有效性规则的应用,以提升数据处理的效率。
4. **图表制作**:通过实例,展示如何创建和定制各种图表类型,如柱状图、折线图、饼图等,以及如何使用图表元素进行数据可视化。
5. **数据分析工具**:书中会涵盖数据透视表的创建和使用,以及数据透视图的分析,帮助读者进行复杂的数据分析和总结。
6. **宏和VBA编程**:对于高级用户,书中有介绍如何录制和编辑宏,以及学习Visual Basic for Applications (VBA),用于自动化Excel任务和创建自定义功能。
7. **工作流集成**:Excel 2003不仅仅是一个独立的应用,书中还将讨论如何与其他Office组件(如Word、PowerPoint)协同工作,以及如何通过Outlook发送和共享Excel文件。
8. **实践案例**:书中提供了丰富的实践练习和示例,让读者能够在实际场景中应用所学知识,提升解决实际问题的能力。
9. **问题解答和提示**:书中可能包含常见问题解答和小贴士,帮助读者解决在使用Excel时遇到的难题,提升工作效率。
通过阅读《Excel 2003 SuperBible》,无论是初学者还是有经验的用户,都能从中获得宝贵的知识和技巧,提升Excel技能,更好地利用这一强大的数据分析工具。由于是英文原版,读者还需要具备一定的英语阅读能力,以便理解书中内容。
xvi Contents
Chapter 10: Integrating Outlook with Other Applications ......................241
Integrating Outlook with Office ............................................................................................. 241
Creating a Mail Merge ............................................................................................................ 244
Getting names from contacts ........................................................................................... 244
Sending an E-mail from an Application ................................................................................. 249
Importing and Exporting Data ................................................................................................ 252
Importing information into Outlook ................................................................................ 253
Exporting information from Outlook .............................................................................. 254
Saving Outlook messages ................................................................................................ 254
Summary ................................................................................................................................. 255
Chapter 11: Comments and Reviewing Functions in Word .....................257
Placing Comments in Documents ........................................................................................... 258
Working with comments .................................................................................................. 259
Inserting voice comments ................................................................................................ 260
Changing and manipulating comments ........................................................................... 262
Reviewing comments ............................................................................................... 263
Printing comments .................................................................................................... 265
Highlighting text .............................................................................................................. 265
Using Reviewing Tools ........................................................................................................... 266
Adding revision marks..................................................................................................... 266
Viewing changes .............................................................................................................. 267
Reviewing, accepting, and rejecting changes .................................................................. 268
Customizing revision marks ............................................................................................ 269
Comparing and merging documents ................................................................................ 270
Comparing documents .............................................................................................. 271
Merging comments and revisions from multiple reviewers..................................... 272
Comparing side by side ................................................................................................... 273
Reading Layout View ............................................................................................................. 273
Moving around in Reading Layout view ......................................................................... 275
Changing text size ........................................................................................................... 276
Editing in Reading Layout view ...................................................................................... 276
Summary ................................................................................................................................. 277
Chapter 12: Sharing Excel Data with Other Applications .......................279
Understanding Data Sharing ................................................................................................... 279
Pasting and Linking Data ........................................................................................................ 280
Using the Clipboards ....................................................................................................... 280
Linking data ..................................................................................................................... 282
Copying Excel data to Word ............................................................................................ 283
Pasting without a link ............................................................................................... 284
Pasting with a link .................................................................................................... 284
Embedding Objects in Documents ......................................................................................... 284
Embedding an Excel range in a Word document ............................................................ 285
Creating a new Excel object in Word .............................................................................. 287
Embedding objects in an Excel worksheet ...................................................................... 288
xviiContents
Working with XML Data ........................................................................................................ 289
What is XML? ................................................................................................................. 289
Importing XML data by using a map .............................................................................. 290
Importing XML data to a list ........................................................................................... 292
Exporting XML data from Excel ..................................................................................... 293
Chapter 13: Team Collaboration on a Draft PowerPoint Presentation ...295
Sharing Your Presentation File on a LAN .............................................................................. 295
Sharing the presentation locally ...................................................................................... 296
Sharing in Windows 2000 or XP .............................................................................. 296
Posting a presentation to an Exchange folder ................................................................. 298
Mailing a presentation via e-mail ........................................................................................... 299
Sharing a Presentation in a Document Workspace ................................................................. 300
Working with Comments ........................................................................................................ 303
Adding a comment ........................................................................................................... 303
Moving, editing, and deleting comments ........................................................................ 304
Reviewing comments ...................................................................................................... 304
Incorporating Changes from Reviewers ................................................................................. 305
Merging review revisions ................................................................................................ 305
Accepting or rejecting revisions ...................................................................................... 306
Using the Reviewing toolbar for revisions ...................................................................... 306
Finishing a review of revisions ........................................................................................ 307
Live Collaboration with NetMeeting ...................................................................................... 307
Live Collaboration with Windows Messenger ....................................................................... 308
Running Windows Messenger ......................................................................................... 308
Inviting someone to share PowerPoint ............................................................................ 309
Giving another participant control................................................................................... 312
Taking control as a participant ......................................................................................... 314
Chatting with other participants ...................................................................................... 314
Using the Whiteboard ...................................................................................................... 315
Ending an application sharing session ............................................................................. 316
Summary ................................................................................................................................. 316
Chapter 14: Integrating FrontPage with Office Applications ................. 317
From Office to FrontPage ....................................................................................................... 318
Moving from Word to FrontPage .................................................................................... 318
Attaching text files to a Web site .............................................................................. 319
How Word creates HTML files ................................................................................ 320
Copying and pasting text into Web pages ................................................................ 320
Creating Web sites from Publisher files .......................................................................... 321
Sending Excel objects to FrontPage ................................................................................ 322
Copying tables into FrontPage ................................................................................. 322
Exporting Excel sheets as HTML pages .................................................................. 323
Sending charts to FrontPage ..................................................................................... 324
Saving Excel workbooks as folders ......................................................................... 324
From PowerPoint to FrontPage ....................................................................................... 326
xviii Contents
Converting slides to Web pages ............................................................................... 326
Integrating a slideshow into FrontPage .................................................................... 327
Importing files into Webs ................................................................................................ 328
Importing Word and Excel files into a Web site ...................................................... 328
Adding Office Web Components to Web Pages ..................................................................... 330
Adding Office spreadsheets ............................................................................................. 330
Defining ActiveX control properties for a spreadsheet ........................................... 332
Defining spreadsheet properties ............................................................................... 334
Adding Office charts........................................................................................................ 335
Changing chart properties ........................................................................................ 336
Controlling charts using the chart menu .................................................................. 337
Presenting a database table in a Web spreadsheet ........................................................... 339
Creating Office PivotTables ............................................................................................ 341
Connecting a PivotTable to an Excel data source .................................................... 342
Adding fields to a PivotTable ................................................................................... 345
Formatting and calculating PivotTable data ............................................................. 347
Implementing an Office spreadsheet Web component ............................................. 348
From FrontPage to Office 2003 .............................................................................................. 349
Sending data to Word mail-merge files ........................................................................... 350
Sending data to Excel ...................................................................................................... 351
Sending reports to Excel .................................................................................................. 351
Summary ................................................................................................................................. 352
Chapter 15: Exchanging Access Data with Office Applications .............353
Using Automation to Integrate with Office ............................................................................ 354
Creating Automation references ...................................................................................... 354
Early binding an object............................................................................................. 354
Late binding an object .............................................................................................. 356
Creating an instance of an Automation object ................................................................ 358
Using the New keyword to create a new instance ................................................... 358
Using the CreateObject function to create a new instance....................................... 358
Getting an existing object instance .................................................................................. 359
Working with Automation objects ................................................................................... 360
Closing an instance of an Automation object .................................................................. 361
An Automation Example Using Word .................................................................................... 361
Creating an instance of a Word object ............................................................................. 365
Making the instance of Word visible ............................................................................... 366
Creating a new document based on an existing template ............................................... 366
Using Bookmarks to insert data ...................................................................................... 367
Activating the instance of Word ...................................................................................... 367
Moving the cursor in Word .............................................................................................. 367
Closing the instance of the Word object .......................................................................... 367
Inserting pictures by using Bookmarks ........................................................................... 368
Using Office’s Macro Recorder ....................................................................................... 368
xixContents
Chapter 16: Collaborating on a Network..................................................373
Resource Sharing and Security ............................................................................................... 373
Setting file-sharing options when saving ........................................................................ 373
Protecting documents ...................................................................................................... 375
Protecting documents in Word ................................................................................. 375
Protecting documents in Excel ................................................................................. 377
Protecting files in Access and PowerPoint ............................................................... 378
Using Information Rights Management tools ................................................................. 379
Sharing Excel Workbooks ...................................................................................................... 381
Creating a shared workbook ............................................................................................ 381
Reviewing changes .......................................................................................................... 383
Collaborating in PowerPoint ................................................................................................... 384
Sharing Access Databases ...................................................................................................... 386
Using passwords .............................................................................................................. 386
Creating user and group accounts.................................................................................... 387
Securing the database ...................................................................................................... 388
Assigning permissions ..................................................................................................... 388
Encryption ........................................................................................................................ 389
Distributing Office Documents ............................................................................................... 389
Sharing documents via e-mail ......................................................................................... 390
Sending a document (without routing it) ................................................................. 390
Routing a document .................................................................................................. 390
Sending documents that aren’t already open............................................................ 392
Posting documents to Exchange folders .................................................................. 392
Sending documents to online meeting participants .................................................. 392
Summary ................................................................................................................................. 392
Chapter 17: Windows SharePoint Services with Office System .............393
Working with SharePoint Sites and SharePoint Lists ............................................................. 394
Accessing SharePoint Services sites ............................................................................... 394
Windows SharePoint Services site permissions .............................................................. 397
Exploring the Windows SharePoint Services site ........................................................... 398
Adding items to existing lists .......................................................................................... 399
Creating new Windows SharePoint Services lists and libraries ...................................... 401
Working with Datasheet views and linking lists to Excel and Access ............................ 401
Collaborative Document Authoring ....................................................................................... 407
Exploring Document Libraries and Shared Workspaces ................................................. 408
Creating Shared Workspaces ........................................................................................... 412
Working with Shared Workspaces inside Office 2003 applications ............................... 413
SharePoint as a Central Contacts and Calendar Server .......................................................... 421
Making SharePoint contacts available to Outlook .......................................................... 423
Conducting an Online Meeting with the Meeting Workspace ............................................... 424
Summary ................................................................................................................................. 426
xx Contents
Part III: Beyond Mastery: Initiative within Office .................429
Chapter 18: Getting Organized with Outlines and Master Documents ..431
Using Outlines ........................................................................................................................ 431
Understanding Outline View ........................................................................................... 432
Creating outlines .............................................................................................................. 433
Rearranging your outline ................................................................................................. 436
Selecting in Outline view ......................................................................................... 436
Promoting and demoting outline levels .................................................................... 437
Moving outline headings .......................................................................................... 438
Using keyboard shortcuts .................................................................................. 438
Viewing both Outline and Normal view at once ............................................... 439
Printing an outline ........................................................................................................... 440
Copying an outline........................................................................................................... 441
Understanding Master Documents ......................................................................................... 441
The Master Document view ............................................................................................ 442
Building a master document ............................................................................................ 444
Starting from scratch ................................................................................................ 444
Converting an existing document ............................................................................. 446
Inserting existing documents into a master document ............................................. 446
Working with master documents ..................................................................................... 446
Working with subdocuments ........................................................................................... 447
Opening a subdocument ........................................................................................... 447
Renaming or moving a subdocument ....................................................................... 448
Removing subdocuments ......................................................................................... 448
Rearranging the order of subdocuments .................................................................. 449
Splitting subdocuments ............................................................................................ 449
Merging subdocuments ............................................................................................ 449
Sharing subdocuments .............................................................................................. 449
Summary ................................................................................................................................. 450
Chapter 19: Processing Outlook Messages Automatically .....................451
Securing Against HTML Content ........................................................................................... 451
Blocking external HTML content ................................................................................... 452
Configuring security zones .............................................................................................. 453
Using Rules ............................................................................................................................. 454
Using the Rules Wizard ................................................................................................... 454
Creating a rule .......................................................................................................... 454
Controlling rule processing order ............................................................................. 459
Running rules manually............................................................................................ 460
Modifying and copying rules ................................................................................... 461
Responding automatically to messages ........................................................................... 461
Importing, exporting, and backing up rules .................................................................... 462
Back up rules to a file ............................................................................................... 463
Import rules from a file ............................................................................................ 463
剩余637页未读,继续阅读
2008-09-28 上传
2008-07-26 上传
2008-09-25 上传
185 浏览量
2017-11-24 上传
weixin_44596024
- 粉丝: 3
- 资源: 62
上传资源 快速赚钱
- 我的内容管理 展开
- 我的资源 快来上传第一个资源
- 我的收益 登录查看自己的收益
- 我的积分 登录查看自己的积分
- 我的C币 登录后查看C币余额
- 我的收藏
- 我的下载
- 下载帮助
最新资源
- C语言数组操作:高度检查器编程实践
- 基于Swift开发的嘉定单车LBS iOS应用项目解析
- 钗头凤声乐表演的二度创作分析报告
- 分布式数据库特训营全套教程资料
- JavaScript开发者Robert Bindar的博客平台
- MATLAB投影寻踪代码教程及文件解压缩指南
- HTML5拖放实现的RPSLS游戏教程
- HT://Dig引擎接口,Ampoliros开源模块应用
- 全面探测服务器性能与PHP环境的iprober PHP探针v0.024
- 新版提醒应用v2:基于MongoDB的数据存储
- 《我的世界》东方大陆1.12.2材质包深度体验
- Hypercore Promisifier: JavaScript中的回调转换为Promise包装器
- 探索开源项目Artifice:Slyme脚本与技巧游戏
- Matlab机器人学习代码解析与笔记分享
- 查尔默斯大学计算物理作业HP2解析
- GitHub问题管理新工具:GIRA-crx插件介绍
安全验证
文档复制为VIP权益,开通VIP直接复制
信息提交成功