Office
1. Introduction to Microsoft Office 2016Â Features
Excel
Introduction to Microsoft Excel 2016
1. Creating a Worksheet and Charting Data
2. Using Functions, Creating Tables, and Managing Large Workbooks.
3. Analyzing Data with Pie Charts, Line Charts, and What-If Analysis Tools
4. Use Financial and Lookup Functions, Define Names, Validate Data, and Audit Worksheets
5. Managing Large Workbooks and Using Advanced Sorting and Filtering
6. Creating Charts, Diagrams, and Templates
7. Creating PivotTables and PivotCharts
8. Using the Data Analysis, Solver, and Scenario Features, and Building Complex Formulas
9. Using Macros and Visual Basic for Applications
10. External Data, Database Functions, and Side-by-Side Tables
11. Collaborating with Others and Preparing a Workbook for Distribution
