About this course:

The course covers the features and tools that most Excel users would not necessarily need on a daily basis, but that's not you. You are a power user. You need more than the average user. In this course, students will learn how to use advanced functions, such as INDEX and MATCH, as well as the OFFSET function. We'll cover the concept of using Array Formulas and Functions, and discuss the pros and cons of using such functions. You'll learn how to build a Waterfall Chart and how to build your own dynamic ranges, as opposed to relying on simple table formatting. Finally, you will be introduced to VBA programming to augment your macros.

Course Objective:

After completing this course, students will have a working understanding of:

• The VLOOKUP
• INDEX & MATCH Functions
• Array Formulas and Functions
• Conditional Formatting Formulas
• Dynamic Ranges
• Spin Controls
• Waterfall Charts
• Pivot Table Calculations
• Pivot Table Templates
• Importing Data from the Web
• Intro to VBA

Audience: 

This course is intended for:

• People with some Excel experience looking for a refresher on most powerful features and efficiency techniques in Excel

Prerequisites:

• The students should know the basics of excel.

Suggested prerequisites courses:

• Excel 2013 Beginner