Excel Dynamic Arrays: Beginner to Expert (Excel Office 365)

Online Course

Udemy

Go to Udemy

Start Learning

What is the course about?
Prerequisites & Facts
Cost, Certificate & Degree
Reviews & Experiences

What is the course about?

Excel Dynamic Arrays: Beginner to Expert (Excel Office 365)

The course Excel Dynamic Arrays: Beginner to Expert (Excel Office 365) is an online class provided by Udemy. It may be possible to receive a verified certification or use the course to prepare for a degree.

Learn to Use Excel’s NEW Functions (FILTER, UNIQUE, SORT, XLOOKUP…) to Dramatically Simplify the Work You Do in Excel.

Course description

Excel Dynamic Arrays: Beginner to Expert (Excel Office 365)

Master Excel’s NEW Formulas (FILTER, UNIQUE, XLOOKUP, SORT, SORTBY, SEQUENCE, RANDARRAY & More Dynamic Array Functions)
Learn how to think outside the box to solve ANY Excel challenge you come across
Be the FIRST to unlock the power of Microsoft Excel’s BRAND-NEW calculation engine
Add INTERACTIVITY to your Excel reports as NEVER seen before (Create Pivot Table style reports, without using Pivot Tables)
Maximize the NEW potential in Excel and learn how to apply the new DYNAMIC ARRAYS Formulas to make YOUR files better

You HAVE OFFICE 365 & the NEW Excel Dynamic Array formulas (see the 3rd Preview lecture)
You currently use Excel and are familiar with SUM, IF & VLOOKUP functions
MAC USERS: Excel Dynamic arrays are also available in Excel for Office 365 for Mac. Please note: The course is taught for Excel on Windows. If you have a Mac, I wouldn’t be able to help you if you run into problems.

7 hours on-demand video
16 articles
29 downloadable resources
Full lifetime access
Access on mobile and TV
Certificate of Completion
Leila Gharani

Start Learning

Prerequisites & Facts

Excel Dynamic Arrays: Beginner to Expert (Excel Office 365)

Course Topic

Excel Formulas and Functions, Microsoft, Office Productivity

University, College, Institution

Udemy

Course Skill Level

see course summary

Course Language

English

Place of class

Online, self-paced (see curriculum for more information)

Degree

Certificate

Start Learning

Degree & Cost

Excel Dynamic Arrays: Beginner to Expert (Excel Office 365)

To obtain a verified certificate from Udemy you have to finish this course or the latest version of it, if there is a new edition. The class may be free of charge, but there could be some cost to receive a verified certificate or to access the learning materials. The specifics of the course may have been changed, please consult the provider to get the latest quotes and news.

Udemy

Excel Dynamic Arrays: Beginner to Expert (Excel Office 365)

provided by Udemy

Start Learning