Secrets of the Office Guru (2019)

Learn practical, productivity-boosting tips and tricks that will turn experienced Microsoft Office users into experts  

We asked our Microsoft Office experts to pick the topics they felt would be most beneficial to experienced Microsoft Office users. As a result of their picks, we created a course that will deliver the most useful information to you, all in one course. 

In Word, learn how to use advanced formatting techniques such as themes and styles, and reuse your content with templates. You’ll even learn how to incorporate graphics such as SmartArt and WordArt into your documents. In Excel, our teachers will show you how to use tables, sort and filter data, create charts, and use advanced What If analysis tools. 

In PowerPoint, you’ll learn how to edit pictures and graphics and customize animation, including using bookmarks. If you haven’t used OneNote before, you’ll learn how to set up and share Notebooks, and integrate them with other Office apps. And in Outlook, you’ll learn some time-saving tricks to track messages, automate content, customize your calendar, and track tasks. 

Follow along with each of our Microsoft teachers as they help you become the Office expert! 

Topics covered include: 

• Applying and modifying themes and styles in Word 
• Creating templates and tables in Word and using graphics 
• Creating and modifying tables and charts in Excel 
• Manipulating data in Excel 
• Working with What If analysis in Excel, including data tables and Goal Seek 
• Customizing animation in PowerPoint 
• Adding and modifying graphics in PowerPoint 
• Using OneNote with Word and Outlook 
• Sharing OneNote notebooks 
• Creating automated message content in Outlook 
• Tracking messages and setting up folders in Outlook 
• Scheduling meetings and managing tasks in Outlook 

Note: These modules are highlights from our Word 2016, Excel 2016, PowerPoint 2016, OneNote 2016, and Outlook 2016 courses. For a more in-depth look at any features covered here, be sure to check out those courses. 

Almost six hours of high-quality HD content in the “Uniquely Engaging”TM Bigger Brains Teacher-Learner style!