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.
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.
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 2–5 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.
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 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. |
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.
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.
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 |
---|---|---|
1: Explore Office | Office365SBSCh01 | None |
2: Create and manage files | Office365SBSCh02 | DisplayProperties.xlsx DisplayViews.pptx NavigateFiles.docx |
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 |
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 |
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 |
13: Send and receive email messages | Office365SBSCh13 | AttachFiles.docx |
14: Organize your Inbox | Office365SBSCh14 | None |
15: Manage scheduling | Office365SBSCh15 | None |
If you’re reading the e-book edition of this book, you can do the following:
Search the full text
Copy and paste
You can purchase and download the e-book edition from the Microsoft Press Store at MicrosoftPressStore.com/MSOfficeSBS365/detail.
We’ve made every effort to ensure the accuracy of this book and its companion content. We welcome your feedback.
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.
Let’s keep the conversation going! We’re on Twitter at twitter.com/MicrosoftPress.
18.220.160.216