Prepare Quickly Summary Report MIS | HR Example | Dynamic Array Formulas (GROUPBY, DROP, SORT, HSTACK, ARRAYTOTEXT, COUNTA) | #Excel 365 =SORT(DROP(GROUPBY(Database[EMP No]:Database[Employee Name],Database[Training],HSTACK(ARRAYTOTEXT,COUNTA),,0),1),1,1) | Excel Basement
Prepare Quickly Summary Report MIS | HR Example | Dynamic Arra…
613 views1 month ago
FacebookExcel Basement
New Excel Features: Dynamic Array Formulas & Spill Ranges - Excel Campus
9:06
New Excel Features: Dynamic Array Formulas & Spill Ranges - Excel C…
Oct 4, 2018
excelcampus.com
Dynamic arrays in Excel - Everything you NEED to know
Dynamic arrays in Excel - Everything you NEED to know
Jan 22, 2023
exceloffthegrid.com
How to Create an Excel Database (With Templates and Examples) | ClickUp
How to Create an Excel Database (With Templates and Examples) | …
2K views7 months ago
clickup.com
Import Data from Excel to Azure SQL Database using Azure Data Factory
Import Data from Excel to Azure SQL Database using Azure Data F…
Jul 6, 2021
mssqltips.com
Excel Dynamic Array: A Beginner's Tutorial
Excel Dynamic Array: A Beginner's Tutorial
Feb 2, 2022
goskills.com
Upload Data with Power Query — Excel Dashboards VBA
Upload Data with Power Query — Excel Dashboards VBA
Sep 21, 2020
thesmallman.com
11:20
Excel’s Role in Database Structure | From Basic to Professional | Irfan …
22 views2 weeks ago
YouTubeCareer Creators
Quickly Build PowerApps Application Using Excel As Data S…
4K viewsFeb 20, 2020
YouTubeKeaPoint Tech Tips
7:30
Excel: Using Database Functions
16.2K viewsJul 16, 2013
YouTubeCIS_SCC
12:03
Data Entry Application in Excel VBA – Part 1
101K viewsSep 16, 2019
YouTubePK: An Excel Expert
10:56
10 REDCap Advanced Features
5.4K viewsMar 14, 2017
YouTubeUCD REDCap
7:06
Database vs Spreadsheet - Advantages and Disadvantages
230.4K viewsNov 3, 2017
YouTube365 Data Science
2:34
How To Create Database in Microsoft Excel
144 viewsMay 11, 2020
YouTubeAmel Fasy
9:23
Import Data From Excel To Database In Spring Boot
22.3K viewsSep 5, 2020
YouTubeEasy 2 Excel
0:21
How to enable Data Streamer in Excel
17.6K viewsMar 6, 2019
YouTubeHacking STEM
9:50
How to Store Array values in Database
32.6K viewsMar 11, 2020
YouTubeEnriching Life
7:29
Transposing Arrays in Excel
3.8K viewsMar 29, 2015
YouTubeDr. Todd Grande
3:16
How to Create Data Entry Forms in Excel - EASY
467.3K viewsApr 16, 2021
YouTubeGauging Gadgets
4:20
Microsoft Excel #04: Excel as a Database
577.3K viewsAug 14, 2007
YouTubeFreeTutorials
4:24
Create an Excel Data Entry Form in UNDER 5 Minutes!
206.8K viewsOct 26, 2016
YouTubeMyExcelOnline.com
10:01
47: Inserting database results into array in PHP - PHP tutorial
145.9K viewsNov 14, 2016
YouTubeDani Krossing
7:04
How is data stored in sql database
211.2K viewsMar 27, 2021
YouTubekudvenkat
1:20
Convert Excel files to database
13K viewsOct 12, 2020
YouTubeThe m-Power Platform
6:42
Microsoft Access - importing data from Excel, creating queries.
5.5K viewsNov 13, 2017
YouTubePainless Programming
19:30
Excel: How to Create Array Formulas
2K viewsDec 12, 2019
YouTubeChester Tugwell
7:19
How to Use Arrays to SUM Data in Excel
13.9K viewsOct 22, 2019
YouTubeMyExcelOnline.com
4:02
SQL Tutorial: Working with ARRAYs
37.3K viewsMar 10, 2020
YouTubeDataCamp
3:28
How to Create Array Formulas in Excel
121.4K viewsFeb 28, 2018
YouTubeVertex42
7:01
Excel Dynamic Arrays (How they will change EVERYTHING!)
773.1K viewsOct 18, 2018
YouTubeLeila Gharani
See more videos
Static thumbnail place holder

Short videos

1:29
13K views · 84 reactions | Solved: Complex Data Spli…
3.6K views1 week ago
FacebookExcel Basement
0:45
AI can analyze your spreadsheets, but only if y…
277.5K views1 week ago
FacebookDatarails
1:29
New entry Multi column databases in Excel
14 views1 month ago
YouTubeexcelgeist
0:17
Glass Containers: The Kitchen Hack You NEED to …
873 views2 months ago
YouTubethankmesmarter
1:24
Delete entry Multi column databases in Excel
7 views1 month ago
YouTubeexcelgeist
1:36
Create filtered database Multi column databases in Excel
29 views1 month ago
YouTubeexcelgeist
0:26
This Excel trick saves hours of manual work #productivi…
271 views1 week ago
YouTubedptutorials
0:21
Stop Entering Data Manually! Try This Hidden Excel Trick
428 views2 months ago
YouTubeEasy Click Learning
1:20
CAT 2025 QA Profit and loss | How to start CAT 2025 Prep…
162 views2 weeks ago
YouTubeKYMS Academy
0:57
Stop Copy-Pasting in Excel! Auto-Arrange Messy Data i…
77 views2 weeks ago
YouTubeLearn With KPM
1:14
Excel Interview Questions: Data Entry & Management
328 views2 months ago
YouTubeDSRS TECH
0:25
Stop stretching columns like a noob @CodeGlobal #exc…
958 views3 months ago
YouTubeCode Global
1:01
Power of Array in Excel | How to unmerge value with fill d…
10.7K views3 months ago
YouTubeAbhijeetji Technical 4M
0:13
Use ARRAYTOTEXT Formula in Excel
162 views1 month ago
YouTubeNew Tech Mart
0:20
Air Pollution Row: AQI,AQI, AQI..अचानक ये क्या बो…
29.4K views2 weeks ago
YouTubeDainik Jagran - दैनिक जागरण
0:29
How to Use VSTACK in Excel: Stack Data Verticall…
1.3K views2 months ago
YouTubeExcel Simplified
1:00
Stop Manual Work! Create a Fully Automated Excel Dat…
193 views1 month ago
YouTubeLearn With KPM
0:34
Need Dummy Numbers for Testing? Use This Excel Tri…
1K views1 month ago
YouTubeEXCELSIRJI
0:48
Scaling a Team Without Losing Your Mind
1.2K views1 month ago
YouTubeDevin Kearns | CustomAI Studio
1:15
Excel TAKE Function | Extract Top or Bottom Row…
2.1K views2 weeks ago
YouTubedptutorials
Static thumbnail place holder