Joan Lambert has worked closely with Microsoft technologies since 1986, and in the training and certification industry since 1997, guiding the translation of technical information and requirements into useful, relevant, and measurable resources for people seeking certification of their computer skills or who simply want to get things done efficiently. She has written more than 50 books about Windows, Office, and SharePoint technologies, including dozens of Step by Step books and several generations of Microsoft Office Specialist certification study guides. Students who use the GO! with Microsoft Office textbook products from Pearson may overhear her cheerfully demonstrating Office features in the videos that accompany the series. A native of the Pacific Northwest, Joan has had the good fortune to live in many parts of the worldincluding Germany, New Zealand, Sweden, and Denmarkand many of our United States. She currently resides with her familyone daughter, two dogs, two cats, and seven chickensin the Beehive State, where she enjoys the majestic mountain views, mostly blue skies, and occasional snowstorm.

Curtis Frye is the author of more than 30 books, including Microsoft Excel 2019 Step by Step and Microsoft OneNote Step by Step for Microsoft Press. He has also created and recorded more than 90 online training courses for [...] and LinkedIn Learning on topics such as Excel data analysis; supply chain, transportation, and inventory problems; and data visualization using Tableau. He lives in Portland, Oregon, with his wife, Virginia.

Part 1: Microsoft Office (Microsoft 365 Apps)

1: Explore Office

2: Create and manage files

Part 2: Microsoft Word

3: Modify the structure and appearance of text

4: Collaborate on documents

5: Merge data with documents and labels

Part 3: Excel

6: Perform calculations on data

7: Manage worksheet data

8: Reorder and summarize data

9: Analyze alternative data sets

Part 4: PowerPoint

10: Create and manage slides

11: Insert and manage simple graphics

12: Add sound and movement to slides

Part 5: Microsoft Outlook

13: Send and receive email messages

14: Organize your Inbox

15: Manage scheduling

Appendix: Keyboard shortcuts