Mastering Excel 2016
If you’ve mastered Microsoft Excel 2016, then you have one of the most practical and valuable skill sets in all of the modern business. 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 covers everything you need to know about Microsoft Excel 2016, from the very basics to the most advanced features and functions.
Note: This course covers all the objectives required in the Microsoft Office Specialist exam 77-727
- Navigating Excel’s interface
- Formatting text, numbers, and cells
- Functions and formulas basics
- Managing workbook properties
- Sorting, filtering, and summarizing data
- Pivot Tables and Pivot Charts
- Scenarios and Goal Seek
- Macros
- Data Forms and Form Controls
