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

Office 2013 All-In-One Absolute Beginner's Guide: (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: 9780133391534
  • Publisher: Pearson Education (US)
  • Publisher Imprint: Addison Wesley
  • Language: English
  • Series Title: Absolute Beginner's Guide
  • ISBN-10: 0133391531
  • Publisher Date: 08 Aug 2013
  • Binding: Digital download
  • No of Pages: 800
  • Weight: 1 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: (Absolute Beginner's Guide)
Pearson Education (US) -
Office 2013 All-In-One Absolute Beginner's Guide: (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: (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