All   >   Brain Bites – Excel Dynamic Array Functions

Brain Bites – Excel Dynamic Array Functions

Once you learn the basics of this new functionality, you will never work in Excel the same way again!

Course details

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.  

 

Learn how to create and use the new UNIQUE, SORT, SORTBY, FILTER, RANDARRAY, TRANSPOSE, and SEQUENCE functions. You’ll also see how to nest these functions with each other as well as with non-array functions, and learn how this functionality applies to other functions as well. By the end of this course, you will be amazed how this fundamental change in how Excel runs and performs calculations will help you streamline your spreadsheets. 

 

 

Topics covered include: 

  • Defining dynamic array functions 
  • Listing the characteristics of dynamic arrays  
  • Using the seven new dynamic array functions  
  • Listing the benefits of using dynamic arrays 
  • Recognizing potential issues and errors 
  • Identifying best practices 
  • Using nesting functionality with dynamic array functions 

 

 

Quickly search and find the skills you want to master from our list of lessons – then just point, click, and learn. 

 

Enjoy high-quality HD content in the “Uniquely Engaging”TM Bigger Brains Teacher-Learner style! 

 

Taught by top subject matter experts, Bigger Brains courses are professionally designed around key learning objectives, and include captions and transcripts in 29 languages, downloadable handouts, and optional LinkedIn digital badges on course completion. 

Course Contents:

#  Lesson  Length 
1  Intro to Dynamic Arrays  3:07 
2  UNIQUE, FILTER  5:45 
3  SORT, SORTBY, TRANSPOSE  4:06 
4  RANDARRAY, SEQUENCE  5:37 
5  Pros, Cons, Best Practices  6:17 
6  Additional Functionality  4:49 

Course details

Related Course Recommendations

AI Fluency – Intro to Prompts

AI Fluency - Intro to Prompts

Brain Bites – A Beginner’s Guide to Computers

A Beginner's Guide to Computers Course Image

Brain Bites – Unlocking Your Emotional Intelligence Potential

Unlocking Your Emotional Intelligence Potential

Brain Bites – Robert’s Rules of Order

Robert's Rules of Order

Bigger Brains Course Catalog and Pricing

Fill out the information below to receive a download link for our latest course catalog.

I am getting training for…