Joan Lambert has worked closely with Microsoft technologies since 1986, and in the training and certification industry since 1997. As President and CEO of Online Training Solutions, Inc. (OTSI), Joan guides the translation of technical information and requirements into useful, relevant, and measurable resources for people who are seeking certification of their computer skills or who simply want to know how to get things done [...] is the author or coauthor of more than four dozen books about Windows and Office (for Windows, Mac, and iPad), five generations of Microsoft Office Specialist certification study guides, video-based training courses for SharePoint and OneNote, QuickStudy guides for Windows and Office, and the GO! series book for Outlook 2016.Blissfully based in America’s Finest City, Joan is a Microsoft Certified Professional, Microsoft Office Specialist Master (for all versions of Office since Office 2003), Microsoft Certified Technology Specialist (for Windows and Windows Server), Microsoft Certified Technology Associate (for Windows), Microsoft Dynamics Specialist, and Microsoft Certified Trainer.

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