Professional DevelopmentBrain Bites – Excel Dynamic Array Functions

Brain Bites – Excel Dynamic Array Functions

SKU: RVBB-3404
Duration: 0.48 Hrs

Once you learn the basics of this new functionality, you will never work in Excel the same way again!
Dynamic Array functions resolve many of the issues we often face in Excel, and they make it easier to do tasks that have traditionally been difficult, even for veteran Excel users.
In this fast-paced course you will learn the characteristics of these new functions and learn how to use each of the seven new functions. You’ll also learn best practices, and how to avoid a few pitfalls as well.

Request a demo

Course Details

Learning Objectives

By the end of this course, you will be able to:

  • Define dynamic array functions
  • List the characteristics of dynamic arrays
  • Use the seven new dynamic array functions
  • List the benefits of using dynamic arrays
  • Recognize potential issues and errors
  • Identify best practices
  • Use nesting functionality with dynamic array functions

Specs

Course Level Fundamental
Languages English
Compatibility Audio, Video, MobileReady, Responsive

Bigger Brains

In 2009, Bigger-Brains founder Chip Reaves was tasked with creating an online training platform for Computer Troubleshooters, a global franchise network. As is the case with most companies, some of the training content was unique to their business, but others (Quickbooks, Online Marketing, Microsoft Office, etc) could be used by many companies. Frustrated with the poor quality, high prices, and lack of selection in the eLearning marketplace, Chip brought together a team to research the characteristics of effective training. The result is Bigger Brains" "Uniquely Engaging" teacher/learner format, which replicates the dialogue, interaction, humor, and personal connection of traditional classroom training with the "always available" convenience and searchability of eLearning. Today Bigger-Brains continues to create the "Absolute Best Online Training" from our studios in Anderson, South Carolina.

Course Applies To

Demos + Pricing

Learn more about our courses, get pricing, and see our platform.

Trusted by 24,000+ Industry Leaders