Microsoft Office Excel 2016: Part 3 (Expert) teaches you advanced ways of collaborating with others, automating complex tasks, and predicting future potential outcomes. To begin, you’ll learn how to track, retrieve, and consolidate data in different worksheets or workbooks. You’ll master advanced auditing tools to verify data, and you will see how to evaluate formulas to correct errors. You’ll learn how to collaborate with others while protecting the integrity of your documents. You’ll advance your understanding of macros to automate tasks and practice using Sparklines to visualize data. Lastly, you’ll learn how to utilize the power of Excel to help you predict a variety of potential outcomes.

The third part of our Microsoft Office Excel 2016 series, this course is 1 hour and 40 minutes in length and will help you prepare for the Microsoft Office Specialist exams. It features easy-to-follow visual instructions, practice files, and a final quiz to advance your skills and abilities.