pt. I. Office features. 1. Office basics : Start and exit office applications ; Navigate the program windows ; Work with backstage view ; Change the color scheme ; Find a ribbon command ; Work with the ribbon ; Customize the quick access toolbar ; Using an Office program on a tablet PC -- 2. Working with files : Create a new file ; Save a file ; Open a file ; Print a file ; Check your file for hidden or personal data ; E-mail a file ; Select data ; Cut, copy, and paste data ; Arrange windows -- 3. Office graphics tools : Insert a picture ; Insert an online picture ; Resize and move objects ; Understanding graphics modification techniques -- 4. Working with Office files online : Office and the cloud ; Sign in to Office 365 ; Share a document from Office ; Download apps from the Office store ; Sign in to OneDrive ; Using an online app in OneDrive ; Using an Office program from OneDrive ; Upload a document to OneDrive ; Share a document using OneDrive -- pt. II. Word. 5. Adding text : Change Word's views ; Type and edit text ; Insert quick parts ; Insert symbols ; Create a blog post -- 6. Formatting text : Change the font, size, and color ; Align text ; Set line spacing ; Indent text ; Set tabs ; Set margins ; Create lists ; Copy formatting ; Clear formatting ; Format with styles ; Using a template -- 7. Adding extra touches : Insert an online video ; Assign a theme ; Add borders ; Create columns ; Insert a table ; Apply table styles ; Insert table rows or columns ; Add headers and footers ; Insert footnotes and endnotes ; Insert page numbers and page breaks ; Mark index entries ; Generate an index ; Generate a table of contents ; Create a bibliography -- 8. Reviewing documents : Work in read mode view ; Find and replace text ; Scan document content ; Check spelling and grammar ; Work with AutoCorrect ; Using Word's thesaurus and dictionary ; Translate text ; Track and review document changes ; Lock and unlock tracking ; Combine reviewers' comments ; Work with comments --
pt. III. Excel. 9. Building spreadsheets : Enter cell data ; Select cells ; Faster data entry with AutoFill ; Turn on text wrapping ; Center data across columns ; Adjust cell alignment ; Change the font and size ; Change number formats ; Increase or decrease decimals ; Add cell borders and shading ; Format data with styles ; Apply conditional formatting ; Add columns and rows ; Resize columns and rows ; Freeze column and row titles on-screen ; Name a range ; Clear or delete cells ; Split and format a column of data -- 10. Worksheet basics : Add a worksheet ; Name a worksheet ; Change page setup options ; Move and copy worksheets ; Delete a worksheet ; Find and replace data ; Create a table ; Filter or sort table information ; Analyze data quickly ; Understanding data analysis choices ; Track and review worksheet changes ; Insert a comment -- 11. Working with formulas and functions : Understanding formulas ; Create a formula ; Apply absolute and relative cell references ; Understanding functions ; Apply a function ; Total cells with AutoSum ; Audit a worksheet for errors -- 12. Working with charts : Create a chart ; Move and resize charts ; Change the chart type ; Change the chart style ; change the chart layout ; Add chart elements ; Format chart objects ; Change the chart data ; Using Sparklines to view data trends ; Understanding PivotTables ; Create a PivotTable ; Insert a PivotTable slicer -- pt. IV. PowerPoint. 13. Creating a presentation : Create a new presentation ; Create a photo album presentation ; Change PowerPoint views ; Insert slides ; Change the slide layout ; Change the slide size -- 14. Populating presentation slides : Add and edit slide text ; Change the font, size, and color ; Apply a theme ; Set line spacing ; Align text ; Add a text box to a slide ; Add a table to a slide ; Add a chart to a slide ; Add a video clip to a slide ; Move a slide object ; Resize a slide object -- 15. Assembling and presenting a slide show : Reorganize slides ; Reuse a slide ; Organize slides into sections ; Define slide transitions ; Add animation effects ; Create a custom animation ; Record narration ; Insert a background song ; Create speaker notes ; Rehearse a slide show ; Run a slide show ; Review a presentation ; Package your presentation on a CD ; Present online --
pt. V. Access. 16. Database basics : Understanding database basics ; Create a database based on a template ; Create a blank database ; Create a new table ; Change table views ; Add a field to a table ; Delete a field from a table ; Hide a field in a table ; Move a field in a table ; Create a form ; Change form views ; Move a field in a form ; Delete a field in a form ; Apply a database theme ; Format form fields ; Add a background image -- 17. Adding, finding, and querying data : Add a record to a table ; Add a record to a form ; Navigate records in a form ; Search for a record using a form ; Delete a record from a table ; Delete a record using a form ; Sort records ; Filter records ; Apply conditional formatting ; Perform a simple query ; Create a report -- pt. VI. Outlook. 18. Organizing with Outlook : Navigate in Outlook ; Schedule an appointment ; Create a new contact ; Create a new task ; Add a note ; Customize the navigation bar ; Peek at appointments and tasks ; Search for Outlook items ; Work with the to-do bar ; Link contacts -- 19. E-mailing with Outlook : Compose and send a message ; Send a file attachment ; Read an incoming message ; Reply to or forward a message ; Add a sender to your Outlook contacts ; Delete a message ; Work with conversations ; Screen junk e-mail ; Create a message rule --
pt. VII. Publisher. 20. Publisher basics : Create a publication ; Zoom in and out ; Add text ; Add a new text box ; Swap pictures ; Save a publication for photo center printing
21. Fine-tuning a publication : Change the font, size, and color ; Apply a text effect ; Change text alignment ; Add a border ; Control text wrap ; Link text boxes ; Move and resize publication objects ; Edit the background ; Add a building block object ; Create a building block object
pt. VIII. OneNote. 22. Taking notes with OneNote : Navigate OneNote ; Type and draw notes ; Insert and format a table ; Attach files to notes ; Create quick note ; Insert a screen clipping ; Record an audio note
23. Organizing and sharing notes : Create a new notebook ; Create a new section ; Create a new page ; Rename a section or page ; Group sections ; Search notes ; Search for recent edits ; Set synchronization options ; Share notes with people who do not have OneNote.
