book

Microsoft Office Step by Step (Office 2021 and Microsoft 365)

by Joan Lambert, Curtis Frye

June 2022

Beginner

560 pages

11h 47m

English

Microsoft Press

Read now

Unlock full access

Who this book is forThe Step by Step approachFeatures and conventionsDownload the practice filesE-book editionGet support and give feedback
Work in the Office user interfaceDiscover new featuresChange Office and app optionsDisplay and customize the Quick Access ToolbarCustomize the ribbonGet help and provide feedbackKey pointsPractice tasks
Create filesOpen and move around in filesDisplay different views of filesDisplay and edit file propertiesSave and close filesKey pointsPractice tasks
Apply paragraph formattingApply character formattingStructure content manuallyCreate and modify listsApply built-in styles to textChange the document themeKey pointsPractice tasks
Mark up documentsDisplay and review document markupCompare and combine documentsControl content changesCoauthor documentsKey pointsPractice tasks
Understand the mail merge processStart the mail merge processChoose and refine the data sourceInsert merge fieldsPreview and complete the mergeCreate individual envelopes and labelsKey pointsPractice tasks
Name data rangesCreate formulas to calculate valuesSummarize data that meets specific conditionsCopy and move formulasCreate array formulasFind and correct errors in calculationsConfigure automatic and iterative calculation optionsKey pointsPractice tasks
Filter data ranges and tablesSummarize filtered dataEnforce data entry criteriaKey pointsPractice tasks
Sort worksheet dataSort data by using custom listsOutline and subtotal dataKey pointsPractice tasks
Define and display alternative data setsForecast data by using data tablesIdentify the input necessary to achieve a specific resultKey pointsPractice tasks
Add and remove slidesApply themesChange slide backgroundsDivide presentations into sectionsRearrange slides and sectionsKey pointsPractice tasks
Insert, move, and resize picturesEdit and format picturesProvide additional information about picturesCreate a photo albumInsert and format iconsDraw and modify shapesKey pointsPractice tasks
Animate text and pictures on slidesCustomize animation effectsAdd audio content to slidesAdd video content to slidesCompress media to decrease file sizeKey pointsPractice tasks
Create and send messagesAttach files and Outlook items to messagesDisplay messages and message attachmentsDisplay message participant informationRespond to messagesKey pointsPractice tasks
Display and manage messagesArrange messages by specific attributesCategorize itemsOrganize messages in foldersPrint messagesKey pointsPractice tasks
Display different views of a calendarSchedule appointments and eventsConvert calendar itemsConfigure calendar item optionsSchedule and change meetingsRespond to meeting requestsKey pointsPractice tasks

Overview

The quick way to learn popular Microsoft 365 apps!

This is learning made easy. Get more done quickly with Microsoft Word, Excel, PowerPoint, and Outlook. Jump in wherever you need answersbrisk lessons and detailed screenshots show you exactly what to do, step by step.

Discover new time-savers and usability improvements for Word, Excel, PowerPoint, and Outlook

Format and organize high-impact documents and use Words enhanced coauthoring tools

Build powerful, reliable Excel worksheets and analyze complex data sets

Prepare highly effective presentations with PowerPoints newest visual tools

Improve your productivity with Outlook email, scheduling, and contacts

Make the most of the latest Accessibility Checker and other new features

Look up just the tasks and lessons you need

Download your Step by Step practice files at:

MicrosoftPressStore.com/MSOfficeSBS365/downloads

...