[Dummies 01] • Microsoft® Office 2016 At Work For Dummies by Wempen, Faithe -- Read -- Imperial Library of Trantor

Index

Cover Title Page Table of Contents Introduction

About This Book Foolish Assumptions Icons Used in This Book Beyond the Book Where to Go from Here

Chapter 1: Getting to Know Office

Start and exit an Office application Work with the Ribbon Use the File menu Create a new document Enter text Move around in an application Change the view Save your work Close a file Open a saved file Change locations when saving or opening files

Chapter 2: Creating a Word Document

Start a new document as Word starts Select text Choose between manual and style-based text formatting Remove manually applied formatting Change the text font Change the text size Select colors from a palette Change text color Apply text effects Copy formatting with Format Painter Change the style set Apply a different theme Check spelling and grammar Email a document to others Save a document in other formats Create a PDF or XPS version of your document Print your work

Chapter 3: Paragraph Formatting

Change a paragraph’s horizontal alignment Indent a paragraph Adjust a paragraph’s vertical spacing Place a border around a paragraph Shade a paragraph’s background Create a bulleted or numbered list Apply styles Modify styles Create new styles

Chapter 4: Formatting Sections, Pages, and Documents

Set margins Set page size and orientation Use page headers and footers Create page breaks Create section breaks Set up a multicolumn document Create a page border Apply a page background color Add line numbers

Chapter 5: Working with Tables and Graphics in Word

Create tables Select cells, rows, and columns Resize table rows and columns Add and remove rows and columns Apply borders to table cells Apply shading to table cells Insert a picture from a file Find pictures online Manage picture placement and size Caption and auto-number pictures

Chapter 6: References and Mail Merges in Word

Create a table of contents Insert footnotes or endnotes Cite sources and create a bibliography Create an index Mail merge: An overview Start a mail merge main document Select an existing data list for a mail merge Create a data list for a mail merge Insert merge fields in the main document Perform a mail merge

Chapter 7: Creating Basic Excel Worksheets

Understanding the Excel interface Move between cells Select cells and ranges Enter and edit text in cells Use AutoFill to fill cell content Copy and move data between cells Insert and delete rows, columns, and cells Use Flash Fill to extract content Create and manage multiple worksheets

Chapter 8: Creating Excel Formulas and Functions

Write basic formulas Copy and move formulas Insert functions Show the current date or time with a function Calculate loan terms Perform math calculations Evaluate a condition with an IF function Refer to named ranges Use Quick Analysis features

Chapter 9: Formatting and Printing Excel Worksheets

Apply and customize themes Apply a worksheet background Apply cell borders and shading Format cells using cell styles Resize rows and columns Make text wrap in a cell Use conditional formatting Set up headers and footers Print a worksheet

Chapter 10: Storing and Managing Databases in Excel

Create an Excel database Sort a table Filter a table Add a Total row to a table Create queries Remove duplicates from a dataset Restrict data entry with validation rules

Chapter 11: Creating Charts in Excel

Choose the correct chart type Create a chart Move and resize a chart Switch rows and columns Modify the data range for a chart Change the axis scale of a chart Apply a chart style Change a chart’s colors Add or remove chart elements Format a chart element

Chapter 12: Managing Email with Outlook

Understand the Outlook interface Set up a mail account Compose and send email Receive and read email Create folders for managing email Moving messages between folders Create a message handling rule Configure the junk mail filter Use an automatic signature

Chapter 13: Using Outlook Contacts and Tasks

Add and edit contacts View and search the People list Send a message to a contact Forward contact data via email Create and manage tasks

Chapter 14: Getting Started with PowerPoint

Start a new presentation Move around in a presentation Choose the right view Add and remove slides Change the slide layout Use content placeholders Manually place text on a slide Manually place a picture on a slide Move and resize slide objects Delete slide objects

Chapter 15: Formatting a Presentation

Understanding templates versus themes Change the theme Change the presentation colors and fonts Modify the theme in Slide Master view Enable footer placeholders Format text boxes and placeholders Create SmartArt graphics Modify the structure of a SmartArt graphic Format a SmartArt graphic

Chapter 16: Adding Movement and Sound to a Presentation

Add slide transition effects Set slides to advance manually or automatically Animate objects Insert a sound clip Insert a video clip on a slide

Chapter 17: Presenting a Slide Show

Display a slide show onscreen Annotate slides with the pen tools Use Presenter view Print handouts Export handouts to Word

About the Author Cheat Sheet Advertisement Page Connect with Dummies End User License Agreement