Office 2013速通指南：提升工作效率秘籍

2013

4星 · 超过85%的资源需积分: 50 176 浏览量更新于2024-07-23 收藏 39.18MB PDF 举报

《Office 2013 All-in-One For Dummies》是由Peter Weverka撰写的一本专为Microsoft Office 2013用户提供实用指南的书籍。该书旨在帮助读者快速掌握如何有效地、高效地利用这些办公软件工具，而不是详细介绍各个应用程序的功能细节。作者认识到，许多用户可能已经对基础操作有所了解，但他们在实际工作中可能会遇到效率提升或特定任务解决的问题。因此，本书的重点在于如何通过简化复杂流程、分享实用技巧和工作流程优化策略，使读者能在日常办公中更好地运用Office 2013的各种组件，如Word、Excel、PowerPoint等。书中可能包含的内容包括： 1. **快速入门与设置**：对于初次接触Office 2013的读者，章节可能会介绍安装过程、界面布局以及基本操作，确保读者熟悉软件环境。 2. **生产力工具**：重点讲解如何使用Office套件中的工具提高工作效率，例如快捷键、自动化功能（如宏）、模板的创建和应用等。 3. **高效写作与编辑**：这部分可能包括如何撰写专业文档（Word）、制作表格（Excel）、编写演示文稿（PowerPoint）等方面的高级技巧，如数据可视化、协作编辑和版本控制。 4. **电子文档管理和协作**：讨论如何在OneDrive、SharePoint等云服务中组织和共享文件，以及协同工作的最佳实践。 5. **邮件管理和日程安排**：深入解析Outlook的高效使用，包括电子邮件管理、日程安排、会议安排和联系人管理。 6. **安全与隐私**：强调保护个人信息的重要性，介绍如何设置密码、使用数字签名以及防范网络威胁。 7. **问题解答与故障排除**：提供常见问题的解决方案和技巧，帮助读者解决日常使用中遇到的技术难题。 8. **更新与兼容性**：考虑到技术的不断进步，部分章节会涵盖如何接收并适应Office 2013的最新更新，以及与其他版本的兼容性问题。《Office 2013 All-in-One For Dummies》是一本实用型教程，它帮助读者将理论知识转化为实际操作能力，通过提升技能和工作效率，让读者能够更充分地利用Microsoft Office 2013这一强大工具集。

Office 2013 All-in-One For Dummies

xiv

Chapter 4: Constructing the Perfect Table.......................115

Talking Table Jargon ................................................................................... 115

Creating a Table ...........................................................................................116

Entering the Text and Numbers .................................................................118

Selecting Different Parts of a Table ........................................................... 119

Laying Out Your Table ................................................................................ 120

Changing the size of a table, columns, and rows ...........................120

Adjusting column and row size ........................................................121

Inserting columns and rows .............................................................121

Deleting columns and rows ..............................................................123

Moving columns and rows ................................................................123

Aligning Text in Columns and Rows ..........................................................124

Merging and Splitting Cells .........................................................................125

Repeating Header Rows on Subsequent Pages ........................................126

Formatting Your Table ................................................................................127

Designing a table with a table style ................................................. 127

Calling attention to different rows and columns ...........................129

Decorating your table with borders and colors ............................129

Using Math Formulas in Tables .................................................................132

Neat Table Tricks ........................................................................................133

Changing the direction of header row text .....................................133

Wrapping text around a table ..........................................................134

Using a picture as the table background ........................................ 135

Drawing diagonal lines on tables ..................................................... 136

Drawing on a table ............................................................................. 137

Chapter 5: Taking Advantage of the Proong Tools...............139

Correcting Your Spelling Errors ................................................................140

Correcting misspellings one at a time .............................................140

Running a spell-check ........................................................................141

Preventing text from being spell checked ......................................143

Checking for Grammatical Errors in Word ...............................................143

Getting a Word Denition ........................................................................... 144

Finding and Replacing Text ........................................................................ 145

The basics: Finding stray words and phrases ................................145

Narrowing your search .....................................................................146

Conducting a nd-and-replace operation .......................................152

Researching a Topic Inside Word ..............................................................153

Finding the Right Word with the Thesaurus ............................................ 155

Proong Text Written in a Foreign Language ..........................................156

Telling Ofce which languages you will use ...................................156

Marking text as foreign language text .............................................157

Translating Foreign Language Text ...........................................................157

Table of Contents

Chapter 6: Desktop Publishing with Word ......................159

Experimenting with Themes ......................................................................159

Sprucing Up Your Pages .............................................................................161

Decorating a page with a border .....................................................161

Putting a background color on pages .............................................162

Getting Word’s help with cover letters ...........................................162

Making Use of Charts, Diagrams, Shapes, Clip Art, and Photos ........... 163

Working with the Drawing Canvas ............................................................164

Positioning and Wrapping Objects Relative to the Page and Text ........165

Wrapping text around an object ...................................................... 166

Positioning an object on a page ....................................................... 167

Working with Text Boxes ............................................................................169

Inserting a text box ............................................................................ 170

Making text ow from text box to text box ....................................170

Dropping In a Drop Cap ..............................................................................171

Watermarking for the Elegant Effect ......................................................... 171

Putting Newspaper-Style Columns in a Document ..................................173

Doing the preliminary work ..............................................................173

Running text into columns ................................................................173

Landscape Documents ................................................................................174

Printing on Different Size Paper .................................................................175

Showing Online Video in a Document .......................................................176

Chapter 7: Getting Word’s Help with Ofce Chores...............177

Highlighting Parts of a Document ..............................................................177

Commenting on a Document ......................................................................178

Entering a comment ..........................................................................178

Viewing and displaying comments .................................................. 180

Caring for and feeding comments ....................................................180

Tracking Changes to Documents ...............................................................181

Telling Word to start marking changes ...........................................182

Reading and reviewing a document with change marks ..............183

Marking changes when you forgot to turn on change marks .......184

Accepting and rejecting changes to a document...........................186

Printing an Address on an Envelope ......................................................... 186

Printing a Single Address Label (or a Page of the Same Label) ............. 188

Churning Out Letters, Envelopes, and Labels for Mass Mailings ..........189

Preparing the source le ...................................................................190

Merging the document with the source le....................................191

Printing form letters, envelopes, and labels...................................195

Chapter 8: Tools for Reports and Scholarly Papers ...............197

Alphabetizing a List .....................................................................................197

Outlines for Organizing Your Work ...........................................................198

Viewing the outline in different ways ..............................................199

Rearranging document sections in Outline view ...........................199

Office 2013 All-in-One For Dummies

xvi

Collapsing and Expanding Parts of a Document ......................................200

Generating a Table of Contents .................................................................200

Creating a TOC ...................................................................................201

Updating and removing a TOC .........................................................202

Customizing a TOC ............................................................................202

Changing the structure of a TOC .....................................................203

Indexing a Document ..................................................................................205

Marking index items in the document.............................................206

Generating the index .........................................................................207

Editing an index..................................................................................209

Putting Cross-References in a Document .................................................209

Putting Footnotes and Endnotes in Documents ...................................... 211

Entering a footnote or endnote ........................................................212

Choosing the numbering scheme and position of notes ..............213

Deleting, moving, and editing notes ................................................ 214

Compiling a Bibliography ........................................................................... 214

Inserting a citation for your bibliography ......................................215

Editing a citation ................................................................................ 217

Changing how citations appear in text ...........................................217

Generating the bibliography ............................................................217

Book III: Excel 2013 ................................................. 219

Chapter 1: Up and Running with Excel..........................221

Creating a New Excel Workbook ................................................................221

Getting Acquainted with Excel ...................................................................223

Rows, columns, and cell addresses .................................................225

Workbooks and worksheets ............................................................. 225

Entering Data in a Worksheet ....................................................................225

The basics of entering data ..............................................................225

Entering text labels ............................................................................227

Entering numeric values ...................................................................227

Entering date and time values ..........................................................228

Quickly Entering Lists and Serial Data with the AutoFill Command .....231

Formatting Numbers, Dates, and Time Values ........................................232

Conditional Formats for Calling Attention to Data ..................................235

Establishing Data-Validation Rules ...........................................................236

Chapter 2: Rening Your Worksheet............................239

Editing Worksheet Data ..............................................................................239

Moving Around in a Worksheet ................................................................. 240

Getting a Better Look at the Worksheet ...................................................241

Freezing and splitting columns and rows .......................................241

Hiding columns and rows .................................................................243

Comments for Documenting Your Worksheet .........................................244

Selecting Cells in a Worksheet ................................................................... 246

Table of Contents

xvii

Deleting, Copying, and Moving Data .........................................................247

Handling the Worksheets in a Workbook .................................................247

Keeping Others from Tampering with Worksheets ................................249

Hiding a worksheet ............................................................................ 250

Protecting a worksheet .....................................................................250

Chapter 3: Formulas and Functions for Crunching Numbers .......253

How Formulas Work ....................................................................................253

Referring to cells in formulas ...........................................................253

Referring to formula results in formulas.........................................256

Operators in formulas ....................................................................... 257

The Basics of Entering a Formula ..............................................................258

Speed Techniques for Entering Formulas ................................................259

Clicking cells to enter cell references .............................................259

Entering a cell range .......................................................................... 260

Naming cell ranges so that you can use them in formulas ...........261

Referring to cells in different worksheets.......................................264

Copying Formulas from Cell to Cell ...........................................................264

Detecting and Correcting Errors in Formulas ..........................................266

Correcting errors one at a time........................................................266

Running the error checker................................................................267

Tracing cell references ......................................................................268

Working with Functions ..............................................................................269

Using arguments in functions ...........................................................271

Entering a function in a formula ......................................................271

Chapter 4: Making a Worksheet Easier to Read and Understand...275

Laying Out a Worksheet .............................................................................275

Aligning numbers and text in columns and rows ..........................276

Inserting and deleting rows and columns.......................................278

Changing the size of columns and rows .........................................279

Decorating a Worksheet with Borders and Colors ..................................280

Cell styles for quickly formatting a worksheet ..............................281

Formatting cells with table styles ....................................................283

Slapping borders on worksheet cells .............................................. 284

Decorating worksheets with colors .................................................285

Getting Ready to Print a Worksheet ..........................................................285

Making a worksheet t on a page ....................................................286

Making a worksheet more presentable ...........................................289

Repeating row and column headings on each page ...................... 290

Chapter 5: Advanced Techniques for Analyzing Data .............293

Seeing What the Sparklines Say ................................................................. 293

Managing Information in Lists ...................................................................294

Sorting a list ........................................................................................295

Filtering a list ......................................................................................296

Forecasting with the Goal Seek Command ...............................................298

Office 2013 All-in-One For Dummies

xviii

Performing What-If Analyses with Data Tables .......................................299

Using a one-input table for analysis ................................................299

Using a two-input table for analysis ................................................301

Analyzing Data with Pivot Tables ..............................................................303

Creating a PivotTable ........................................................................ 303

Putting the nishing touches on a PivotTable ............................... 305

Book IV: PowerPoint 2013 ........................................ 307

Chapter 1: Getting Started in PowerPoint .......................309

Getting Acquainted with PowerPoint ........................................................310

A Brief Geography Lesson .......................................................................... 311

A Whirlwind Tour of PowerPoint ..............................................................312

Creating a New Presentation ......................................................................313

Advice for Building Persuasive Presentations .........................................316

Creating New Slides for Your Presentation ..............................................318

Inserting a new slide ..........................................................................319

Speed techniques for inserting slides ............................................. 319

Conjuring slides from Word document headings ..........................321

Selecting a different layout for a slide .............................................322

Getting a Better View of Your Work .......................................................... 323

Changing views ..................................................................................323

Looking at the different views ..........................................................323

Hiding and Displaying the SlidesPane and Notes Pane ..........................324

Selecting, Moving, and Deleting Slides .....................................................325

Selecting slides ...................................................................................325

Moving slides ......................................................................................325

Deleting slides ....................................................................................326

Putting Together a Photo Album ...............................................................326

Creating your photo album ..............................................................326

Putting on the nal touches .............................................................328

Editing a photo album ....................................................................... 329

Hidden Slides for All Contingencies .......................................................... 329

Hiding a slide ...................................................................................... 329

Showing a hidden slide during a presentation ...............................330

Chapter 2: Fashioning a Look for Your Presentation ..............331

Looking at Themes and Slide Backgrounds .............................................331

Choosing a Theme for Your Presentation ................................................ 334

Creating Slide Backgrounds on Your Own ...............................................334

Using a solid (or transparent) color for the slide background ....335

Creating a gradient color blend for slide backgrounds ................335

Placing a picture in the slide background ......................................337

Using a photo of your own for a slide background .......................338

Using a texture for a slide background ........................................... 340

剩余818页未读，继续阅读

lishuang0706

粉丝: 0
资源: 1

Office 2013速通指南：提升工作效率秘籍

快速入门Java编程：Java All-in-One For Dummies（第五版）精华指南

《走出软件作坊》- networking all-in-one for dummies 6th精华

VSTO For Dummies: 完整英文版PDF教程

For.Dummies.SQL.All.in.One.Desk.Reference.For.Dummies.Jul.2007.pdf

For.Dummies.iPad.All-in-One.For.Dummies.7th.Edition

For.Dummies.Linux.All-In-One.For.Dummies.6th.Edition

For.Dummies.Building.Web.Sites.All-in-One.For.Dummies.Jan.2009.part1.rar

For.Dummies.Building.Web.Sites.All-in-One.For.Dummies.Jan.2009.part3.rar

For.Dummies.Building.Web.Sites.All-in-One.For.Dummies.Jan.2009.part2.rar

For.Dummies.Java.All-In-One.Desk.Reference.For.Dummies.Apr.2005.eBook-DDU

最新资源