book

Microsoft Office 2016 Step by Step

Name: Microsoft Office 2016 Step by Step
ISBN: 9780735699717

by Joan Lambert, Curtis Frye

November 2015

Beginner

592 pages

11h 43m

English

Microsoft Press

Read now

Unlock full access

Cover
Title Page
Copyright Page
Contents
Introduction
Who this book is forThe Step by Step approachDownload the practice filesEbook editionGet support and give feedbackErrata and supportWe want to hear from youStay in touch
Part 1: Microsoft Office 2016
1. Explore Office 2016
Work in the Office user interfaceIdentify app window elementsWork with the ribbon and status barChange Office and app optionsManage account informationManage app optionsCustomize the Quick Access ToolbarCustomize the ribbonSkills reviewPractice tasksWork in the Office user interfaceChange Office and app optionsCustomize the Quick Access ToolbarCustomize the ribbon
2. Create and manage files
Create filesOpen and move around in filesDisplay different views of filesDisplay and edit file propertiesSave and close filesSkills reviewPractice tasksCreate filesOpen and move around in filesDisplay different views of filesDisplay and edit file propertiesSave and close files
Part 2: Microsoft Word 2016
3. Modify the structure and appearance of text
Apply paragraph formattingConfigure alignmentConfigure vertical spacingConfigure indentsStructure content manuallyApply character formattingCreate and modify listsApply built-in styles to textApply stylesManage outline levelsChange the document themeSkills reviewPractice tasksApply paragraph formattingStructure content manuallyApply character formattingCreate and modify listsApply built-in styles to textChange the document theme

4. Collaborate on documents
Mark up documentsInsert commentsTrack changesDisplay and review document markupDisplay markupReview and respond to commentsReview and process tracked changesCompare and merge documentsCompare and combine separate copies of a documentCompare separate versions of a documentControl content changesRestrict actionsRestrict access by using a passwordCoauthor documentsSkills reviewPractice tasksMark up documentsDisplay and review document markupCompare and merge documentsControl content changesCoauthor documents
5. Merge data with documents and labels
Understand the mail merge processStart the mail merge processGet started with lettersGet started with labelsGet started with email messagesChoose and refine the data sourceSelect an existing data sourceCreate a new data sourceRefine the data source recordsInsert merge fieldsPreview and complete the mergeCreate individual envelopes and labelsGenerate individual envelopesGenerate individual mailing labelsSkills reviewPractice tasksUnderstand the mail merge processStart the mail merge processChoose and refine the data sourceInsert merge fieldsPreview and complete the mergeCreate individual envelopes and labels
Part 3: Microsoft Excel 2016
6. Perform calculations on data
Name groups of dataDefine Excel tablesCreate formulas to calculate valuesSummarize data that meets specific conditionsSet iterative calculation options and enable or disable automatic calculationUse array formulasFind and correct errors in calculationsSkills reviewPractice tasksName groups of dataCreate formulas to calculate valuesDefine Excel tablesSummarize data that meets specific conditionsSet iterative calculation options and enable or disable automatic calculationUse array formulasFind and correct errors in calculations
7. Manage worksheet data
Limit data that appears on your screenManipulate worksheet dataSummarize data in worksheets that have hidden and filtered rowsFind unique values within a data setDefine valid sets of values for ranges of cellsSkills reviewPractice tasksLimit data that appears on your screenManipulate worksheet dataDefine valid sets of values for ranges of cells
8. Reorder and summarize data
Sort worksheet dataSort data by using custom listsOrganize data into levelsLook up information in a worksheetSkills reviewPractice tasksSort worksheet dataSort data by using custom listsOrganize data into levelsLook up information in a worksheet
9. Analyze alternative data sets
Examine data by using the Quick Analysis LensDefine an alternative data setDefine multiple alternative data setsAnalyze data by using data tablesVary your data to get a specific result by using Goal SeekFind optimal solutions by using SolverAnalyze data by using descriptive statisticsSkills reviewPractice tasksExamine data by using the Quick Analysis LensDefine an alternative data setDefine multiple alternative data setsAnalyze data by using data tablesVary your data to get a specific result by using Goal SeekFind optimal solutions by using SolverAnalyze data by using descriptive statistics
Part 4: Microsoft PowerPoint 2016
10. Create and manage slides
Add and remove slidesInsert new slidesCopy and import slides and contentHide and delete slidesDivide presentations into sectionsRearrange slides and sectionsApply themesChange slide backgroundsSkills reviewPractice tasksAdd and remove slidesDivide presentations into sectionsRearrange slides and sectionsApply themesChange slide backgrounds
11. Insert and manage simple graphics
Insert, move, and resize picturesEdit and format picturesDraw and modify shapesDraw and add text to shapesMove and modify shapesFormat shapesCapture and insert screen clippingsCreate a photo albumSkills reviewPractice tasksInsert, move, and resize picturesEdit and format picturesDraw and modify shapesCapture and insert screen clippingsCreate a photo album
12. Add sound and movement to slides
Animate text and pictures on slidesCustomize animation effectsAdd audio content to slidesAdd video content to slidesCompress media to decrease file sizeSkills reviewPractice tasksAnimate text and pictures on slidesCustomize animation effectsAdd audio content to slidesAdd video content to slidesCompress media to decrease file size
Part 5: Microsoft Outlook 2016
13. Send and receive email messages
Create and send messagesCreate messagesTroubleshoot message addressingSave and send messagesAttach files and Outlook items to messagesDisplay messages and message attachmentsDisplay message contentDisplay attachment contentDisplay message participant informationRespond to messagesSkills reviewPractice tasksCreate and send messagesAttach files and Outlook items to messagesDisplay messages and message attachmentsDisplay message participant informationRespond to messages
14. Organize your Inbox
Display and manage conversationsArrange messages by specific attributesCategorize itemsOrganize messages in foldersSkills reviewPractice tasksDisplay and manage conversationsArrange messages by specific attributesCategorize itemsOrganize messages in folders
15. Manage scheduling
Schedule appointments and eventsConvert calendar itemsConfigure calendar item optionsSchedule and change meetingsRespond to meeting requestsDisplay different views of a calendarSkills reviewPractice tasksSchedule appointments and eventsConvert calendar itemsConfigure calendar item optionsSchedule and change meetingsRespond to meeting requestsDisplay different views of a calendar
Index
About the authors
Acknowledgments
Survey

Overview

Now in full color!

The quick way to get started with Microsoft Office 2016!
This is learning made easy. Get more done quickly with Microsoft Word, Excel, PowerPoint, and Outlook. 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 Outlook

Format documents for visual impact

Quickly prepare personalized email messages and labels

Build powerful workbooks for analysis and reporting

Analyze alternative data sets with Quick Analysis Lens, Goal Seek, and Solver

Prepare highly effective presentations

Strengthen your presentations by adding tables and graphics

Organize your email, scheduling, and contacts

Look up just the tasks and lessons you need

Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
and much more.

Read now

Unlock full access

More than 5,000 organizations count on O’Reilly

O’Reilly covers everything we've got, with content to help us build a world-class technology community, upgrade the capabilities and competencies of our teams, and improve overall team performance as well as their engagement.

Julian F.

Head of Cybersecurity

I wanted to learn C and C++, but it didn't click for me until I picked up an O'Reilly book. When I went on the O’Reilly platform, I was astonished to find all the books there, plus live events and sandboxes so you could play around with the technology.

Addison B.

Field Engineer

I’ve been on the O’Reilly platform for more than eight years. I use a couple of learning platforms, but I'm on O'Reilly more than anybody else. When you're there, you start learning. I'm never disappointed.

Amir M.

Data Platform Tech Lead

I'm always learning. So when I got on to O'Reilly, I was like a kid in a candy store. There are playlists. There are answers. There's on-demand training. It's worth its weight in gold, in terms of what it allows me to do.

Mark W.

Embedded Software Engineer

Publisher Resources

ISBN: 9780735699717Purchase book

Cloud Computing

Data Engineering

Data Science

AI & ML

Programming Languages

Software Architecture

IT/Ops

Security

Design

Business

Soft Skills