Starting up

• About Microsoft Office 2013 Digital Classroom
• Prerequisites
• System requirements
• Fonts used in this book
• Access lesson files and videos any time
• Checking for updated lesson files
• Loading lesson files
• Working with the video tutorials
• Setting up for viewing the video tutorials
• Viewing the video tutorials with the
• Adobe Flash Player
• Additional resources

Word Lesson 1: Microsoft Word 2013 Jumpstart

• The project
• Interface conventions
• Working with words
• Text and fields
• Applying styles to text
• Your document’s look and feel
• Working with themes, style sets, and color schemes
• Working with images and video
• Styling an image
• Working with online images and videos
• Different views of your document
• Collapsing document sections
• Working with Word’s windows
• Collaboration and tracking changes
• Communicating with colleagues in comments
• Save always
• Self study
• Review

Word Lesson 2: Getting Started with Word 2013

• The Word 2013 interface
• The Start screen and template gallery
• Opening a document
• The Ribbon
• Customizing the Ribbon
• The Quick Access toolbar
• The Status bar
• The Navigation pane
• Different viewing modes
• Laying out the page
• Page size, margins, and marginalia
• Headers and footers
• Windows and panes: splitting your document view
• Self study
• Review

Word Lesson 3: Beginning Text and Layout Operations

• Working with text in Word
• Paragraph and character formatting
• Spacing
• Styles, themes, and live preview
• Cut, copy, and paste
• Paste options
• Copying a look: Format Painter
• A paste to fit every taste
• Working with columns
• Text boxes and images
• Placing text boxes and images
• Inserting an object directly into a paragraph
• Self study
• Review

Word Lesson 4: Structuring Complex Documents

• Documents are data
• Headings: logical document divisions
• Text folding
• Sorting sections alphabetically
• Building an outline with headings
• Working in outline view
• Captions
• Tagging images with captions
• Working with fields
• Viewing field codes
• Setting and accessing document properties
• Adding a cover page
• Page and section breaks
• Seeing breaks and other hidden characters
• Section breaks
• Cross­references
• Footnotes and endnotes
• Adding and deleting ntoes
• Endnotes, briefly
• Adding a table of contents
• From headings to table of contents
• Building a custom table of contents
• Using table fields in your TOC
• Adding a table of figures
• Self study
• Review

Word Lesson 5: Working with Tables

• The uses of tables
• Table basics
• Inserting and navigating tables
• Split cells and table styles
• Working with text in and around tables
• Text alignment and merged cells
• Merging cells with the Eraser tool
• Presenting and sorting tabular data
• Adding, deleting, and moving columns and rows
• Sorting data in a table
• Designing tables
• Table style options
• Applying a table style
• Setting cell and table borders
• Using the Border Painter tool
• Editing cell contents
• Cell text and manual cell sizing
• Using AutoFit and Fit Text
• Images in tables
• Self study
• Review

Word Lesson 6: Beyond Word: Linking and Collaborating

• Group work and Groupware
• Tracking your edits
• How Word displays edits
• Tracking new changes
• Controlling the markup that you see
• The Reviewing pane
• Editing and collaboratingAccepting and rejecting changesComments
• and conversationsTaking a comment thread to e­mail or
• instant messenger
• Access control
• Blocking certain edits
• Restricting editing
• Comparing and combining documents
• Comparing documents
• Combining documents
• Embedding and linking objects
• Linking to an Excel spreadsheet
• Unlinking a linked object
• Self study
• Review

Word Lesson 7: Creating Mail Merges

• Mail merges
• Linking to a data source
• Data sources for mail merges
• Inserting merge fields into a document
• Inserting simple merge fields
• Using if­then conditional fields
• Previewing a merge
• Conditionally inserting an image
• Finalizing the merge
• Self study
• Review
• Word Lesson 8: Blogging in Word
• How blogs work
• Setting up a blog account
• Creating a blog post
• Setting your blog post’s categories
• Uploading posts and drafts
• Editing posts stored on the server
• Self study
• Review

Excel Lesson 1: Getting Started with Excel 2013

• Getting to know the workspace
• Getting to know the cell pointer
• Using the Ribbon
• Exploring the Status bar
• Using the Quick Access toolbar
• Using the Formula bar
• Moving around the worksheet
• Exploring what’s new in Excel 2013
• Self study
• Review

Excel Lesson 2: Creating a Worksheet in Excel 2013

• Creating a worksheet
• Entering data in a cell
• Working with cell ranges
• Saving workbooks
• Opening workbooks
• Editing data
• Using Undo and Redo
• Working with rows and columns
• Creating additional worksheets
• Printing worksheets and workbooks
• Self study
• Review

Excel Lesson 3: Formatting a Worksheet

• Understanding cell formats
• Changing number formats
• Changing the font and font size
• Modifying row heights and column widths
• Cell alignment
• Borders and shading
• Copying cell formats
• Working with cell styles
• Using conditional formatting
• Using page themes
• Self study
• Review

Excel Lesson 4: Using Formulas in Excel 2013

• Formulas
• Entering simple formulas
• Referencing cells from other worksheets
• or workbooks
• Using functions
• Using the Function Library
• Using the AutoSum tool
• Using common functions
• Working with ranges
• Copying formulas
• Formula auditing
• Self study
• Review

Excel Lesson 5: Working with Charts

• Understanding chart types
• Creating a chart
• Understanding chart elements
• Using chart recommendations
• Moving and resizing charts
• Enhancing a chart
• Formatting a chart
• Editing a chart
• Customizing the chart
• Printing a chart
• Using Sparklines
• Self study
• Review

Excel Lesson 6: Working with Data

• Working with lists
• Creating a list
• Sorting records
• Filtering records
• Searching records
• Deleting records
• Removing duplicates
• Extracting records
• Subtotaling data
• Grouping records
• Using data validation
• Converting text to columns
• Using Flash Fill
• Self study
• Review

Excel Lesson 7: Working with Excel 2013 Templates

• Excel templates
• Working with templates
• Saving a workbook as a template
• Opening a custom template
• Protecting workbooks
• Protecting worksheets
• Unlocking cells in a protected worksheet
• Hide and protect formulas
• Searching for templates
• Self study
• Review

Excel Lesson 8: Advanced Data Analysis

• Introduction to PivotTables
• Creating a PivotTable
• Rearranging a PivotTable
• Removing fields from a PivotTable
• Formatting a PivotTable
• Editing and updating a PivotTable
• Changing the calculation
• Hiding and showing data in a PivotTable
• Adding subtotals to a PivotTable
• Using recommended PivotTables
• Working with PivotCharts
• Working with tables
• What­If analysis
• Self study
• Review

PowerPoint Lesson 1: Microsoft PowerPoint 2013 Jumpstart

• Choosing a template
• Editing the title slide
• Adding slides
• Adding text to your presentation
• Adding visuals to a slide
• From slides to presentation
• Including speaker notes
• Practicing the slide show
• Animating your presentation
• Making the most of animations
• Linking slides with transitions
• Grouping and ordering slides in Slide Sorter
• Setting your overall look with document themes
• Self study
• Review

PowerPoint Lesson 2: Getting Started with PowerPoint 2013

• Your workspace and your toolbox
• PowerPoint and the Office 2013 user interface
• The Ribbon and Backstage view
• Choosing a look with the Design tab
• Moving from content to performace
• Building your presentation content
• Building an outline
• Editing slide content
• Formatting inserted images
• Creating notes pages
• Reading view
• Working with text, images and visual effects
• Simplified text handling
• Inserting images
• Adding and editing animations
• Transitions and slide sorter
• Design tools
• What’s in a template?
• Applying themes to a slide show
• Customizing a theme in the Slide Master view
• Self study
• Review

PowerPoint Lesson 3: Designing a Presentation

• Building better slides
• Working with text
• Filling in an existing text area
• Adding and styling text boxes
• The Format pane
• Autofit and text boxes
• Styling text with WordArt
• Formatting the whole presentation
• The Slide Master view
• Editing the Slide Master
• Creating custom slide layouts
• Adding a custom slide layout
• Completing the custom layout
• Applying the custom layout
• Customizing a presentation theme
• Changing a theme’s visual scheme
• Self study
• Review

PowerPoint Lesson 4: Using Tables, Charts, and SmartArt

• Giving structure to your content
• Transforming text into SmartArt
• Formatting bulleted lists as SmartArt
• Visually editing a flowchart
• Styling a piece of SmartArt
• Piecing together SmartArt
• Linking and embedding external data
• Embedding an Excel worksheet as an object
• Editing embedded objects
• Creating a linked object
• Creating a chart from tabular data
• Generating charts in PowerPoint
• Editing individual chart elements
• Linking a chart to external Excel data
• Styling charts and graphs
• Self study
• Review

PowerPoint Lesson 5: Adding Graphics and Multimedia to Your Presentation

• Beyond bulleted lists and bar graphs
• Recoloring and adjusting images
• Cropping an image
• Reordering images in the object “Stack”
• Heightening visual impact with animations
• Creating a crossfade effect with
• stacked slide elements
• Creating complex scenes by clustering animations
• Enriching slides with sound effects
• Adding background sounds to a presentation
• Trimming and triggering sound effects
• Adding custom actions to slide objects
• Integrating video into a presentation
• Embedding and formatting video
• Considerations for embedding local video
• Media compression and compatibility
• Laying out slide elements
• Taking advantage of the grid
• Working with alignment guides
• Self study
• Review

PowerPoint Lesson 6: Delivering Your Presentation

• Presentations are performances
• Preparing for your presentation
• Setting up the slide show
• Controlling your presentation from the keyboard
• Creating custom slide shows
• Presenting in slide show preview
• Mission control: PowerPoint’s presenter view
• Using speaker notes
• How detailed should speaker notes be?
• Formatting and printing notes pages
• Designing a printed handout
• Navigating with the slide sorter
• Going to a black or white screen
• Focusing audience attention with Pen tools
• Using the laser pointer and highlighter
• Keeping ink annotations
• Rehearsing your presentation
• Recording slide and presentation timings
• Recording narration and pointer movements
• Tweaking and removing timings, narration,
• and laser pointer movements
• Presenting online
• Delivering a presentation using
• Office Presentation service
• Presenting in Lync
• Embedding your slide show in a webpage
• Giving excellent presentations
• Self study
• Review

Access Lesson 1: Microsoft Access 2013 Jumpstart

• What is Access?
• Ways to use Access
• Database basics
• Basic database terminology
• Database design tips
• Quick tour of Access 2013
• Opening an Access 2013 file
• Access 2013 components
• Exploring a database
• Working with records
• Searching for a record
• Sorting records
• Adding and deleting records
• Customizing the Quick Access toolbar
• Getting help
• Ending an Access session
• Self study
• Review

Access Lesson 2: Getting Started with Microsoft Access 2013

• Access 2013 database types
• Creating a simple database
• Creating a database using a template
• Saving a new table
• Tables, views, and data types
• Creating a table in Datasheet view
• Adding fields to an Access table
• Creating a table in Design view
• Adding fields to a table
• Importing data from a Microsoft Excel spreadsheet
• To rename the new table Sheet1
• Self study
• Review

OneNote Lesson 1: Microsoft OneNote 2013 Jumpstart

• Discovering OneNote
• Exploring the OneNote environment
• Opening OneNote
• About the Send to OneNote command
• Opening a new blank Notebook
• Normal (Notebook) view
• Working in Backstage view
• Searching OneNote
• Creating a new Notebook section
• Customizing OneNote
• Getting help
• Ending a OneNote session
• Self study
• Review

OneNote Lesson 2: Getting Started with OneNote 2013

• Managing Notebooks
• Creating a new Notebook
• Managing Sections
• Creating new Sections
• Renaming a Section in OneNote
• Grouping Sections
• Creating Section groups in a OneNote project
• Saving a Notebook
• Saving a copy of a Notebook
• Managing Pages
• Adding and renaming Pages
• Inserting content into Notebook Pages
• Direct text entry (typing)
• Copying and pasting
• Creating a drawing using a mouse, touchpad,
• or electronic pen
• Inserting audio and video notes
• Inserting web content
• Self study
• Review

Publisher Lesson 1: Introduction to Microsoft Publisher 2013

• What is Publisher?
• Ways to use Publisher
• Publisher basics
• Quick tour of Publisher 2013
• Opening a publication
• Changing your view
• Saving a publication
• Customizing the Quick Access toolbar
• Getting help
• Closing a Publisher session
• Self study
• Review

Publisher Lesson 2: Microsoft Publisher 2013 Jumpstart

• Creating a blank publication
• Working with pages
• Setting page margins
• Changing page orientation
• Changing page sizes
• Inserting a text box
• Formatting text
• Flowing text
• Inserting and modifying images
• Printing your publication
• Using Pack and Go
• Sending a publication using e­mail
• E­mail preview
• Self study
• Review

Outlook Lesson 1: Introduction to Microsoft Outlook 2013

• What is Microsoft Outlook?
• Setting up Outlook
• Using more than one e­mail account
• Outlook 2013 interface
• The Ribbon tabs
• Minimizing Outlook Ribbons
• The Quick Access toolbar
• Composing e­mail, inserting attachments, adding recipients, and
• sending messages
• Adding attachments to e­mail messages
• Adding signatures
• Receiving e­mail
• Organizing e­mail
• Using folders
• Archiving old messages
• Contacts and the Address Book
• Adding contacts
• Finding contacts
• Creating groups
• Calendar
• Appointments and meetings
• Creating appointments and setting­up reminders
• Setting­up meetings and inviting attendees
• Using tasks
• Self study
• Review

Outlook Lesson 2: Getting Started with Microsoft Outlook 2013

• Outlook views
• Printing in Outlook views
• Printing in the Mail view
• Printing in the Calendar view
• Adjusting views in Calendar
• Printing in other views
• Customizing the Mail view
• About the Folder pane
• Customizing the Folder pane for the Mail view
• Folder pane navigation options
• Customizing the Reading pane
• Customizing the To­Do bar
• Customizing the People pane
• Customizing the Ribbons
• Forwarding and replying to e­mail
• Replying to an e­mail message
• Forwarding an e­mail message
• Using Rules to manage incoming items
• Creating a Rule to manage e­mail
• Managing a Rule
• Recurring appointments and meetings
• Creating a recurring appointment
• Create a recurring meeting
• Junk e­mail options
• Managing Junk e­mail
• Self study
• Review