Introduction

Welcome to the wonderful world of Microsoft 365 apps, formerly known as Microsoft Office! This Step by Step book has been designed to make it easy for you to learn about key aspects of four of the Microsoft 365 apps: Word, Excel, PowerPoint, and Outlook. In each part of this book, you can start from the beginning and then build your skills as you learn to perform increasingly specialized procedures. Or, if you prefer, you can jump in wherever you need guidance for performing tasks. The how-to steps are delivered crisply and concisely—just the facts. You’ll also find informative graphics that support the instructional content.

Who this book is for

Microsoft Office Step by Step is designed for use as a learning and reference resource by home and business users of Microsoft Office 365 or the individual Office apps who want to use Word, Excel, and PowerPoint to create and edit files, and Outlook to organize email, contact information, and calendar items. The content of the book is designed to be useful for people who have previously used earlier versions of the apps and for people who are discovering the apps for the first time.

The Step by Step approach

This book’s coverage is divided into parts. Part 1 introduces the Microsoft 365 apps and the skills that are common to all of them. Parts 25 each provide a thorough introduction to one of the four apps covered in this book. Each part is divided into chapters representing skill set areas, and each chapter is divided into topics that group related skills. Each topic includes expository information followed by generic procedures. At the end of the chapter, you’ll find a series of practice tasks you can complete on your own by using the skills taught in the chapter. You can use the practice files available from this book’s website to work through the practice tasks, or you can use your own files.

Features and conventions

This book has been designed to lead you step by step through tasks you’re likely to want to perform in Word, Excel, PowerPoint, and Outlook. The topics are all self-contained, so you can start at the beginning and work your way through all the procedures or reference them independently. If you have worked with previous versions of the apps, or if you complete all the exercises and later need help remembering how to perform a procedure, the following features of this book will help you locate specific information:

  • Detailed table of contents Browse the listing of the topics, sections, and sidebars within each chapter.

  • Chapter thumb tabs and running heads Identify the pages of each chapter by the thumb tabs on the book’s open fore edge. Find a specific chapter by number or title by looking at the running heads at the top of even-numbered (verso) pages.

  • Topic-specific running heads Within a chapter, quickly locate the topic you want by looking at the running heads at the top of odd-numbered (recto) pages.

  • Practice tasks page tabs Easily locate the practice tasks at the end of each chapter by looking for the full-page stripe on the book’s fore edge.

  • Detailed index Look up coverage of specific tasks and features in the index at the back of the book.

You can save time when reading this book by understanding how the Step by Step series provides procedural instructions and auxiliary information and identifies on-screen and physical elements that you interact with. The following table lists content formatting conventions used in this book.

Convention

Meaning

TIP

This reader aid provides a helpful hint or shortcut to simplify a task.

IMPORTANT

This reader aid alerts you to a common problem or provides information necessary to successfully complete a procedure.

SEE ALSO

This reader aid directs you to more information about a topic in this book or elsewhere.

1. Numbered steps

2.

3.

Numbered steps guide you through generic procedures in each topic and through hands-on practice tasks at the end of each chapter.

  • Bulleted lists

Bulleted lists indicate single-step procedures and sets of multiple alternative procedures.

Interface objects

In procedures and practice tasks, semibold black text indicates on-screen elements that you should select (click or tap).

User input

Light semibold formatting identifies specific information that you should enter when completing procedures or practice tasks.

Keyboard shortcuts

A plus sign between two keys indicates that you must select those keys at the same time. For example, “press Ctrl+P” directs you to hold down the Ctrl key while you press the P key.

Emphasis and URLs

In expository text, italic formatting identifies web addresses and words or phrases we want to emphasize.

Download the practice files

Before you can complete the practice tasks in this book, you must download the book’s practice files to your computer from MicrosoftPressStore.com/MSOfficeSBS365/downloads. Follow the instructions on the webpage.

images Important

Word, Excel, PowerPoint, Outlook, and other Microsoft 365 apps are not available from the book’s website. You should install the apps before working through the procedures and practice tasks in this book.

You can open the files that are supplied for the practice tasks and save the finished versions of each file. If you want to repeat practice tasks later, you can download the original practice files again.

images See Also

For information about opening and saving files, see “Open and move around in files” and “Save and close files” in Chapter 2, “Create and manage files.”

The following table lists the files available for use while working through the practice tasks in this book.

Chapter

Folder

File

Part 1: Microsoft Office (Microsoft 365 Apps)

1: Explore Office

Office365SBSCh01

None

2: Create and manage files

Office365SBSCh02

DisplayProperties.xlsx

DisplayViews.pptx

NavigateFiles.docx

Part 2: Microsoft Word

3: Modify the structure and appearance of text

Office365SBSCh03

ApplyStyles.docx

ChangeTheme.docx

CreateLists.docx

FormatCharacters.docx

FormatParagraphs.docx

StructureContent.docx

4: Collaborate on documents

Office365SBSCh04

ControlChanges.docx

MergeDocs1.docx

MergeDocs2.docx

ReviewComments.docx

TrackChanges.docx

5: Merge data with documents and labels

Office365SBSCh05

CreateEnvelopes.docx

CustomerList.csv

CustomerList.xlsx

InsertFields.docx

PolicyholdersList.xlsx

RefineData.docx

StartMerge.docx

Part 3: Microsoft Excel

6: Perform calculations on data

Office365SBSCh06

AuditFormulas.xlsx

BuildFormulas.xlsx

CreateArrayFormulas.xlsx

CreateConditonalFormulas.xlsx

NameRanges.xlsx

SetIterativeOptions.xlsx

7: Manage worksheet data

Office365SBSCh07

FilterData.xlsx

SummarizeValues.xlsx

ValidateData.xlsx

8: Reorder and summarize data

Office365SBSCh08

CustomSortData.xlsx

OutlineData.xlsx

SortData.xlsx

9: Analyze alternative data sets

Office365SBSCh09

CreateScenarios.xlsx

DefineDataTables.xlsx

PerformGoalSeekAnalysis.xlsx

Part 4: Microsoft PowerPoint

10: Create and manage slides

Office365SBSCh10

AddRemoveSlides.pptx

ApplyThemes.pptx

ChangeBackgrounds.pptx

CreateSections.pptx

ImportOutline.docx

RearrangeSlides.pptx

ReuseSlides.pptx

11: Insert and manage simple graphics

Office365SBSCh11

AccreditPictures.pptx

Bouquets.jpg

DrawShapes.pptx

EditPictures.pptx

InsertIcons.pptx

InsertPictures.pptx

InsertScreens.pptx

Penguins01.jpg

Penguins02.jpg

PinkFlowers.jpg

PurpleFlowers.jpg

RedTree.jpg

Tiger01.jpg

Tiger02.jpg

WhiteFlower.jpg

12: Add sound and movement to slides

Office365SBSCh12

AddAudio.pptx

AddVideo.pptx

AnimateSlides.pptx

Butterfly.wmv

CustomizeAnimation.pptx

SoundTrack.wma

Wildlife.wmv

Part 5: Microsoft Outlook

13: Send and receive email messages

Office365SBSCh13

AttachFiles.docx

14: Organize your Inbox

Office365SBSCh14

None

15: Manage scheduling

Office365SBSCh15

None

E-book edition

If you’re reading the e-book edition of this book, you can do the following:

  • Search the full text

  • Print

  • Copy and paste

You can purchase and download the e-book edition from the Microsoft Press Store at MicrosoftPressStore.com/MSOfficeSBS365/detail.

Get support and give feedback

We’ve made every effort to ensure the accuracy of this book and its companion content. We welcome your feedback.

Errata and support

If you discover an error, please submit it to us at MicrosoftPressStore.com/MSOfficeSBS365/errata. We’ll investigate all reported issues, update downloadable content if appropriate, and incorporate necessary changes into future editions of this book.

For additional book support and information, please visit MicrosoftPressStore.com/Support.

For assistance with Microsoft software and hardware, visit the Microsoft Support site at support.microsoft.com.

Stay in touch

Let’s keep the conversation going! We’re on Twitter at twitter.com/MicrosoftPress.

..................Content has been hidden....................

You can't read the all page of ebook, please click here login for view all page.
Reset
18.220.160.216