Excel Dynamic Arrays - Beginner to Expert (Microsoft 365) (Udemy.com)

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

4.9
( 216 Reviews )

Created by: Leila Gharani

Produced in 2021

icon
What you will learn

  • 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 Excels 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
  • Get lifetime access to a proven and State-Of-The-Art Excel course including challenges, quizzes & exercises

icon
Quality Score

Content Quality
/
Video Quality
/
Qualified Instructor
/
Course Pace
/
Course Depth & Coverage
/

Overall Score : 98 / 100

icon
Course Description

ata analysis in Excel for Microsoft 365 has become simpler than ever. We have NEWExcel functions like XLOOKUP, FILTER, SORT, UNIQUE, SEQUENCE and MORE!
PLUS: Microsoft has changed Excels calculation engine.
This change impacts EVERYONE who uses Microsoft 365 version: Beginner to Advanced Excel users.
There are MULTIPLE ways you can apply Dynamic Arrays and the NEW Excel Functions to YOUR Files. This courseshows you how toMAXIMIZE the NEW Potential in Excel 365!
For example:
Use Excel's new FILTER Function to find multiple match resultsUse Excel's new XLOOKUP function for complex lookups (no more VLOOKUP or Index Match)Create Excel Dashboard reports in MINUTES instead of HOURSCreate Pivot Table style reports, without using Pivot Tables - no need to press "refresh" this wayQuickly create dynamicloan amortization reports in Excel or dynamic calendarsMaster the new UNIQUE, SORT & SORTBY Excel FunctionsUse the brand new Excel RANDARRAY Function to randomly sort listsUse VLOOKUP, IF and SUMIFS together with Excel Dynamic Arrays formulasIn addition you'll learn:
How to add Interactivity to your Excel reports as never done beforeHow to use the new Dynamic Arrays formulas in your filesHow Excel's calculation engine has changed and how this impacts all existing formulasCompatibility & how older files behave in the new Excel and New Excel files in the old ExcelDo Dynamic Arrays make our spreadsheets faster or slower?
Use Dynamic Array referencing as Excel chart rangesSolve difficult problems - such as split text and numbers from alphanumeric values & much more...
Most importantly - how to think outside the box to solve any challenges you come acrossBut First:*** HOW TO CHECK IF YOUR EXCEL VERSION HAS DYNAMIC ARRAYS ***Do you have Excel for Microsoft 365? Then you already have dynamic arrays and the new Excel functions. Check out the free preview video called "Do you have Dynamic Arrays?" and do the test outline in the video.
If you don't have dynamic arrays BUT you have Excel for Microsoft 365 run the latest update to install the new features.
But please note: Excel dynamic arrays will NOT be a part of Excel 2010, Excel 2013, Excel 2016 or EVEN Excel 2019. Only in Excel 365 or Excel on the web.*** WHY TAKE THIS SPECIFIC EXCEL COURSE? ***Excel Dynamic Arrays are brand-new. Complex tasks will now be done with SIMPLE Excel formulas. Everything you wished Excel could do, can now be done!
In this course you'll solve dozens of practical real-world examples. They'll help you think outside the box so you can work smarter not harder. In the course you will get: Excel Practice & Solutions Workbooks for each section Course notes outlining the MOST IMPORTANT Concepts Quiz questions to test your understanding*** WHY WOULD YOU CHOOSE TO LEARN EXCEL? ***Excel can do so much for your career. It's just one program but it's the one hiring managers are interested in.
Thats why basic Excel skills is a mandatory requirement for most office-based professionals today.
Superior Microsoft Excel skills can get you a promotion. Some jobs require that to begin with.*** WHICH VERSION OF EXCEL IS USED IN THE COURSE? ***The course is applicable ONLY for Excel for Microsoft 365 (Also available for Excel on the Web). Dynamic Arrays will NOT be part of Excel 2019 perpetual license.*** Feedback from our students *** "I highly recommend this well-organized course for anyone whose work/projects involve data analysis. The knowledge I've gained on the new dynamic array functions will raise the level of my analysis while making my work easier at the same time. The new functions are well explained with business examples, and the course notes will be a great reference!" Jennifer This course is magical. I am sure everyone using Excel will have to upgrade their knowledge soon. Thanks for the enlightening journey. Dheeraj Very well organized and implemented course. It was easy to follow along yet challenging enough to learn. As an example, I had never used the CHOOSE function which was your solution in one of the advanced challenges. Still wanting to try and figure out the solution on my own (without seeing yours first), I tried watching a video from another YouTube instructor on that specific function. Unfortunately, I didn't really get it until I watched your instruction. The way you break down the components of a complex formula, showing various examples of how they work, before building up to the complete solution is a great method of teaching. Your advice for spilling component results next to the source data is an excellent method for troubleshooting formula problems...
if I could only get the hang of it and remember to do it! Stephanie I give you a big 10 for the explanation of this course, I learned a lot from it. JosThere's a 100% money back guarantee. You have nothing to lose. Check out the lectures inside and see if you can apply the techniques to your work.
The course comes with lifetime access. Buy now. Watch anytime.
Who this course is for:
Business Professionals who use Excel to analyze data & create reportsYou'd like a complete course to understand ALL there is to Excel's NEW Calculation engineYou'd like to learn how to create interactive reports with Excel dynamic array formulas
Read More product length iconTime: 7h

icon
Instructor Details

Leila Gharani

Leila Gharani is a Microsoft MVP (Most Valuable Professional) dedicated to helping you create outstanding tools and reports in Excel & Google Sheets. Her courses are for those who want to shine at work, accelerate their careers and achieve more in less time.
Leila' background is Masters in Economics, Economist, Consultant, Oracle HFM Accounting Systems Expert & Project Manager. For over 15 years she has worked in the Finance and ITdepartments implementing reporting systems based on Oracle and SAP. All the while using Excel VBAto automate and improve processes.
Since 5 years, Leila runs her own site and has an active YouTube channel with many engaging, high quality videos. She provides customized spreadsheet dashboard seminars and enhanced visualization techniques to large corporations. She also teaches at the University of Applied Sciences in Upper Austria.
Her courses include examples based on her experience as well as the consulting work she has done for international companies. Many of the Excel tips and tricks she shares is based on the questions received from experienced professionals in her Excel training sessions.
She places great value on keeping her courses not only informative but also engaging. For this reason, students will find enough challenges, exercises and downloadable files to practice so they can maximize the value gained from each course.
Leila's passion is learning, sharing and sol

Read More

icon
More courses by Leila Gharani

Unlock Excel VBA and Excel Macros

$11.99

Excel Essentials for the Real World (Complete Excel Course)

$11.99

Excel Charts: Visualization Secrets for Impressive Charts

$11.99

Ultimate Excel Waterfall Chart Course

$11.99

Advanced Excel: Top Excel Tips & Formulas

$11.99

Visually Effective Excel Dashboards

$11.99

All courses by Leila Gharani

icon
More excel courses

Excel Skills for Business: Essentials

Free

Excel Skills for Business: Intermediate I

Free

Visually Stunning Microsoft Excel Dynamic Dashboard Course

$11.99

Excel with Top Microsoft Excel Hacks

$11.99

Microsoft Excel Complete Excel Guide (Excel 2007 2021)

$11.99

Excel Essentials: The Complete Excel Series - Level 1, 2 & 3

$11.99

All excel courses

icon
Reviews

4.9

216 total reviews

5 star 4 star 3 star 2 star 1 star
% Complete
% Complete
% Complete
% Complete
% Complete
Reset Filter
Write a Review arrow

By Donald Turrell on 11/22/2020

As with her other courses, I find her content to be very informative and her delivery is great for my leaning style.

By Roberto Fisanotti on 11/15/2020

I'm always sure that Leila's lessons are profitable. I had to wait because my previous Excel version did not manage Dynamic Arrays. This is a very good course. I can only suggest it.

By Mark Wenzel on 11/15/2020

Great course!

By Sultan alharbi on 11/15/2020

Amazing, above expectations!

By Ruben Rositto on 11/8/2020

I definitely should have done it before! I have been an experienced excel user for years, I knew the subject but was hesitant in some calculations with the new features. Of course I was solving them one by one, usually with some help from Leila on his YouTube channel, until I said enough! The best money invested, if you are in my situation, do not hesitate!
Leila is extraordinary pedagogically and evidently has gone through the same problems that several of us in consulting, which makes her tips very rich.
In this course some parts are a bit slow because I try to give it for several levels, I think it is the only mistake. The expert user sees it slow and with much more to see (especially with Leila as instructor!!) and for the rest, may be difficult to follow.
But, it is definitely worth it, for both with more or less effort.

By Syed Nuzhat Ali on 11/8/2020

excellent

By John Purcell on 11/8/2020

Detailed and professional presentation from a delightful presenter

By Gianluca Tavella on 11/1/2020

Ottimo corso, Leila spiega benissimo

By Priya Ranjan on 11/1/2020

The course material was of real help to understand how array behave in excel, and I really liked the part where you explained One Array theory for excel and Array Logic and also lifting and pairwise lifting. The process of making formulae from scratch was also very helpful to understand what happens behind the formula

By Jos Martnez Santana on 10/24/2020

It's been very useful. Leila gives different methodologies and examples where you can apply the dynamic functions of Excel.

By Chad Twombly on 10/23/2020

Good information, going a little fast, but I am keeping up.

By Ralf Gbel on 10/23/2020

Hervorragend prsentierte Inhalte und Unterlagen. Der Kurs lsst aus meiner Sicht kaum Wnsche offen.

Load More

Excel Dynamic Arrays - Beginner to Expert (Microsoft 365)
Visit Course Write a Review
  • Video Duration: icon 7h
  • Price: 11.99 Track Price 11.99 Track Price
  • Provider: icon Udemy
  • Year: icon 2021
  • Language: icon English
  • Certificate: icon Yes
30-Day Money-Back Guarantee

Udemy Coupon Price Tracker

For any issues or feature requests please email CourseDuck's Co-Founder at michaelk@courseduck.com