登录查看更多内容

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

Rahim Zulfiqar Ali

Founder & CEO Excel Basement, MS Excel, POWER BI, Python Trainer & Consultant, MBA (MIS), MCT, MSOM, ReSkills Coach, Emerging Data Scientist

发布日期: 2025年2月18日

+ 关注

Functions Explained: FILTER, VSTACK, CHOOSECOLS, SORT, UNIQUE, TEXTJOIN, TEXTSPLIT.

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

CLICK HERE

Microsoft Excel 365

44,004 位关注者

Abdul Rehman Makki

Microsoft Power Platform Architect | Solution Designer | Low-Code/No-Code Expert | Digital Transformation Leader

6 天前

excellent

1 次回应

Luis Eduardo Toledo Díaz

Ingeniero Especialista en MICROGLOBAL, para proyecto Spence/BHP | Proyecto SCTWP2 de SPENCE, preparando etapas de FAT / PRECOM / COM y Start Up

1 周

Excelent explanation, very useful tips. many thanks

1 次回应

Hedy kamoun

Responsable supervision des flux

1 周

Intéressant

1 次回应

Shanoj Kanhirala

Sr. QS - NEOM PMC (AECOM Arabia) | Cost & Commercial Management | Contract Administration

1 周

useful

1 次回应

Christophe Sielienou

Finance Manager

1 周

Useful tips. Thank you

1 次回应

查看更多评论

要查看或添加评论，请登录

Rahim Zulfiqar Ali的更多文章

Admissions Open! Live Online EXCEL 365 Classes Training | Become Awesome Analyst - April 2025 Batch

2025年2月27日

Admissions Open! Live Online EXCEL 365 Classes Training | Become Awesome Analyst - April 2025 Batch

Hi, Admissions Open ??? New Batch | Microsoft EXCEL 365 - Online Live Classes - April 2025 Duration - 6 Weeks, 24 Hours…
Admissions Open! Live Online POWER BI Classes Training | Become Awesome as Analyst & BI Professional - April 2025 Batch

2025年2月26日

Admissions Open! Live Online POWER BI Classes Training | Become Awesome as Analyst & BI Professional - April 2025 Batch

Hi, Admissions Open ??? New Batch | Microsoft POWER BI - Online Live Classes - April 2025 Duration - 6 Weeks, 24 Hours…

5 条评论
Courier Delivery Process Flow / Tracker | HR Hiring an Employee Tracker in Excel 365 Version

2025年2月26日

Courier Delivery Process Flow / Tracker | HR Hiring an Employee Tracker in Excel 365 Version

Progress % =COUNTIF(C4:F4,TRUE)/COUNTA(C4:F4) Status =IF(I4=TRUE,"Returned",XLOOKUP(FALSE,C4:F4,$C$3:$F$3,"Delivered"))…

2 条评论
Fuzzy Lookup (POWER QUERY) Approximate Match for Text in Microsoft Excel

2025年2月25日

Fuzzy Lookup (POWER QUERY) Approximate Match for Text in Microsoft Excel

Fuzzy Lookup (POWER QUERY) Approximate Match for Text in Microsoft Excel Happy Learning!

4 条评论
POWERBI: Create MTD / QTD / YTD Time Intelligence Slicer & Dynamic Title | Visual to Show both VALUES & PERCENT | Data Labels | Column or Bar Chart

2025年2月24日

POWERBI: Create MTD / QTD / YTD Time Intelligence Slicer & Dynamic Title | Visual to Show both VALUES & PERCENT | Data Labels | Column or Bar Chart

How to Create MTD / QTD / YTD Time Intelligence Slicer & Dynamic Title Visual to Show both VALUES and PERCENT - Data…

11 条评论
Learn Advanced Descriptive Analytics in Excel | Examples of Human Resources Dataset | 6 Questions

2025年2月20日

Learn Advanced Descriptive Analytics in Excel | Examples of Human Resources Dataset | 6 Questions

Learn Advanced Descriptive Analytics in Excel | Examples of Human Resources Management Dataset | 6 Questions 1. 10…

5 条评论
Become Awesome & Learn Modern Excel 365 | Online Course | Big Discount | Mar 2025 | Lifetime Access!

2025年2月19日

Become Awesome & Learn Modern Excel 365 | Online Course | Big Discount | Mar 2025 | Lifetime Access!

Modern Excel Course for Data & Business Analysts Professionals & Students CLICK HERE | Last date to avail Discount by…
Sales Analytical Dashboard using Data Analysis Expressions (DAX) & Visualizations + Tips in Excel

2025年2月19日

Sales Analytical Dashboard using Data Analysis Expressions (DAX) & Visualizations + Tips in Excel

Advanced Sales Analytical #Dashboard using Data Analysis Expressions (DAX) & #Visualizations Rules + Tips in Microsoft…

4 条评论
How to Create Calendar Dimension Table in EXCEL POWER PIVOT with Just One Click ? And How to Convert Fiscal Calendar (Years, Months & Quarters) Slicer

2025年2月18日

How to Create Calendar Dimension Table in EXCEL POWER PIVOT with Just One Click ? And How to Convert Fiscal Calendar (Years, Months & Quarters) Slicer

How to Create Calendar Dimension Table in EXCEL POWER PIVOT with Just One Click ? And How to Convert Fiscal Calendar…
Become Awesome & Learn Excel & POWER BI | Online Course | Big Discount | Mar 2025 | Lifetime Access!

2025年2月18日

Become Awesome & Learn Excel & POWER BI | Online Course | Big Discount | Mar 2025 | Lifetime Access!

Modern Excel Course for Data & Business Analysts Professionals & Students CLICK HERE | Last date to avail Discount by…

1 条评论

See all articles

Microsoft Excel 365

44,004 位关注者

Rahim Zulfiqar Ali的更多文章

Admissions Open! Live Online EXCEL 365 Classes Training | Become Awesome Analyst - April 2025 Batch

Admissions Open! Live Online POWER BI Classes Training | Become Awesome as Analyst & BI Professional - April 2025 Batch

Courier Delivery Process Flow / Tracker | HR Hiring an Employee Tracker in Excel 365 Version

Fuzzy Lookup (POWER QUERY) Approximate Match for Text in Microsoft Excel

POWERBI: Create MTD / QTD / YTD Time Intelligence Slicer & Dynamic Title | Visual to Show both VALUES & PERCENT | Data Labels | Column or Bar Chart

Learn Advanced Descriptive Analytics in Excel | Examples of Human Resources Dataset | 6 Questions

Become Awesome & Learn Modern Excel 365 | Online Course | Big Discount | Mar 2025 | Lifetime Access!

Sales Analytical Dashboard using Data Analysis Expressions (DAX) & Visualizations + Tips in Excel

How to Create Calendar Dimension Table in EXCEL POWER PIVOT with Just One Click ? And How to Convert Fiscal Calendar (Years, Months & Quarters) Slicer

Become Awesome & Learn Excel & POWER BI | Online Course | Big Discount | Mar 2025 | Lifetime Access!