You are previewing Office 2013 Digital Classroom.
O'Reilly logo
Office 2013 Digital Classroom

Book Description

This complete training package makes learning the new Office 2013 even easier!

Featuring both a video training DVD and a full-color book, this training package is like having your own personal instructor guiding you through each lesson of learning Office 2013, all while you work at your own pace. The self-paced lessons allow you to discover the new features and capabilities of the new Office suite.

Each lesson includes step-by-step instructions and lesson files, and provides valuable video tutorials that complement what you're learning and clearly demonstrate how to do tasks. This essential training package takes you well beyond the basics in a series of short, easy-to-absorb lessons.

  • Takes you from the basics through intermediate level topics and helps you find the information you need in a clear, approachable manner

  • Walks you through numerous lessons, each consisting of easy-to-follow, step-by-step instructions in full color that make each task less intimidating

  • Covers exciting new features of Office 2013 applications: Word, Excel, PowerPoint, Outlook, and Publisher

  • Features a companion DVD that includes lesson files and video tutorials for a complete training experience

  • Shares additional resources available on companion website: www.digitalclassroombooks.com

  • This all-in-one, value-packed combo teaches you all you need to know to get confidently up and running with the new Office 2013 suite!

    Table of Contents

    1. Contents
    2. Starting up
      1. About Microsoft Office 2013 Digital Classroom
      2. Prerequisites
      3. System requirements
      4. Fonts used in this book
      5. Loading lesson files
      6. Video tutorials
      7. Additional resources
      8. On-demand video training from the authors
      9. Training from the Authors
      10. Resources for educators
    3. Word Lesson 1: Microsoft Word 2013 Jumpstart
      1. Starting up
      2. The project
      3. Interface conventions
      4. Working with words
      5. Text and fields
      6. Applying styles to text
      7. Your document’s look and feel
      8. Working with themes, style sets, and color schemes
      9. Working with images and video
      10. Styling an image
      11. Working with online images and videos
      12. Different views of your document
      13. Collapsing document sections
      14. Working with Word’s windows
      15. Collaboration and tracking changes
      16. Communicating with colleagues in comments
      17. Save always
      18. Self study
      19. Review
      20. Questions
      21. Answers
    4. Word Lesson 2: Getting Started with Word 2013
      1. Starting up
      2. The Word 2013 interface
      3. The Start screen and template gallery
      4. Opening a document
      5. The Ribbon
      6. Customizing the Ribbon
      7. The Quick Access toolbar
      8. The Status bar
      9. The Navigation pane
      10. Different viewing modes
      11. Laying out the page
      12. Page size, margins, and marginalia
      13. Headers and footers
      14. Windows and panes: splitting your document view
      15. Self study
      16. Review
      17. Questions
      18. Answers
    5. Word Lesson 3: Beginning Text and Layout Operations
      1. Starting up
      2. Working with text in Word
      3. Paragraph and character formatting
      4. Spacing
      5. Styles, themes, and live preview
      6. Cut, copy, and paste
      7. Paste options
      8. Copying a look: Format Painter
      9. A paste to fit every taste
      10. Working with columns
      11. Text boxes and images
      12. Placing text boxes and images
      13. Inserting an object directly into a paragraph
      14. Self study
      15. Review
      16. Questions
      17. Answers
    6. Word Lesson 4: Structuring Complex Documents
      1. Starting up
      2. Documents are data
      3. Headings: logical document divisions
      4. Text folding
      5. Sorting sections alphabetically
      6. Building an outline with headings
      7. Working in outline view
      8. Captions
      9. Tagging images with captions
      10. Working with fields
      11. Viewing field codes
      12. Setting and accessing document properties
      13. Adding a cover page
      14. Page and section breaks
      15. Seeing breaks and other hidden characters
      16. Section breaks
      17. Cross-references
      18. Footnotes and endnotes
      19. Adding and deleting notes
      20. Endnotes, briefly
      21. Adding a table of contents
      22. From headings to table of contents
      23. Building a custom table of contents
      24. Using table fields in your TOC
      25. Adding a table of figures
      26. Self study
      27. Review
      28. Questions
      29. Answers
    7. Word Lesson 5: Working with Tables
      1. Starting up
      2. The uses of tables
      3. Table basics
      4. Inserting and navigating tables
      5. Split cells and table styles
      6. Working with text in and around tables
      7. Text alignment and merged cells
      8. Merging cells with the Eraser tool
      9. Presenting and sorting tabular data
      10. Adding, deleting, and moving columns and rows
      11. Sorting data in a table
      12. Designing tables
      13. Table style options
      14. Applying a table style
      15. Setting cell and table borders
      16. Using the Border Painter tool
      17. Editing cell contents
      18. Cell text and manual cell sizing
      19. Using AutoFit and Fit Text
      20. Images in tables
      21. Self study
      22. Review
      23. Questions
      24. Answers
    8. Word Lesson 6: Beyond Word: Linking and Collaborating
      1. Starting up
      2. Group work and Groupware
      3. Tracking your edits
      4. How Word displays edits
      5. Tracking new changes
      6. Controlling the markup that you see
      7. The Reviewing pane
      8. Editing and collaborating
      9. Accepting and rejecting changes
      10. Comments and conversations
      11. Taking a comment thread to e-mail or instant messenger
      12. Access control
      13. Blocking certain edits
      14. Restricting editing
      15. Comparing and combining documents
      16. Comparing documents
      17. Combining documents
      18. Embedding and linking objects
      19. Linking to an Excel spreadsheet
      20. Unlinking a linked object
      21. Self study
      22. Review
      23. Questions
      24. Answers
    9. Word Lesson 7: Creating Mail Merges
      1. Starting up
      2. Mail merges
      3. Linking to a data source
      4. Data sources for mail merges
      5. Inserting merge fields into a document
      6. Inserting simple merge fields
      7. Using if-then conditional fields
      8. Previewing a merge
      9. Conditionally inserting an image
      10. Finalizing the merge
      11. Self study
      12. Review
      13. Questions
      14. Answers
    10. Word Lesson 8: Blogging in Word
      1. Starting up
      2. How blogs work
      3. Setting up a blog account
      4. Creating a blog post
      5. Setting your blog post’s categories
      6. Uploading posts and drafts
      7. Editing posts stored on the server
      8. Self study
      9. Review
      10. Questions
      11. Answers
    11. Excel Lesson 1: Getting Started with Excel 2013
      1. Starting up
      2. Getting to know the workspace
      3. Getting to know the cell pointer
      4. Using the Ribbon
      5. Exploring the Status bar
      6. Using the Quick Access Toolbar
      7. Using the Formula bar
      8. Moving around the worksheet
      9. Exploring what’s new in Excel 2013
      10. Self study
      11. Review
      12. Questions
      13. Answers
    12. Excel Lesson 2: Creating a Worksheet in Excel 2013
      1. Starting up
      2. Creating a worksheet
      3. Entering data in a cell
      4. Working with cell ranges
      5. Saving workbooks
      6. Opening workbooks
      7. Editing data
      8. Using Undo and Redo
      9. Working with rows and columns
      10. Creating additional worksheets
      11. Printing worksheets and workbooks
      12. Self study
      13. Review
      14. Questions
    13. Excel Lesson 3: Formatting a Worksheet
      1. Starting up
      2. Understanding cell formats
      3. Changing number formats
      4. Changing the font and font size
      5. Modifying row heights and column widths
      6. Cell alignment
      7. Borders and shading
      8. Copying cell formats
      9. Working with cell styles
      10. Using conditional formatting
      11. Using page themes
      12. Self study
      13. Review
      14. Questions
    14. Excel Lesson 4: Using Formulas in Excel 2013
      1. Starting up
      2. Formulas
      3. Entering simple formulas
      4. Referencing cells from other worksheets or workbooks
      5. Using functions
      6. Using the Function Library
      7. Using the AutoSum tool
      8. Using common functions
      9. Working with ranges
      10. Copying formulas
      11. Formula auditing
      12. Self study
      13. Review
      14. Questions
      15. Answers
    15. Excel Lesson 5: Working with Charts
      1. Starting up
      2. Understanding chart types
      3. Creating a chart
      4. Understanding chart elements
      5. Using chart recommendations
      6. Moving and resizing charts
      7. Enhancing a chart
      8. Formatting a chart
      9. Editing a chart
      10. Customizing the chart
      11. Printing a chart
      12. Using Sparklines
      13. Self study
      14. Review
      15. Questions
      16. Answers
    16. Excel Lesson 6: Working with Data
      1. Starting up
      2. Working with lists
      3. Creating a list
      4. Sorting records
      5. Filtering records
      6. Searching records
      7. Deleting records
      8. Removing duplicates
      9. Extracting records
      10. Subtotaling data
      11. Grouping records
      12. Using data validation
      13. Converting text to columns
      14. Using Flash Fill
      15. Self study
      16. Review
    17. Excel Lesson 7: Working with Excel 2013 Templates
      1. Starting up
      2. Excel templates
      3. Working with templates
      4. Saving a workbook as a template
      5. Opening a custom template
      6. Protecting workbooks
      7. Protecting worksheets
      8. Unlocking cells in a protected worksheet
      9. Hide and protect formulas
      10. Searching for templates
      11. Self study
      12. Review
      13. Questions
      14. Answers
    18. Excel Lesson 8: Advanced Data Analysis
      1. Starting up
      2. Introduction to PivotTables
      3. Creating a PivotTable
      4. Rearranging a PivotTable
      5. Removing fields from a PivotTable
      6. Formatting a PivotTable
      7. Editing and updating a PivotTable
      8. Changing the calculation
      9. Hiding and showing data in a PivotTable
      10. Adding subtotals to a PivotTable
      11. Using recommended PivotTables
      12. Working with PivotCharts
      13. Working with tables
      14. What-If analysis
      15. Self study
      16. Review
      17. Questions
      18. Answers
    19. PowerPoint Lesson 1: Microsoft PowerPoint 2013 Jumpstart
      1. Starting up
      2. Choosing a template
      3. Editing the title slide
      4. Adding slides
      5. Adding text to your presentation
      6. Adding visuals to a slide
      7. From slides to presentation
      8. Including speaker notes
      9. Practicing the slide show
      10. Animating your presentation
      11. Making the most of animations
      12. Linking slides with transitions
      13. Grouping and ordering slides in Slide Sorter
      14. Setting your overall look with document themes
      15. Self study
      16. Review
      17. Questions
      18. Answers
    20. PowerPoint Lesson 2: Getting Started with PowerPoint 2013
      1. Starting up
      2. Your workspace and your toolbox
      3. PowerPoint and the Office 2013 user interface
      4. The Ribbon and Backstage view
      5. Choosing a look with the Design tab
      6. Moving from content to performance
      7. Building your presentation content
      8. Building an outline
      9. Editing slide content
      10. Formatting inserted images
      11. Creating notes pages
      12. Reading view
      13. Working with text, images, and visual effects
      14. Simplified text handling
      15. Inserting images
      16. Adding and editing animations
      17. Transitions and slide sorter
      18. Design tools
      19. What’s in a template?
      20. Applying themes to a slide show
      21. Customizing a theme in the Slide Master view
      22. Self study
      23. Review
      24. Questions
      25. Answers
    21. PowerPoint Lesson 3: Designing a Presentation
      1. Starting up
      2. Building better slides
      3. Working with text
      4. Filling in an existing text area
      5. Adding and styling text boxes
      6. The Format pane
      7. Autofit and text boxes
      8. Styling text with WordArt
      9. Formatting the whole presentation
      10. The Slide Master view
      11. Editing the slide master
      12. Creating custom slide layouts
      13. Adding a custom slide layout
      14. Completing the custom layout
      15. Applying the custom layout
      16. Customizing a presentation theme
      17. Changing a theme’s visual scheme
      18. Self study
      19. Review
      20. Questions
      21. Answers
    22. PowerPoint Lesson 4: Using Tables, Charts, and SmartArt
      1. Starting up
      2. Giving structure to your content
      3. Transforming text into SmartArt
      4. Formatting bulleted lists as SmartArt
      5. Visually editing a flowchart
      6. Styling a piece of SmartArt
      7. Piecing together SmartArt
      8. Linking and embedding external data
      9. Embedding an Excel worksheet as an object
      10. Editing embedded objects
      11. Creating a linked object
      12. Creating a chart from tabular data
      13. Generating charts in PowerPoint
      14. Editing individual chart elements
      15. Linking a chart to external Excel data
      16. Styling charts and graphs
      17. Self study
      18. Review
      19. Questions
      20. Answers
    23. PowerPoint Lesson 5: Adding Graphics and Multimedia to Your Presentation
      1. Starting up
      2. Beyond bulleted lists and bar graphs
      3. Recoloring and adjusting images
      4. Cropping an image
      5. Reordering images in the object stack
      6. Heightening visual impact with animations
      7. Creating a crossfade effect with stacked slide elements
      8. Creating complex scenes by clustering animations
      9. Enriching slides with sound effects
      10. Adding background sounds to a presentation
      11. Trimming and triggering sound effects
      12. Adding custom actions to slide objects
      13. Integrating video into a presentation
      14. Embedding and formatting video
      15. Considerations for embedding local video
      16. Media compression and compatibility
      17. Laying out slide elements
      18. Taking advantage of the grid
      19. Working with alignment guides
      20. Self study
      21. Review
      22. Questions
      23. Answers
    24. PowerPoint Lesson 6: Delivering Your Presentation
      1. Starting up
      2. Presentations are performances
      3. Preparing for your presentation
      4. Setting up the slide show
      5. Controlling your presentation from the keyboard
      6. Creating custom slide shows
      7. Presenting in slide show view
      8. Mission control: PowerPoint’s presenter view
      9. Using speaker notes
      10. How detailed should speaker notes be?
      11. Formatting and printing notes pages
      12. Designing a printed handout
      13. Navigating with the slide sorter
      14. Going to a black or white screen
      15. Focusing audience attention with Pen tools
      16. Using the laser pointer and highlighter
      17. Keeping ink annotations
      18. Rehearsing your presentation
      19. Recording slide and presentation timings
      20. Recording narration and pointer movements
      21. Tweaking and removing timings, narration, and laser pointer movements
      22. Presenting online
      23. Delivering a presentation using Office Presentation service
      24. Presenting in Lync
      25. Embedding your slide show in a webpage
      26. Giving excellent presentations
      27. Self study
      28. Review
      29. Questions
      30. Answers
    25. Access Lesson 1: Microsoft Access 2013 Jumpstart
      1. Starting up
      2. What is Access?
      3. Ways to use Access
      4. Database basics
      5. Basic database terminology
      6. Database design tips
      7. Quick tour of Access 2013
      8. Opening an Access 2013 file
      9. Access 2013 components
      10. Exploring a database
      11. Working with records
      12. Searching for a record
      13. Sorting records
      14. Adding and deleting records
      15. Customizing the Quick Access Toolbar
      16. Getting help
      17. Ending an Access session
      18. Self study
      19. Review
      20. Questions
      21. Answers
    26. Access Lesson 2: Getting Started with Microsoft Access 2013
      1. Starting up
      2. Access 2013 database types
      3. Creating a simple database
      4. Creating a database using a template
      5. Saving a new table
      6. Tables, views, and data types
      7. Creating a table in Datasheet view
      8. Adding fields to an Access table
      9. Creating a table in Design view
      10. Adding fields to a table
      11. Importing data from a Microsoft Excel spreadsheet
      12. To rename the new table Sheet1
      13. Self study
      14. Review
      15. Questions
      16. Answers
    27. OneNote Lesson 1: Microsoft OneNote 2013 Jumpstart
      1. Starting up
      2. Discovering OneNote
      3. Exploring the OneNote environment
      4. Opening OneNote
      5. About the Send to OneNote command
      6. Opening a new blank Notebook
      7. Normal (Notebook) view
      8. Working in Backstage view
      9. Searching OneNote
      10. Creating a new Notebook section
      11. Customizing OneNote
      12. Getting help
      13. Ending a OneNote session
      14. Self study
      15. Review
      16. Questions
      17. Answers
    28. OneNote Lesson 2: Getting Started with OneNote 2013
      1. Starting up
      2. Managing Notebooks
      3. Creating a new Notebook
      4. Managing Sections
      5. Creating new Sections
      6. Renaming a Section in OneNote
      7. Grouping Sections
      8. Creating Section groups in a OneNote project
      9. Saving a Notebook
      10. Saving a copy of a Notebook
      11. Managing Pages
      12. Adding and renaming Pages
      13. Inserting content into Notebook Pages
      14. Direct text entry (typing)
      15. Copying and pasting
      16. Creating a drawing using a mouse, touchpad, or electronic pen
      17. Inserting audio and video notes
      18. Inserting web content
      19. Self study
      20. Review
      21. Questions
      22. Answers
    29. Publisher Lesson 1: Introduction to Microsoft Publisher 2013
      1. Starting up
      2. What is Publisher?
      3. Ways to use Publisher
      4. Publisher basics
      5. Quick tour of Publisher 2013
      6. Opening a publication
      7. Changing your view
      8. Saving a publication
      9. Customizing the Quick Access Toolbar
      10. Getting help
      11. Closing a Publisher session
      12. Self study
      13. Review
      14. Questions
      15. Answers
    30. Publisher Lesson 2: Microsoft Publisher 2013 Jumpstart
      1. Starting up
      2. Creating a blank publication
      3. Working with pages
      4. Setting page margins
      5. Changing page orientation
      6. Changing page sizes
      7. Inserting a text box
      8. Formatting text
      9. Flowing text
      10. Inserting and modifying images
      11. Printing your publication
      12. Using Pack and Go
      13. Sending a publication using e-mail
      14. E-mail preview
      15. Self study
      16. Review
      17. Questions
      18. Answers
    31. Outlook Lesson 1: Introduction to Microsoft Outlook 2013
      1. Starting up
      2. What is Microsoft Outlook?
      3. Setting up Outlook
      4. Using more than one e-mail account
      5. Outlook 2013 interface
      6. The Ribbon tabs
      7. Minimizing Outlook Ribbons
      8. The Quick Access Toolbar
      9. Composing e-mail, inserting attachments, adding recipients, and sending messages
      10. Adding attachments to e-mail messages
      11. Adding signatures
      12. Receiving e-mail
      13. Organizing e-mail
      14. Using folders
      15. Archiving old messages
      16. Contacts and the Address Book
      17. Adding contacts
      18. Finding contacts
      19. Creating groups
      20. Calendar
      21. Appointments and meetings
      22. Creating appointments and setting up reminders
      23. Setting up meetings and inviting attendees
      24. Using tasks
      25. Self study
      26. Review
      27. Questions
      28. Answers
    32. Outlook Lesson 2: Getting Started with Microsoft Outlook 2013
      1. Starting up
      2. Outlook views
      3. Printing in Outlook views
      4. Printing in the Mail view
      5. Printing in the Calendar view
      6. Adjusting views in Calendar
      7. Printing in other views
      8. Customizing the Mail view
      9. About the Folder pane
      10. Customizing the Folders pane for the Mail view
      11. Folder pane navigation options
      12. Customizing the Reading pane
      13. Customizing the To-Do bar
      14. Customizing the People pane
      15. Customizing the Ribbons
      16. Forwarding and replying to e-mail
      17. Replying to an e-mail message
      18. Forwarding an e-mail message
      19. Using Rules to manage incoming items
      20. Creating a Rule to manage e-mail
      21. Managing a Rule
      22. Recurring appointments and meetings
      23. Creating a recurring appointment
      24. Creating a recurring meeting
      25. Junk e-mail options
      26. Managing Junk e-mail
      27. Self study
      28. Review
      29. Questions
      30. Answers
    33. About the Authors
    34. Acknowledgments
      1. Microsoft® Office 2013 Digital Classroom®
    35. Credits