Mastering Excel 2016 – Intermediate
If you’ve mastered Microsoft Excel 2016, then you’re ready for this course. A spreadsheet guru can work wonders–from organizing lists to creating multi-layered, interactive reports, to revealing answers to business-critical questions like ROI, budget allocations, tracking expenditures, and more. This course builds on your existing knowledge of Excel basics and teaches you how to manage data, charts, and tables, and how to use powerful tools such as pivot tables, Pivot Charts, Slicers, Timelines, and more.
Note: When combined with the Basics and Advanced versions of this course, these cover all the objectives required in the Microsoft Office Specialist exam 77-727
- Working with Functions
- Working with Lists
- Analyzing Data
- Visualizing Data with Charts
- Using Pivot Tables and Pivot Charts