Office 2013 All-In-One Absolute Beginner's Guide - No experience necessary!

Make the most of Office 2013 -- without becoming 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!

List 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 ...

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.

Summary

Make the most of Office 2013–without becoming a technical expert! This book is the fastest way to create, edit, format, build, review, and share virtually any form of Office content! Even if you’ve never used Office before, you’ll learn how to do what you want, one incredibly clear and easy step at a time. Office has never, ever been this simple!
 
Who knew how simple Microsoft® Office 2013 could be?
 
This is the easiest, most practical beginner’s guide to using Microsoft’s incredibly powerful new Office 2013 productivity suite…simple, reliable instructions for doing all you really want to do with the brand-new versions of Word, Excel, PowerPoint, Outlook, and OneNote! Here’s a small sample of what you’ll learn:
 

• Explore Office 2013’s updated interface and most efficient shortcuts
• Use Microsoft Office on the Web and mobile devices
• Streamline Word document creation with templates, tables, and more
• Efficiently build and review longer documents–by yourself or with teams
• Quickly create reliable, sophisticated Excel workbooks
• Analyze and visualize Excel data with charts, sparklines, pivot tables, and slicers
• Create high-impact presentations with PowerPoint 2013’s newest tools
• Supercharge presentations with audio, video, animations, and transitions
• Set up email accounts and personalize Outlook to your own workstyle
• Manage your life with Outlook contacts, tasks, to-do lists, and notes
• Use Social Connector to simplify activities on Facebook, LinkedIn, and beyond
• Organize research more efficiently with OneNote notebooks
• Integrate text, links, files, media, screen clips, and handwriting into your OneNote notebooks
• And much more…

 
 

Product details

• Authors: Patrice Anne Rutledge, Patrice-Anne Rutledge
• Publisher: Que
• Languages: English
• Product format: Paperback / Softback
• Released: 01.09.2013
• EAN: 9780789751010
• ISBN: 978-0-7897-5101-0
• No. of pages: 704
• Dimensions: 180 mm x 230 mm x 1 mm
• Weight: 1206 g
• Series: Que; Que
• Subject: Natural sciences, medicine, IT, technology > IT, data processing > Application software