Home > Computing and Information Technology > Business applications > Integrated software packages > Office 2013 All-In-One Absolute Beginner's Guide
29%
Office 2013 All-In-One Absolute Beginner's Guide

Office 2013 All-In-One Absolute Beginner's Guide

          
5
4
3
2
1

Out of Stock


Premium quality
Premium quality
Bookswagon upholds the quality by delivering untarnished books. Quality, services and satisfaction are everything for us!
Easy Return
Easy return
Not satisfied with this product! Keep it in original condition and packaging to avail easy return policy.
Certified product
Certified product
First impression is the last impression! Address the book’s certification page, ISBN, publisher’s name, copyright page and print quality.
Secure Checkout
Secure checkout
Security at its finest! Login, browse, purchase and pay, every step is safe and secured.
Money back guarantee
Money-back guarantee:
It’s all about customers! For any kind of bad experience with the product, get your actual amount back after returning the product.
On time delivery
On-time delivery
At your doorstep on time! Get this book delivered without any delay.
Notify me when this book is in stock
Add to Wishlist

About the Book

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…    

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


Best Sellers


Product Details
  • ISBN-13: 9780789751010
  • Publisher: Pearson Education (US)
  • Publisher Imprint: Que Corporation,U.S.
  • Depth: 44
  • Height: 231 mm
  • No of Pages: 704
  • Series Title: Absolute Beginner's Guide
  • Sub Title: Absolute Beginner's Guide
  • Width: 180 mm
  • ISBN-10: 0789751011
  • Publisher Date: 22 Aug 2013
  • Binding: Paperback
  • Edition: Reprint
  • Language: English
  • Returnable: Y
  • Spine Width: 41 mm
  • Weight: 1208 gr


Similar Products

How would you rate your experience shopping for books on Bookswagon?

Add Photo
Add Photo

Customer Reviews

REVIEWS           
Click Here To Be The First to Review this Product
Office 2013 All-In-One Absolute Beginner's Guide
Pearson Education (US) -
Office 2013 All-In-One Absolute Beginner's Guide
Writing guidlines
We want to publish your review, so please:
  • keep your review on the product. Review's that defame author's character will be rejected.
  • Keep your review focused on the product.
  • Avoid writing about customer service. contact us instead if you have issue requiring immediate attention.
  • Refrain from mentioning competitors or the specific price you paid for the product.
  • Do not include any personally identifiable information, such as full names.

Office 2013 All-In-One Absolute Beginner's Guide

Required fields are marked with *

Review Title*
Review
    Add Photo Add up to 6 photos
    Would you recommend this product to a friend?
    Tag this Book
    Read more
    Does your review contain spoilers?
    What type of reader best describes you?
    I agree to the terms & conditions
    You may receive emails regarding this submission. Any emails will include the ability to opt-out of future communications.

    CUSTOMER RATINGS AND REVIEWS AND QUESTIONS AND ANSWERS TERMS OF USE

    These Terms of Use govern your conduct associated with the Customer Ratings and Reviews and/or Questions and Answers service offered by Bookswagon (the "CRR Service").


    By submitting any content to Bookswagon, you guarantee that:
    • You are the sole author and owner of the intellectual property rights in the content;
    • All "moral rights" that you may have in such content have been voluntarily waived by you;
    • All content that you post is accurate;
    • You are at least 13 years old;
    • Use of the content you supply does not violate these Terms of Use and will not cause injury to any person or entity.
    You further agree that you may not submit any content:
    • That is known by you to be false, inaccurate or misleading;
    • That infringes any third party's copyright, patent, trademark, trade secret or other proprietary rights or rights of publicity or privacy;
    • That violates any law, statute, ordinance or regulation (including, but not limited to, those governing, consumer protection, unfair competition, anti-discrimination or false advertising);
    • That is, or may reasonably be considered to be, defamatory, libelous, hateful, racially or religiously biased or offensive, unlawfully threatening or unlawfully harassing to any individual, partnership or corporation;
    • For which you were compensated or granted any consideration by any unapproved third party;
    • That includes any information that references other websites, addresses, email addresses, contact information or phone numbers;
    • That contains any computer viruses, worms or other potentially damaging computer programs or files.
    You agree to indemnify and hold Bookswagon (and its officers, directors, agents, subsidiaries, joint ventures, employees and third-party service providers, including but not limited to Bazaarvoice, Inc.), harmless from all claims, demands, and damages (actual and consequential) of every kind and nature, known and unknown including reasonable attorneys' fees, arising out of a breach of your representations and warranties set forth above, or your violation of any law or the rights of a third party.


    For any content that you submit, you grant Bookswagon a perpetual, irrevocable, royalty-free, transferable right and license to use, copy, modify, delete in its entirety, adapt, publish, translate, create derivative works from and/or sell, transfer, and/or distribute such content and/or incorporate such content into any form, medium or technology throughout the world without compensation to you. Additionally,  Bookswagon may transfer or share any personal information that you submit with its third-party service providers, including but not limited to Bazaarvoice, Inc. in accordance with  Privacy Policy


    All content that you submit may be used at Bookswagon's sole discretion. Bookswagon reserves the right to change, condense, withhold publication, remove or delete any content on Bookswagon's website that Bookswagon deems, in its sole discretion, to violate the content guidelines or any other provision of these Terms of Use.  Bookswagon does not guarantee that you will have any recourse through Bookswagon to edit or delete any content you have submitted. Ratings and written comments are generally posted within two to four business days. However, Bookswagon reserves the right to remove or to refuse to post any submission to the extent authorized by law. You acknowledge that you, not Bookswagon, are responsible for the contents of your submission. None of the content that you submit shall be subject to any obligation of confidence on the part of Bookswagon, its agents, subsidiaries, affiliates, partners or third party service providers (including but not limited to Bazaarvoice, Inc.)and their respective directors, officers and employees.

    Accept

    New Arrivals


    Inspired by your browsing history


    Your review has been submitted!

    You've already reviewed this product!
    ASK VIDYA