Udemy
    •  
    •  
    •  
    •  
    •  
    •  
    •  
    •  
Subscribe
Turn what you know into an opportunity and reach millions around the world.
Learn More
Your cart is empty.
Keep shopping
Dynamic Arrays in Excel
Rating: 4.4 out of 5(31 ratings)
2,714 students

Dynamic Arrays in Excel

How to apply formulas to cell ranges
Created bySONIC Performance Support - E-Learning Experts
Last updated 1/2023
English

What you'll learn

  • Discover helpful array formulars in Excel.
  • Learn about dynamic arrays in Excel.
  • Upon successful completion of this course, you will be able to leverage the power of dynamic arrays in order to simplify your work and save a lot of time.
  • Learn about the exciting new functions XLOOKUP, FILTER, UNIQUE, SORT, SORTBY, SEQUENCE and RANDARRAY.

Course content

1 section • 5 lectures • 55m total length

  • Dynamic Arrays in Excel 3653:24

    Discover new, helpful array formulas in Excel 365. In this introduction, you will get a brief overview and valuable tips on when and how to use the new formulas.

  • XLOOKUP8:33

    To combine information from two tables, you can use the already known VLOOKUP or the new XLOOKUP function. With XLOOKUP you can flexibly find content to the left or right of the search criterion and have several pieces of information transferred to different columns at once.

  • FILTER and UNIQUE18:59

    The FILTER function allows you to output data records at a different location while keeping the data related to the initial values. You can now create data extracts that are automatically updated. The UNIQUE function lets you pick out the unique values from a list or range. For example, you can create drop-down fields whose selection is automatically completed

  • SORT and SORTBY11:35

    The new functions SORT and SORT BY now realize the automatic sorting of the data and they also output sorted results at other positions. Thus, you only have to execute each sorting once, Excel will then do the updating for you.

  • SEQUENCE and RANDARRAY12:59

    Use the SEQUENCE function to automatically number records in tables. When changes are made, the numbering is adjusted automatically. With the RANDARRAY function, you can display random values from a range that you specify.

Requirements

  • This training has been designed and built for advanced Excel users. In order to complete this training successfully, you should have sufficient knowledge of Excel.
  • Dynamic arrays are only available in Microsoft Excel 365 (and Excel 2021). Please make sure you have an appropriate subscription model or license.

Description

COURSE DESCRIPTION

In this course you will discover helpful dynamic array formulas in Excel 365. Learn about the exciting new functions XLOOKUP, FILTER, UNIQUE, SORT, SORTBY, SEQUENCE and RANDARRAY. Understand which problems you can easily solve thanks to the new functions.


THIS COURSE IS SUITABLE FOR YOU, IF

· you already have advanced knowledge in Excel

· you wish to take advantage of some of the higher-level functionality in Excel


PREREQUISITES

· This training has been designed and built for advanced Excel users. In order to complete this training successfully, you should have sufficient knowledge of Excel.

· Dynamic arrays are only available in Microsoft Excel 365 (and Excel 2021). Please make sure you have an appropriate subscription model or license.


METHOD

· Your trainer will guide you through the various concepts and functions in an easy-to-understand, step-by-step manner. If necessary, you can pause videos or even rewind and watch them again.


COURSE OBJECTIVES

Upon successful completion of this course, you will be able to leverage the power of dynamic arrays in order to simplify your work and save a lot of time. The following functions are covered in this course:

· XLOOKUP

· FILTER

· UNIQUE

· SORT

· SORT BY

· SEQUENCE

· RANDARRAY


TRAINING SCOPE

5 Training Videos (Run time: 55 minutes)

The trainer will introduce you to the topics and then explain the functions in Excel step by step. All training videos have English subtitles.

Who this course is for:

  • Advanced Excel users and Excel experts

Report abuse