Advanced Analytics - Dynamic Array Formulas in Excel 365 (HR Case Study) - Rahim Zulfiqar Ali

preview_player
Показать описание
Comprehensive Tutorial: Advanced Analytics - Dynamic Array Formulas in Microsoft #excel 365 (HR Case Study) - Rahim Zulfiqar Ali

Functions Explained: FILTER, VSTACK, CHOOSECOLS, SORT, UNIQUE, TEXTJOIN, TEXTSPLIT.
  1. Rahim Zulfiqar Ali
Рекомендации по теме
Advanced Analytics - 0:37:21

Advanced Analytics - Dynamic Array Formulas in Excel 365 (HR Case Study) - Rahim Zulfiqar Ali

Excel Dynamic Arrays 0:07:01

Excel Dynamic Arrays (How they will change EVERYTHING!)

What are excels 0:13:39

What are excels 7 new dynamic array formulas

Excel VBA - 0:04:10

Excel VBA - Dynamic Array

Data Analytics in 0:01:00

Data Analytics in Microsoft Excel using Dynamic Array Formulas #shorts

Build a Financial 0:12:14

Build a Financial Model using Dynamic Array Functions

Dynamic Array Functions 0:09:07

Dynamic Array Functions Are The Best New Excel Feature!

Chandoo Webinar: Getting 0:56:43

Chandoo Webinar: Getting started with Dynamic Array functions in Excel

DSA In Java 0:58:02

DSA In Java || Merge Sort Algorithm in Java || Coders Arcade

3 Advanced Excel 0:05:40

3 Advanced Excel Formulas You Must Know || Dynamic Array Formulas

5 Dynamic Array 0:05:22

5 Dynamic Array Gotchas in Excel

Dynamic arrays and 0:34:33

Dynamic arrays and dominoes

Dynamic Array Formula 0:04:36

Dynamic Array Formula Advanced Excel | Power of Array Formulas

Corkscrew Calculations using 0:07:20

Corkscrew Calculations using Dynamic Array Functions

What is Amortized 0:11:51

What is Amortized Time Complexity? - Dynamic Array

New Dynamic Array 0:47:58

New Dynamic Array Functions - New Excel Feature Training Tutorial

Master Excel with 0:00:24

Master Excel with these 3 array functions 🔥

Amortized Time | 0:02:23

Amortized Time | Dynamic Array

Excel Dynamic Arrays 0:10:22

Excel Dynamic Arrays and How to use them...

Learn about the 0:16:10

Learn about the *NEW* Dynamic Array Functions in Excel (Filter, Sort, Unique etc.)

Dynamic Array (DA) 0:56:42

Dynamic Array (DA) Model by LEXICON V2

Excel Dynamic Arrays: 0:17:03

Excel Dynamic Arrays: FILTER Array Function AND & OR Logical Tests (Excel Magic Trick 1529)

Get A Distinct 0:10:07

Get A Distinct Count Report With Dynamic Array Formulas!

arrays are weird 0:06:57

arrays are weird

Комментарии
Автор

Q1. Filter all Employees who are Reporting to Manager Rahim?
=VSTACK(HR_Data[#Headers], FILTER(HR_Data, HR_Data[Manager]=I4))

Q2. Filter all Employees who are Reporting to Manager Rahim having Salary >= 80, 000 & Male?
=VSTACK(HR_Data[#Headers], FILTER(HR_Data, (HR_Data[Manager]=I49)*(HR_Data[Salary]>=80000)*(HR_Data[Gender]="Male")))

Q.3 Salaries of People Reporting to Rahim ? Descriptive Analytics
=FILTER(HR_Data[Salary], HR_Data[Manager]=B74)

Q4. Filter all Employees who are Reporting to Manager Rahim (ID, Names, Gender, Age, Salary)?
=VSTACK(CHOOSECOLS(HR_Data[#Headers], {1, 2, 4, 5, 7}), FILTER(CHOOSECOLS(HR_Data, {1, 2, 4, 5, 7}), HR_Data[Manager]="Rahim"))

Q.5 Summarize Department wise based on Age Filter?
=SORT(UNIQUE(FILTER(HR_Data[Department], HR_Data[Age]>=C163)))
=COUNTIFS(HR_Data[Department], E166#, HR_Data[Age], ">="&C163)
=SORT(E166#:F166#, 2, -1)

Q.6 Find Names and No of Employees Reporting to Manager?
=TEXTJOIN(", ", TRUE, FILTER(HR_Data[Full Name], HR_Data[Manager]=B188))
=COUNTA(--TEXTSPLIT(C188, ", "))

ExcelBasement