Excel 2016 Advanced – Level 3

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

Related Courses

X