Description

Dynamic arrays can be a tremendous time-saver in Excel, but most business professionals remain unaware of what should be a commonly used tool. With dynamic arrays you can reduce the time you spend creating and updating formulas and improve your accuracy at the same time. You can also take advantage of some innovative features associated with dynamic arrays to automate many calculations and data entry tasks. If you’ve yet to discover dynamic arrays, make plans to participate in this session to learn how you can take advantage of this terrific feature.

Instructor: Tommy Stephens

Target Audience

Business professionals seeking to take full advantage of dynamic arrays

Course Objectives

Compare dynamic arrays to traditional formulas

• Use dynamic arrays to automate traditional calculations
• Identify examples of how you can use dynamic arrays to access external data

Subjects

Specialized Knowledge

Prerequisites

Fundamental knowledge of computer operations