Excel 2016 Advanced – Level 3
Course Duration: 1 Day
Audience profile
Students who have intermediate skills with Microsoft Excel 2016 who want to learn more advanced skills or students who want to learn the topics covered in this course in the 2016 interface.
Prerequisites: Intermediate level of Excel.
Review
- Absolute Reference
- Simple IF Formula
Formulas
- Using Absolute and Mixed Reference in Formulas
- SUMIFS
- IF(S) (nested and combined with AND and OR)
- VLOOKUP
- INDEX and MATCH
Conditional Formatting and Formulas
- Using basic Conditional Formatting
- Applying Data Bars and Icon Sets
- Using formulas to drive Conditional Formatting
Recording and Using Macros
- Recording Absolute and Relative Reference Macros
- Running Macros
- Adding Macros to the Quick Access Toolbar
Introduction to Pivot Tables (Time Permitting)
- Static vs Dynamic Source Data
- Creating a Pivot Table report
- The Pivot Table user interface
- Basic Pivots and the 4 Quadrants