Microsoft Office 2003 Super Bible - Excel 2003电子书详解

需积分: 0 69 浏览量更新于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页未读，继续阅读

weixin_44596024

粉丝: 3
资源: 62

Microsoft Office 2003 Super Bible - Excel 2003电子书详解

Microsoft Office Excel 2003 Bible

EXCEL超级教程

OpenGL SuperBible

OGL SuperBible

OpenGL SuperBible4

OpenGL.SuperBible

OpenGL Superbible 5th

OpenGL SuperBible 英文版

OpenGL SuperBible 6th

OpenGL SuperBible 6 code

最新资源