Ipswich Public Library

Teach yourself visually Office 2016, Elaine Marmel

eng

illustrations

index present

non fiction

Teach yourself visually Office 2016

926068348

Elaine Marmel

Teach yourself visually

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

Office 2016Teach yourself visually Microsoft Office 2016