No Words Wasted Sale
 
 

Special Offers see all

Enter to WIN a $100 Credit

Subscribe to PowellsBooks.news
for a chance to win.
Privacy Policy

Visit our stores


    Recently Viewed clear list


    The Powell's Playlist | January 5, 2015

    Tim Johnston: IMG The Powell's Playlist: Songs for Not Sleeping by Tim Johnston



    I once told a medical-profession-type lady that I didn't sleep well, that I awoke all through the night and was awake for hours. "What do you do... Continue »

    spacer
Qualifying orders ship free.
$29.99
New Trade Paper
Ships in 1 to 3 days
Add to Wishlist
Qty Store Section
1 Beaverton COMP- WIN APPS A- Z
2 Burnside Microsoft Windows- Applications
3 Local Warehouse Software Engineering- Programming and Languages
14 Remote Warehouse Computers Reference- General

More copies of this ISBN

Office 2013 All-In-One Absolute Beginner's Guide (Absolute Beginner's Guides)

by

Office 2013 All-In-One Absolute Beginner's Guide (Absolute Beginner's Guides) Cover

 

Synopses & Reviews

Publisher Comments:

Make the most of Office 2013 — without needing to be a technical expert! Office 2013 All-In-One Absolute Beginner's Guide is the fastest way to get comfortable and productive with the newest versions of Excel, Word, PowerPoint, Outlook, and OneNote, use their powerful new tools, and extend them to the web and the latest mobile devices.

 

Whether you're new to Office or you're one of the millions who've used previous versions, this practical, approachable book will show you how to do exactly what you want, one incredibly clear and easy step at a time. World-renowned Office tutorial author Patrice-Anne Rutledge reveals Office 2013's power, helps you quickly master and customize its updated interface, and covers everything you need to know to create, edit, format, build, review, and share:

  • Documents
  • Workbooks
  • Presentations
  • Calendars
  • Email
  • Notes
  • Web content
  • And much more

You'll find easy, practical coverage of breakthrough Office 2013 features and tools, including its seamless support for social networks and cloud integration. If you’re new to Office, this is the perfect place to start; if you’re upgrading, Rutledge helps you quickly pinpoint what’s new and start using it to get more productive. Either way, you’ll learn exactly what you need to know — without any of the complexity you don’t need, or the theory you don’t care about!

About the Author

Patrice-Anne Rutledge is a business technology author and consultant who specializes in teaching others to maximize the power of new technologies. Patrice has used—and has trained others to use—Microsoft Office for many years. She is the author of numerous books about Office for Pearson Education, including Easy Office 2013 and PowerPoint 2013 Absolute Beginner’s Guide. She can be reached through her website at www.patricerutledge.com.

Table of Contents

Introduction ...............................................................................................................1

    How This Book Is Organized .................................................................................... 2

    Conventions Used in This Book ............................................................................... 2

I Introducing Microsoft Office 2013

1 Getting Started with Microsoft Office 2013 ......................................................3

    Exploring the Start Screen ........................................................................................ 4

    Setting Up Your Office Account .............................................................................. 5

    Using the Ribbon Tabs ............................................................................................. 6

    Using Backstage View ............................................................................................... 8

    Using Toolbars ........................................................................................................... 9

        Using the Quick Access Toolbar ......................................................................... 9

        Using the Mini Toolbar ......................................................................................10

    Using Task Panes .....................................................................................................10

    Getting Help ............................................................................................................11

2 Working with Office Applications .......................................................................13

    Working with Files ...................................................................................................14

        Creating a New File ...........................................................................................14

        Opening a File ....................................................................................................14

        Renaming a File ..................................................................................................15

        Saving a File .......................................................................................................16

        Closing a File ......................................................................................................17

        Deleting a File ...................................................................................................18

        Printing a File ......................................................................................................18

    Sharing Files .............................................................................................................19

        Preparing to Share Files ....................................................................................19

        Sharing Files with Others ...................................................................................21

        Sharing via a Link ...............................................................................................22

        Sharing on Social Networks ..............................................................................23

        Sharing via Email ................................................................................................24

    Exporting Files .........................................................................................................25

        Saving as a PDF or XPS Document ..................................................................25

        Changing to Another File Type ........................................................................27

    Customizing Office .................................................................................................28

        Customizing the Quick Access Toolbar ...........................................................28

        Customizing Office Options ..............................................................................29

        Setting File Properties .......................................................................................32

3 Working with Text .................................................................................................33

    Formatting Text .......................................................................................................34

        Enhancing Text ...................................................................................................34

        Using the Formatting Tools on the Home Tab ...............................................35

        Formatting Text with Options in the Font Dialog Box...................................36

        Formatting Text with Options in the Paragraph Dialog Box .........................38

        Formatting Text with the Mini Toolbar ............................................................39

    Using Bullets ............................................................................................................39

    Using Numbered Lists .............................................................................................40

    Using WordArt .........................................................................................................41

        Inserting WordArt ...............................................................................................42

        Formatting WordArt ...........................................................................................42

    Using Text Boxes .....................................................................................................43

        Inserting a Text Box ...........................................................................................44

    Moving and Resizing a Text Box ......................................................................44

        Formatting a Text Box .......................................................................................45

    Inserting Symbols and Equations ..........................................................................46

    Proofing Your Text ..................................................................................................47

        Setting Spelling Check Options .......................................................................47

        Checking Your Spelling .....................................................................................48

    Looking Up a Synonym in the Thesaurus .............................................................49

4 Working with Pictures ...........................................................................................51

    Using Pictures in Office ...........................................................................................52

    Inserting Pictures .....................................................................................................53

    Inserting Online Pictures .........................................................................................54

        Inserting Pictures from the Office.com Clip Art Collection ...........................54

        Inserting Pictures from the Bing Image Search...............................................55

        Inserting Pictures from Your SkyDrive Account ..............................................56

    Inserting Screenshots ..............................................................................................58

    Modifying Pictures ...................................................................................................58

        Adjusting Pictures ...............................................................................................59

        Applying Artistic Effects ....................................................................................61

        Compressing Pictures ........................................................................................61

        Changing to a Different Picture ........................................................................62

        Resetting a Picture .............................................................................................62

        Working with Picture Styles ...............................................................................63

        Arranging Pictures ..............................................................................................66

        Cropping Pictures ...............................................................................................66

        Modifying a Picture’s Height and Width .........................................................66

        Using the Format Picture Pane .........................................................................67

5 Working with Shapes and SmartArt ...................................................................69

    Inserting Shapes ......................................................................................................70

        Inserting Lines and Arrows ................................................................................71

        Inserting Rectangles and Ovals ........................................................................72

    Formatting Shapes Using the Drawing Tools – Format Tab ..............................72

        Working with Shape Quick Styles .....................................................................73

        Specifying Shape Fill Color ...............................................................................74

        Specifying Shape Outlines ................................................................................78

        Applying Shape Effects .....................................................................................79

        Editing Shapes ....................................................................................................80

        Merging Shapes .................................................................................................80

    Using the Format Shape Pane ...............................................................................81

    Working with SmartArt Graphics ...........................................................................82

        Inserting a SmartArt Graphic ............................................................................83

        Using SmartArt Design Tools ............................................................................85

        Formatting SmartArt Graphics ..........................................................................88

6 Using Microsoft Office on the Web and Mobile Devices ..............................91

    Using SkyDrive .........................................................................................................92

        Getting Started with SkyDrive...........................................................................92

        Uploading Files to SkyDrive ..............................................................................94

    Using SkyDrive Mobile Apps ..................................................................................94

    Using Office Web Apps ..........................................................................................95

        Creating a New File Using Office Web Apps .................................................95

        Exploring Office Web Apps ..............................................................................96

        Editing Files in Office Web Apps .....................................................................97

II Microsoft Word 2013

7 Word 2013 Basics ..................................................................................................99

    Exploring Word ......................................................................................................100

        Exploring Word 2013 New Features ..............................................................100

        Exploring Word File Types ..............................................................................101

    Starting a New Document ....................................................................................102

    Viewing Multiple Documents ...............................................................................104

8 Formatting Pages ................................................................................................ 107

    Setting Margins ......................................................................................................108

    Creating Columns ..................................................................................................110

    Changing Vertical Alignment ...............................................................................112

    Adding Headers and Footers to a Document ....................................................114

        Adding Headers and Footers .........................................................................115

        Adding Page Numbers ....................................................................................118

    Inserting Pages, Breaks, and Sections ................................................................119

        Inserting Pages .................................................................................................119

        Inserting Breaks ................................................................................................120

9 Using Templates ................................................................................................ 123

    Understanding Templates ....................................................................................124

    Applying a Template.............................................................................................124

    Finding More Templates ......................................................................................126

    Saving Templates ..................................................................................................127

10 Applying Advanced Formatting ....................................................................... 129

    Applying a Theme .................................................................................................130

    Applying Styles ......................................................................................................132

        Choosing Style Sets .........................................................................................135

        Assigning Styles ................................................................................................135

        Creating New Styles .........................................................................................136

    Adding Special Effects ..........................................................................................137

        Inserting Drop Caps .........................................................................................137

        Applying Text Effects .......................................................................................139

        Adding a Watermark ........................................................................................139

    Adding Borders and Shading...............................................................................142

        Adding Text Borders ........................................................................................142

        Adding Page Borders ......................................................................................143

        Adding Shading ................................................................................................144

    Adding Text with Quick Parts ..............................................................................145

        Inserting a Quick Part ......................................................................................146

        Creating Your Own Quick Parts ......................................................................147

11 Adding Tables and Charts ................................................................................. 149

    Inserting Tables .....................................................................................................150

        Inserting a Basic Table .....................................................................................150

        Inserting a Table Using the Insert Table Dialog Box ...................................152

        Inserting and Creating a Quick Table ............................................................153

        Drawing a Custom Table .................................................................................154

        Inserting an Excel Spreadsheet as a Table ....................................................156

    Selecting Table Parts ............................................................................................157

    Modifying Tables ...................................................................................................159

        Changing Column Widths and Row Heights ................................................159

        Adding and Deleting Columns and Rows .....................................................161

        Adding and Deleting Cells ..............................................................................163

        Merging and Splitting Table Cells ..................................................................164

        Changing Cell Alignment and Margins .........................................................165

        Repositioning and Resizing Tables .................................................................166

        Enhancing a Table with Table Styles and Borders .......................................168

    Inserting Charts ......................................................................................................170

        Understanding the Chart Types ......................................................................171

        Understanding Chart Parts ..............................................................................172

        Inserting a Chart ...............................................................................................173

        Entering Chart Data .........................................................................................175

        Editing Charts ...................................................................................................178

12 Printing Documents ............................................................................................ 183

    Previewing and Printing a Document ..................................................................184

        Previewing Pages .............................................................................................185

        Managing Print Settings ..................................................................................186

    Controlling Page Setup ........................................................................................188

    Printing Envelopes and Labels .............................................................................189

        Printing Envelopes ...........................................................................................189

        Printing Labels ..................................................................................................192

    Using Word’s Mail Merge Tool ............................................................................196

13 Working with Longer Documents .................................................................... 207

    Structuring Documents with Outline View ..........................................................208

    Inserting Footnotes and Endnotes ......................................................................212

    Adding Captions ...................................................................................................214

    Inserting Cross-References ...................................................................................216

    Creating an Index ..................................................................................................218

    Creating a Table of Contents ...............................................................................221

    Inserting Bookmarks ..............................................................................................223

    Navigating Long Documents with the Navigation Pane ...................................225

14 Collaborating, Reviewing, and Sharing Documents ..................................... 229

    Tracking and Reviewing Documents ...................................................................230

        Turning on Tracking .........................................................................................231

        Changing the Markup Display ........................................................................232

        Working with Comments .................................................................................235

        Reviewing Changes ..........................................................................................238

        Comparing Documents .........................................................................................239

    Editing Portable Document Format (PDF) Files .................................................241

    Sharing Documents with Others ..........................................................................241

III Microsoft Excel 2013

15 Excel 2013 Basics ................................................................................................ 243

    Exploring the Excel Window ................................................................................244

    Moving Around and Making Selections on a Sheet ..........................................247

        Keyboard Shortcuts for Quicker Navigation .................................................247

        Selecting a Range of Cells ..............................................................................248

    Using Templates to Quickly Create New Workbooks .......................................249

        Using Microsoft’s Online Templates ..............................................................249

        Saving a Template............................................................................................250

        Opening a Locally Saved Template to Enter Data .......................................250

    Working with Sheets and Tabs ............................................................................251

        Inserting a New Sheet .....................................................................................251

        Activating Another Sheet ................................................................................252

        Selecting Multiple Sheets ................................................................................252

        Deleting a Sheet ...............................................................................................252

        Moving or Copying Sheets Within the Same Workbook .............................253

        Moving or Copying Sheets Between Workbooks .........................................253

        Renaming a Sheet ............................................................................................254

        Coloring a Sheet Tab .......................................................................................254

    Working with Rows and Columns ........................................................................254

        Selecting an Entire Row or Column ...............................................................255

        Inserting an Entire Row and Column .............................................................255

        Deleting an Entire Row and Column..............................................................256

        Moving Entire Rows and Columns .................................................................256

    Working with Cells ................................................................................................257

        Selecting a Cell Using the Name Box ............................................................257

        Selecting Noncontiguous Cells and Ranges .................................................258

        Inserting Cells and Ranges ..............................................................................258

        Deleting Cells and Ranges ..............................................................................259

        Moving Cells and Ranges ................................................................................259

16 Entering Sheet Data ........................................................................................... 261

    Understanding Excel Data Types ........................................................................262

    Entering Data .........................................................................................................262

        Entering Different Types of Data into a Cell .................................................262

        Using Copy, Cut, Paste, Paste Special to Enter Data ..................................264

        Using Text to Columns to Separate Data in a Single Column ....................266

        Using Series to Quickly Fill a Range ..............................................................269

    Editing and Managing Data .................................................................................270

        Editing Data ......................................................................................................270

        Working with Tables ........................................................................................272

        Fixing Numbers Stored as Text ......................................................................275

        Finding Data on Your Sheet ............................................................................277

        Using Data Validation to Limit Data Entry in a Cell .....................................279

17 Formatting Sheets and Cells ............................................................................. 283

    Adjusting Row Heights and Column Widths ......................................................284

    Aligning Text in a Cell ..........................................................................................285

        Merging Two or More Cells ............................................................................285

        Centering Text Across a Selection .................................................................286

        Wrapping Text in a Cell to the Next Line .....................................................287

        Indenting Cell Contents ..................................................................................287

        Changing Text Orientation .............................................................................288

    Formatting Numbers .............................................................................................289

        Applying Number Formats with the Format Cells Dialog Box ..................290

    Creating Hyperlinks ...............................................................................................295

    Applying Conditional Formatting ........................................................................296

    Using Cell Styles to Quickly Apply Formatting ..................................................297

    Using Themes to Ensure Uniformity in Design ..................................................298

        Applying a New Theme ...................................................................................298

        Creating a New Theme ...................................................................................298

        Sharing a Theme ..............................................................................................300

18 Using Formulas .................................................................................................... 301

    Entering a Formula into a Cell .............................................................................302

        Three Ways of Entering a Formula’s Cell References ..................................303

        Relative Versus Absolute Formulas ................................................................303

        Using a Cell on Another Sheet in a Formula .................................................304

        Using F4 to Change the Cell Referencing .....................................................305

        Using Mathematical Operators .......................................................................306

        Using Names to Simplify References .............................................................307

        Inserting Formulas into Tables ........................................................................310

        Converting Formulas to Values .......................................................................312

    Copying a Formula to Another Cell ....................................................................313

        Copying a Formula Using the Fill Handle .....................................................313

        Copying a Formula by Using Ctrl+Enter .......................................................314

        Copying Formulas Rapidly Down a Column .................................................314

19 Using Functions ................................................................................................... 317

    Understanding Functions ......................................................................................318

        Exploring a Function ........................................................................................318

        Finding Functions .............................................................................................318

    Entering Functions Using the Function Arguments Dialog Box .......................319

    Entering Functions Using In-Cell Tips .................................................................321

    Using the AutoSum Button...................................................................................322

        SUM Rows and Columns at the Same Time ..................................................323

        Other Auto Functions ......................................................................................324

        Using the Status Bar for Quick Calculation Results ......................................324

        Using Quick Analysis for Column Totals ........................................................325

20 Sorting Data ......................................................................................................... 327

    Sorting Excel Data .................................................................................................328

        Preparing Data ..................................................................................................328

        Opening the Sort Dialog Box .........................................................................328

        Sorting by Values .............................................................................................328

        Sorting by Color or Icon ..................................................................................330

    Performing a Quick Sort .......................................................................................332

        Using the Quick Sort Buttons..........................................................................332

        Quick Sorting Multiple Columns.....................................................................333

    Fixing Sort Problems .............................................................................................333

21 Filtering and Consolidating Data ..................................................................... 335

    Filtering Data .........................................................................................................336

        Applying a Filter to a Data Set .......................................................................336

    Managing Filters ....................................................................................................337

        Turning Filtering On for One Column ...........................................................337

        Filtering for Listed Items ..................................................................................338

        Filtering the Grouped Dates Listing ...............................................................339

        Using Text, Number, and Date Special Filters ..............................................340

        Filtering by Color or Icon ................................................................................341

        Filtering by Selection .......................................................................................342

        Allowing Filtering on a Protected Sheet ........................................................343

        Clearing a Filter ................................................................................................344

        Reapplying a Filter ...........................................................................................344

        Removing Duplicates from a Data Set ...........................................................345

    Consolidating Data ...............................................................................................346

22 Preparing Workbooks for Distribution and Printing ................................... 349

    Preparing to Print or Share Your Workbook .....................................................350

        Using Cell Comments to Add Notes to Cells ...............................................350

        Allowing Multiple Users to Edit a Workbook at the Same Time ................353

        Hiding and Unhiding Sheets ...........................................................................353

        Locking Rows or Columns in Place .................................................................353

        Protecting the Data on a Sheet ......................................................................355

    Configuring Page Setup .......................................................................................355

        Repeating Rows or Columns on Each Printed Page ....................................356

        Scaling Your Data to Fit a Printed Page ........................................................356

        Creating a Custom Header or Footer ............................................................357

        Adding an Image to the Header and Footer ................................................358

        Adding Page Numbering to the Header and Footer ...................................359

        Using Page Break Preview to Set Page Breaks .............................................359

23 Creating Subtotals and Grouping Data .......................................................... 361

    Creating Subtotals .................................................................................................362

        Using the SUBTOTAL Function .......................................................................362

        Summarizing Data Using the Subtotal Tool ..................................................363

        Copying the Subtotals to a New Location ....................................................366

        Formatting the Subtotals .................................................................................367

        Subtotaling by Multiple Columns ...................................................................367

        Sorting Subtotals ..............................................................................................368

        Adding Space Between Subtotaled Groups .................................................369

    Grouping and Outlining Rows and Columns .....................................................370

24 Creating Charts and Sparklines ........................................................................ 373

    Creating a Chart ....................................................................................................374

        Preparing Data ..................................................................................................374

        Elements of a Chart .........................................................................................374

        Types of Charts .................................................................................................376

        Adding a Chart to a Sheet ..............................................................................378

    Modifying Charts ...................................................................................................380

        Adding, Removing, and Formatting Chart Elements ...................................380

        Editing and Formatting a Chart Title .............................................................381

        Changing the Display Units in an Axis ...........................................................382

        Applying Chart Styles and Colors ..................................................................382

        Applying Chart Layouts ...................................................................................383

        Moving or Resizing a Chart .............................................................................384

        Switching Rows and Columns .........................................................................384

        Changing an Existing Chart’s Type ................................................................384

        Updating Chart Data ........................................................................................384

    Adding Sparklines to Data ...................................................................................385

        Adding Points to a Sparkline ..........................................................................386

        Spacing Markers in a Sparkline .......................................................................387

        Deleting Sparklines ..........................................................................................388

25 Creating Pivot Tables and Slicers .................................................................... 389

    Creating a Pivot Table ..........................................................................................390

        Preparing Data for Use in a Pivot Table ........................................................390

        Pivot Table Compatibility ................................................................................391

        Pivot Table Field List ........................................................................................391

        Using the Quick Analysis Tool ........................................................................392

        Viewing Recommended Pivot Tables ............................................................393

        Creating a Pivot Table from Scratch ..............................................................394

    Modifying a Pivot Table ........................................................................................397

        Removing a Field..............................................................................................397

        Renaming a Field..............................................................................................397

        Changing the Calculation Type of a Field Value ..........................................397

        Changing How a Pivot Table Appears on a Sheet .......................................398

        Sorting Pivot Tables ........................................................................................398

    Creating Slicers ......................................................................................................399

IV Microsoft PowerPoint 2013

26 PowerPoint 2013 Basics .................................................................................... 401

    Exploring PowerPoint ..........................................................................................402

        Exploring New PowerPoint 2013 Features ....................................................402

        Understanding PowerPoint Presentations .....................................................403

        Understanding PowerPoint Views ...................................................................406

        Exploring PowerPoint File Formats ................................................................408

    Creating a Presentation ........................................................................................408

        Creating a Presentation with a Theme ..........................................................409

        Creating a Presentation from an Online Template or Theme .....................411

        Creating a Presentation from Scratch ............................................................413

    Adding Slides to Your Presentation ....................................................................413

    Adding Sections to Your Presentation ................................................................414

        Collapsing and Expanding Sections ...............................................................416

        Removing Sections ...........................................................................................416

27 Customizing Themes and Backgrounds .......................................................... 417

    Applying a New Theme to Your Presentation ...................................................418

    Applying Multiple Themes to a Single Presentation .........................................419

    Applying a New Theme Variant ...........................................................................420

    Formatting Presentation Backgrounds ................................................................420

        Formatting Your Presentation’s Background ................................................420

        Omitting Background Graphics ......................................................................422

        Resetting a Background ..................................................................................422

    Customizing Themes .............................................................................................422

        Customizing Theme Color Schemes ..............................................................422

        Customizing Theme Fonts ...............................................................................425

        Customizing Theme Effects .............................................................................427

        Working with Custom Themes ........................................................................428

28 Formatting and Organizing Objects, Slides, and Presentations ................ 429

    Manipulating Objects ............................................................................................430

        Cutting an Object .............................................................................................430

        Copying an Object ...........................................................................................430

        Pasting an Object .............................................................................................430

        Moving and Resizing an Object......................................................................432

    Arranging Objects .................................................................................................432

        Layering Objects ..............................................................................................432

        Grouping Objects .............................................................................................433

        Aligning Objects ...............................................................................................434

        Rotating and Flipping Objects ........................................................................435

        Using the Selection Pane.................................................................................435

    Working with Gridlines and Guides ....................................................................436

        Using Smart Guides .........................................................................................436

        Using the Grid and Guides Dialog Box .........................................................437

    Organizing Slides ..................................................................................................437

        Using Slide Sorter View ...................................................................................437

        Copying and Moving Slides from One Presentation to Another ................438

        Deleting Slides ..................................................................................................440

        Changing Slide Size .........................................................................................440

29 Adding Tables to a Presentation .................................................................... 441

    Understanding PowerPoint Tables ......................................................................442

    Inserting a Table ....................................................................................................442

    Drawing Custom Tables .......................................................................................444

    Inserting Excel Spreadsheets ...............................................................................444

    Formatting Tables .................................................................................................445

        Setting Table Style Options ............................................................................446

        Applying a Table Style .....................................................................................447

        Creating a Border .............................................................................................448

        Setting Table Fill Color ....................................................................................448

        Applying Table Effects .....................................................................................449

        Working with Columns and Rows ...................................................................449

        Merging and Splitting Cells ............................................................................450

        Specifying Other Layout Options ...................................................................451

        Adding Bulleted and Numbered Lists Within Tables ...................................451

    Deleting Tables and Table Contents ..................................................................452

30 Outlining Presentations ..................................................................................... 453

    Creating an Effective Presentation Outline ........................................................454

    Using Outline View ................................................................................................454

    Modifying Your Outline ........................................................................................455

        Promoting and Demoting Outline Points ......................................................456

        Moving Outline Points Up and Down ............................................................458

        Collapsing and Expanding Outline Points .....................................................458

        Showing Slide Formatting ...............................................................................458

    Inserting an Outline from Another Application ..................................................459

31 Reviewing Presentations ................................................................................... 461

    Understanding PowerPoint Reviewing Tools .....................................................462

    Working with Comments ......................................................................................462

        Adding Comments to Slides ...........................................................................463

        Reviewing Comments ......................................................................................464

        Editing and Replying to Comments ...............................................................464

        Deleting Comments .........................................................................................465

        Hiding Comments ............................................................................................466

    Comparing Presentations .....................................................................................466

        Working with the Revisions Pane ...................................................................467

        Viewing Revisions .............................................................................................469

        Accepting Changes ..........................................................................................469

        Rejecting Changes ...........................................................................................470

        Ending the Review ...........................................................................................470

32 Working with Charts........................................................................................... 471

    Understanding Charts ...........................................................................................472

        Understanding Chart Terminology .................................................................473

        Understanding Chart Types ............................................................................473

    Inserting Charts ......................................................................................................474

    Inserting a Chart from Excel .................................................................................477

    Modifying and Formatting Charts .......................................................................478

        Displaying, Hiding, and Modifying Chart Elements .....................................478

        Modifying Chart Design ..................................................................................480

        Formatting Charts ............................................................................................481

        Applying Chart Filters ......................................................................................482

        Saving Your Chart as a Template ...................................................................483

33 Working with Audio and Video ........................................................................ 485

    Understanding Audio and Video Formats ..........................................................486

    Inserting Audio Clips .............................................................................................486

        Inserting Online Audio .....................................................................................487

        Inserting Audio Clips from Your Computer ...................................................488

        Recording Audio Clips .....................................................................................489

        Deleting Audio Clips ........................................................................................490

    Inserting Video Clips .............................................................................................490

        Inserting Online Video .....................................................................................490

        Inserting a Video Clip from Your Computer .................................................491

        Deleting a Video Clip ......................................................................................493

    Formatting Audio and Video Clips ......................................................................493

        Adjusting Audio and Video Clips ...................................................................493

        Specifying a Video Poster Frame ...................................................................494

        Working with Audio and Video Styles ...........................................................494

        Arranging Audio and Video Clips ..................................................................495

        Resizing Audio and Video Clips .....................................................................495

    Specifying Audio and Video Playback Options .................................................495

        Playing a Clip ....................................................................................................496

        Adding a Bookmark .........................................................................................496

        Editing Audio and Video Clips .......................................................................497

        Specifying Audio and Video Options ............................................................498

    Compressing Media Files for Improved Performance .......................................498

    Creating Videos from PowerPoint Presentations ...............................................499

34 Working with Animation and Transitions ....................................................... 503

    Understanding Animation and Transitions .........................................................504

    Setting Slide Transitions .......................................................................................504

    Applying Animation to Objects ...........................................................................506

    Customizing Animations on the Animation Pane ..............................................508

        Setting Additional Effects ................................................................................509

        Setting Timings .................................................................................................510

        Animating Charts ..............................................................................................510

        Animating Text .................................................................................................511

        Animating SmartArt Graphics .........................................................................512

        Animating Audio and Video Files ...................................................................512

        Viewing the Advanced Timeline .....................................................................513

    Managing Animations ...........................................................................................513

        Reordering Animations ....................................................................................513

        Modifying Animations ......................................................................................513

        Removing Animations ......................................................................................513

        Reusing Animations with the Animation Painter ...........................................514

35 Working with Slide Masters .............................................................................. 515

    Modifying the Slide Master ..................................................................................516

    Adding a Slide Master ..........................................................................................517

    Creating a Custom Layout ....................................................................................518

    Managing Slide Masters .......................................................................................520

        Renaming a Slide Master or Layout ...............................................................520

        Duplicating a Slide Master or Layout .............................................................520

        Deleting a Slide Master or Layout ..................................................................521

        Preserving a Slide Master ................................................................................521

        Applying a Theme to a Slide Master .............................................................521

        Modifying the Handout and Notes Masters ..................................................522

36 Creating and Printing Presentation Materials ............................................... 525

    Understanding PowerPoint Printing Options .....................................................526

    Printing PowerPoint Presentations .......................................................................527

        Preparing to Print .............................................................................................527

        Customizing Headers and Footers .................................................................530

        Previewing a PowerPoint Presentation ..........................................................531

        Printing Your Presentation ...............................................................................532

        Creating Handouts in Microsoft Word ................................................................532

37 Presenting a Slide Show .................................................................................... 535

    Exploring the Slide Show Tab ..............................................................................536

    Setting Up a Show .................................................................................................536

    Rehearsing Timings ...............................................................................................538

        Using Timings ...................................................................................................539

        Deleting Timings ..............................................................................................539

    Recording Voice Narrations .................................................................................539

        Rerecording Narrations ....................................................................................540

        Playing Narrations ............................................................................................541

        Deleting Narrations ..........................................................................................541

    Creating Custom Shows .......................................................................................541

    Viewing Your Show................................................................................................543

        Navigating a Show Full Screen .......................................................................543

        Setting Pointer Options ...................................................................................545

        Using the Onscreen Pen to Mark Your Presentation ....................................546

    Presenting Online ..................................................................................................547

    Exploring Presenter View ......................................................................................548

    Packaging a Presentation onto a CD ..................................................................550

V Microsoft Outlook 2013

38 Outlook 2013 Basics ........................................................................................... 553

    Getting Started with Outlook ...............................................................................554

        Exploring Outlook ............................................................................................554

        Exploring Outlook 2013 New Features .........................................................556

    Starting and Exiting Outlook ................................................................................557

    Familiarizing Yourself with the Program Window ..............................................558

39 Setting Up Accounts and Personalizing Outlook .......................................... 561

    Understanding Email Services and Internet Access ..........................................562

    Adding Email Accounts to Outlook.....................................................................564

        Automatically Configuring an Account ..........................................................564

        Manually Configuring an Account ..................................................................566

        Editing Your Email Accounts ...........................................................................568

    Working with Outlook Panes ................................................................................569

        Working with the Folder Pane ........................................................................570

        Working with the Reading Pane .....................................................................572

        Working with the To-Do Bar and Peeks ........................................................572

40 Performing Basic Email Tasks ........................................................................... 575

    Composing and Sending Messages ....................................................................576

    Reading and Replying to Messages ....................................................................578

        Checking for New Messages ..........................................................................581

        Replying to a Message ....................................................................................582

        Forwarding a Message ....................................................................................584

        Deleting a Message .........................................................................................585

    Saving Messages ...................................................................................................585

        Saving a Draft Message ...................................................................................586

        Saving a Message File .....................................................................................587

    Working with File Attachments ............................................................................588

        Attaching a File.................................................................................................588

        Opening an Attachment ..................................................................................589

    Using Simple Message Tools ...............................................................................590

        Marking Messages as Read or Unread ..........................................................591

        Flagging Messages ..........................................................................................592

        Categorizing Messages ...................................................................................593

41 Managing Email .................................................................................................. 595

    Organizing Messages with Folders .....................................................................596

        Making a New Email Folder ............................................................................596

        Moving a Message to Your New Folder ........................................................598

        Working with Folder Contents ........................................................................598

    Routing Messages with Quick Steps ...................................................................598

    Managing Incoming Messages with Rules ........................................................602

    Controlling Junk Email ..........................................................................................603

    Archiving Messages ..............................................................................................605

        Manually Archive Messages ............................................................................606

        Setting Up Automatic Archiving .....................................................................607

42 Working with Advanced Email Features ........................................................ 609

    Setting Priority and Sensitivity Options ..............................................................610

    Using Quick Parts ..................................................................................................611

    Adding Signatures .................................................................................................612

    Controlling Replies, Forwarding, and Receipts ..................................................614

    Working with RSS Feeds .......................................................................................616

43 Using the Calendar ............................................................................................. 619

    Displaying Your Calendar ....................................................................................620

    Recording Events and Appointments .................................................................622

        Recording Events .............................................................................................622

        Recording Appointments ...............................................................................627

        Setting Reminders ............................................................................................630

    Setting Up Meetings .............................................................................................631

        Sending an Invite ..............................................................................................631

        Tracking Invites .................................................................................................632

    Sharing Your Calendar .........................................................................................634

44 Working with Contacts ...................................................................................... 637

    Creating Contacts ..................................................................................................638

        Creating a New Contact in a Contact Form ..................................................638

        Creating a New Contact from an Email Message ........................................640

        Creating a New Contact from the Same Company .....................................642

    Working with Contact Groups .............................................................................642

        Creating a Contact Group ..............................................................................642

        Creating a Contact Group from a List ...........................................................643

        Using a Contact Group ....................................................................................643

    Managing Your Contacts ......................................................................................644

45 Working with Tasks and To-Do Lists ............................................................... 647

    Creating Tasks ......................................................................................................648

        Entering Task Details .......................................................................................649

        Creating Recurring Tasks .................................................................................649

    Completing Tasks ..................................................................................................650

    Using Task Requests .............................................................................................651

        Creating a Task Request ..................................................................................652

        Accepting or Declining a Task Request .........................................................653

    Viewing Tasks .......................................................................................................653

    Creating To-Do Items ...........................................................................................655

46 Using Social Connector ..................................................................................... 657

    Configuring the Social Connector ......................................................................658

        Setting Up Social Networking Accounts ........................................................659

        Turning Off Contact Photos ............................................................................660

        Showing or Hiding the Social Connector Pane.............................................660

    Managing Social Connector Security ..................................................................661

        Managing Facebook Security .........................................................................661

        Who Sees Your Photo and Your People Pane Content? ............................662

47 Synchronizing and Sharing Outlook Data ...................................................... 663

    Sharing Calendar and Contacts ...........................................................................664

        Syncing with Smartphones and Tablets .........................................................664

        Sharing with a Second Computer ..................................................................665

        Using Outlook.com to Share Calendar and Contacts ..................................666

        Moving Data to the Microsoft Account Data File .........................................668

    Using Contacts in Other Programs ......................................................................668

48 Using Color Categories ...................................................................................... 669

    Assigning Color Categories to Outlook Items ...................................................670

        Using the Quick Click Category......................................................................671

        Creating Additional Color Categories ...........................................................672

    Managing Color Categories .................................................................................674

        Upgrading to Color Categories .....................................................................674

        Sharing Color Categories ...............................................................................675

        Removing Categories ......................................................................................675

49 Working with Notes .......................................................................................... 677

    Exploring Outlook Notes ......................................................................................678

    Creating a Note .....................................................................................................678

    Emailing Notes ......................................................................................................679

    Organizing Your Notes .........................................................................................680

50 Using Folders ....................................................................................................... 681

    Creating New Folders ...........................................................................................682

    Managing Folders .................................................................................................683

51 Using Search ........................................................................................................ 685

    Using Instant Search ............................................................................................686

        Using Instant Search Queries ..........................................................................686

        Using Partial Word Searches ...........................................................................687

    Finding Related Messages ...................................................................................688

    Searching on the People Pane .............................................................................688

    Creating Search Folders .......................................................................................689

52 Working with Views ............................................................................................ 691

    Managing Views ...................................................................................................692

        Changing Views ................................................................................................692

        Applying Views to Folders ..............................................................................693

        Resetting Views ................................................................................................694

        Copying Views ..................................................................................................694

    Creating Custom Views ........................................................................................694

    Using Conditional Formatting ..............................................................................696

VI Microsoft OneNote 2013

53 OneNote 2013 Basics ......................................................................................... 699

    Creating a New Notebook ...................................................................................700

        Adding Notes to Your Notebook ...................................................................702

        Formatting Notes .............................................................................................702

        Applying Text Styles ........................................................................................703

        Saving Notebooks ............................................................................................703

    Working with Sections ..........................................................................................703

        Creating a New Section ...................................................................................703

        Modifying Sections ...........................................................................................704

    Working with Pages ..............................................................................................705

        Inserting a New Page .......................................................................................705

        Inserting a Page Based on a Template ..........................................................705

        Modifying Pages ...............................................................................................706

    Working with Tags .................................................................................................708

        Applying a Tag .................................................................................................708

        Removing a Tag ..............................................................................................708

        Creating Custom Tags ....................................................................................709

        Finding Tags .....................................................................................................710

54 Inserting Notebook Content............................................................................. 711

    Inserting Files .........................................................................................................712

        Attaching a File.................................................................................................712

        Inserting an Excel Spreadsheet ......................................................................713

    Inserting Images ...................................................................................................714

    Inserting Links ........................................................................................................715

    Recording Audio and Video .................................................................................716

        Recording an Audio Clip .................................................................................716

        Recording a Video Clip....................................................................................717

    Inserting Other Notebook Content .....................................................................718

        Inserting Extra Space .......................................................................................718

        Inserting a Table ...............................................................................................719

        Inserting a Timestamp .....................................................................................720

        Inserting Symbols and Equations ...................................................................721

    Using OneNote Drawing Tools ............................................................................721

        Inserting a Drawing ..........................................................................................721

        Erasing a Drawing ............................................................................................723

55 Viewing and Managing Notebooks ................................................................. 725

    Displaying Full Page View ....................................................................................726

    Docking OneNote to Your Desktop ....................................................................726

    Using Linked Note Taking ....................................................................................727

    Setting Up OneNote Pages .................................................................................728

    Working with Microsoft Outlook ..........................................................................729

        Emailing a Page ................................................................................................729

        Sending a Task to Outlook..............................................................................730

    Using the Send to OneNote Tool .......................................................................731

        Sending a Screen Clipping to OneNote .......................................................731

        Sending Content to OneNote ........................................................................733

        Creating a Quick Note .....................................................................................733

    Protecting Notebook Sections with a Password ................................................734

    Viewing Notebook History ..................................................................................736

TOC, 978789751010, 7/24/2013

Product Details

ISBN:
9780789751010
Author:
Rutledge, Patrice Anne
Publisher:
Que
Author:
Rutledge, Patrice-Anne
Subject:
Software Engineering - Programming and Languages
Subject:
Business Software - General
Subject:
Office 2013; Excel 2013; Word 2013; PowerPoint 2013; Outlook 2013; OneNote 2013; Microsoft Office easy; Microsoft Office beginner; Microsoft Office upgrade; Microsoft Office tips
Copyright:
Edition Description:
Trade paper
Series:
Absolute Beginner's Guide
Publication Date:
20130807
Binding:
TRADE PAPER
Language:
English
Pages:
704
Dimensions:
9.12 x 6.97 x 1.633 in 1193 gr

Related Subjects

Business » Computers
Computers and Internet » Operating Systems » Microsoft Windows » Applications
Computers and Internet » Operating Systems » Microsoft Windows » Windows 95 » General
Computers and Internet » Personal Computers » Desktop Applications » Suites
Computers and Internet » Software Engineering » Programming and Languages

Office 2013 All-In-One Absolute Beginner's Guide (Absolute Beginner's Guides) New Trade Paper
0 stars - 0 reviews
$29.99 In Stock
Product details 704 pages Que - English 9780789751010 Reviews:
spacer
spacer
  • back to top

FOLLOW US ON...

     
Powell's City of Books is an independent bookstore in Portland, Oregon, that fills a whole city block with more than a million new, used, and out of print books. Shop those shelves — plus literally millions more books, DVDs, and gifts — here at Powells.com.