Microsoft Office 2016 Step by Step

Microsoft Office 2016 Step by Step

4 (6 ratings by Goodreads)
By (author)  , By (author) 

Free delivery worldwide

Available. Dispatched from the UK in 2 business days
When will my order arrive?


Now in full color!This is learning made easy. Get more done quickly with Office 2016. Jump in wherever you need answers - brisk lessons and colorful screenshots show you exactly what to do, step by step.Covers Word, Excel, PowerPoint and OutlookIncludes Office 365 subscription informationDiscover how to use cloud storage with OneDrive and your Office 365 subscriptionFormat Word documents for maximum visual impactBuild powerful, reliable Excel workbooks for analysis and reportingPrepare highly effective PowerPoint presentationsUse Outlook to organize your email, calendar, and contactsIncludes downloadable practice files
show more

Product details

  • Paperback | 592 pages
  • 190 x 228 x 22.86mm | 952g
  • Microsoft Press,U.S.
  • Redmond, United States
  • English
  • 0735699232
  • 9780735699236
  • 31,035

About Joan Lambert

Joan Lambert has worked closely with Microsoft technologies since 1986, and in the training and certification industry since 1997. As President and CEO of Online Training Solutions, Inc. (OTSI), Joan guides the translation of technical information and requirements into useful, relevant, and measurable resources for people who are seeking certification of their computer skills or who simply want to get things done efficiently. Joan is the author or coauthor of more than three dozen books about Windows and Office (for Windows, Mac, and iPad), video-based training courses about SharePoint and OneNote, and three generations of Microsoft Office Specialist certification study guides. Joan is a Microsoft Certified Professional, Microsoft Certified Trainer, Microsoft Office Specialist Master (for all Office versions since Office 2007), Microsoft Certified Technology Specialist (for Windows and Windows Server), Microsoft Certified Technology Associate (for Windows), and Microsoft Dynamics Specialist. Joan currently lives in a small town in Texas with her simply divine daughter, Trinity, and an ever-growing menagerie of dogs, cats, and fish.Curtis Frye is the author of more than 30 books, including Microsoft Excel 2013 Step by Step for Microsoft Press and Brilliant Excel VBA Programming for Pearson, UK. He has also created and recorded more than three dozen courses for, including Excel for Mac 2016 Essential Training and Excel 2013: PivotTables in Depth. In addition to his work as a writer, Curt is a popular conference speaker and performer, both as a solo presenter and as part of the Portland, Oregon ComedySportz improvisational comedy troupe. He lives in Portland with his wife and three cats.
show more

Table of contents

Introduction xiWho this book is for xiThe Step by Step approach xiiDownload the practice files xiiEbook edition xvGet support and give feedback xvErrata and support xvWe want to hear from you xviStay in touch xviPart 1: Microsoft Office 2016Chapter 1: Explore Office 2016 3Work in the Office user interface 4Identify app window elements 5Sidebar: Tell me what you want to do 10Work with the ribbon and status bar 12Sidebar: Adapt exercise steps 16Change Office and app options 18Manage account information 18Manage app options 22Customize the Quick Access Toolbar 25Customize the ribbon 29Skills review 34Practice tasks 35Chapter 2: Create and manage files 39Create files 40Open and move around in files 43Display different views of files 48Display and edit file properties 53Sidebar: File types and compatibility with earlier versions of Office apps 54Save and close files 56Sidebar: Save files to OneDrive 60Skills review 62Practice tasks 63Part 2: Microsoft Word 2016Chapter 3: Modify the structure and appearance of text 69Apply paragraph formatting 70Configure alignment 71Configure vertical spacing 72Configure indents 76Sidebar: Configure paragraph borders and shading 79Structure content manually 79Apply character formatting 84Sidebar: Character formatting and case considerations 91Create and modify lists 91Sidebar: Format text as you type 96Apply built-in styles to text 97Apply styles 97Manage outline levels 101Change the document theme 104Skills review 108Practice tasks 109Chapter 4: Collaborate on documents 115Mark up documents 116Insert comments 116Track changes 119Display and review document markup 122Display markup 122Review and respond to comments 128Review and process tracked changes 130Sidebar: Remember to check for errors 133Compare and merge documents 133Compare and combine separate copies of a document 134Compare separate versions of a document 136Control content changes 137Restrict actions 138Restrict access by using a password 144Sidebar: Restrict access by using rights management 149Coauthor documents 149Skills review 153Practice tasks 154Chapter 5: Merge data with documents and labels 159Understand the mail merge process 160Start the mail merge process 161Get started with letters 162Get started with labels 163Get started with email messages 166Choose and refine the data source 168Select an existing data source 169Create a new data source 172Refine the data source records 173Sidebar: Refresh data 178Insert merge fields 178Preview and complete the merge 181Create individual envelopes and labels 184Generate individual envelopes 184Generate individual mailing labels 188Skills review 190Practice tasks 191Part 3: Microsoft Excel 2016Chapter 6: Perform calculations on data 197Name groups of data 198Define Excel tables 201Create formulas to calculate values 205Sidebar: Operators and precedence 218Summarize data that meets specific conditions 219Set iterative calculation options and enable or disable automatic calculation 225Use array formulas 227Find and correct errors in calculations 229Skills review 235Practice tasks 236Chapter 7: Manage worksheet data 239Limit data that appears on your screen 240Manipulate worksheet data 245Sidebar: Select list rows at random 246Summarize data in worksheets that have hidden and filtered rows 247Find unique values within a data set 253Define valid sets of values for ranges of cells 255Skills review 257Practice tasks 258Chapter 8: Reorder and summarize data 261Sort worksheet data 262Sort data by using custom lists 268Organize data into levels 271Look up information in a worksheet 276Skills review 279Practice tasks 280Chapter 9: Analyze alternative data sets 283Examine data by using the Quick Analysis Lens 284Define an alternative data set 286Define multiple alternative data sets 290Analyze data by using data tables 292Vary your data to get a specific result by using Goal Seek 295Find optimal solutions by using Solver 297Analyze data by using descriptive statistics 303Skills review 305Practice tasks 306Part 4: Microsoft PowerPoint 2016Chapter 10: Create and manage slides 313Add and remove slides 314Insert new slides 316Copy and import slides and content 317Sidebar: SharePoint slide libraries 322Hide and delete slides 324Divide presentations into sections 326Rearrange slides and sections 329Apply themes 331Change slide backgrounds 336Sidebar: Non-theme colors 344Skills review 346Practice tasks 347Chapter 11: Insert and manage simple graphics 351Insert, move, and resize pictures 352Sidebar: Graphic formats 355Edit and format pictures 356Draw and modify shapes 361Draw and add text to shapes 362Sidebar: Locate additional formatting commands 364Move and modify shapes 365Format shapes 367Sidebar: Connect shapes 371Capture and insert screen clippings 372Create a photo album 375Skills review 380Practice tasks 381Chapter 12: Add sound and movement to slides 385Animate text and pictures on slides 386Sidebar: Animate this 392Customize animation effects 396Sidebar: Bookmark points of interest in media clips 402Add audio content to slides 404Add video content to slides 410Compress media to decrease file size 415Skills review 417Sidebar: Hyperlink to additional resources 418Practice tasks 420Part 5: Microsoft Outlook 2016Chapter 13: Send and receive email messages 427Create and send messages 428Create messages 429Troubleshoot message addressing 434Save and send messages 438Sidebar: Send from a specific account 440Attach files and Outlook items to messages 444Sidebar: New mail notifications 451Display messages and message attachments 452Display message content 452Display attachment content 454Display message participant information 459Respond to messages 464Sidebar: Resending and recalling messages 468Skills review 471Practice tasks 472Chapter 14: Organize your Inbox 475Display and manage conversations 476Arrange messages by specific attributes 482Categorize items 486Sidebar: Store information in Outlook notes 490Organize messages in folders 494Sidebar: Print messages 498Skills review 499Practice tasks 500Chapter 15: Manage scheduling 503Schedule appointments and events 504Sidebar: Add holidays to your calendar 508Convert calendar items 510Configure calendar item options 512Schedule and change meetings 518Respond to meeting requests 526Display different views of a calendar 528Sidebar: Use the Date Navigator 532Skills review 535Practice tasks 536Index 541About the authors 564
show more

Rating details

6 ratings
4 out of 5 stars
5 50% (3)
4 0% (0)
3 50% (3)
2 0% (0)
1 0% (0)
Book ratings by Goodreads
Goodreads is the world's largest site for readers with over 50 million reviews. We're featuring millions of their reader ratings on our book pages to help you find your new favourite book. Close X