|
Deep Dive into Advanced Excel with AI
|
|
|
|
AI 1 ( Filter Function - Multiple Criteria (with CHOOSECOLS)
18:00
|
|
|
|
AI 1 ( Filter Function - Two Criteria (different columns Use of AND)
31:00
|
|
|
|
AI 1 (Dynamic Array - Concept)
14:00
|
|
|
|
AI 1 (Dynamic Array - Profit Calculation Example)
7:00
|
|
|
|
AI 1 (Filter Function - Multiple Criteria (different columns Use of OR)
8:00
|
|
|
|
AI 1 (Filter Function - Multiple Criteria (same column)
15:00
|
|
|
|
AI 1 (Filter Function - Single Criteria
23:00
|
|
|
|
AI 1 (Filter Function - Three Criteria (different columns Use of AND)
10:00
|
|
|
|
AI 1 (Hash with Example
11:00
|
|
|
|
AI 1 (Sort Function)
14:00
|
|
|
|
AI 1 (Spill Error with Examples
10:00
|
|
|
|
AI 2 (Analyse Data)
18:00
|
|
|
|
AI 2 (Flash Fill)
20:00
|
|
|
|
AI 2 (Forecasting (Time Series))
23:00
|
|
|
|
AI 2 (Image2Text)
14:00
|
|
|
|
AI 2 (SORTBY)
3:00
|
|
|
|
AI 2 (TextSplit)
3:00
|
|
|
|
AI 2 (TOCOL, TOROW)
4:00
|
|
|
|
AI 2 (Unique Function).mp4
7:00
|
|
|
|
AI 2 (VSTACK)
4:00
|
|
|
|
AI 2 (XLOOKUP - (Extracting values from all columns))
2:00
|
|
|
|
AI 2 (XLOOKUP - (Extracting values from all the right columns)
6:00
|
|
|
|
AI 2 (XLOOKUP - (Extracting values from left and right columns))
13:00
|
|
|
|
AI 2 (XLOOKUP - (Extracting values from only selected columns))
6:00
|
|
|
|
AI 2 (XLOOKUP - (Multiple Look Ups))
9:00
|
|
|
Excel with AI. Training
|
|
|
|
Excel_withAI_GTR2025
|
|
|
Statistics with Basic videos
|
|
|
|
Statistics basic 1 (What is Statistics and why it is important)
13:00
|
|
|
|
Statistics basic 1 (Types of Data Variables)
12:00
|
|
|
|
Statistic basics 1 (Measures of Variability Dispersion)
42:00
|
|
|
|
Statistics asic 1 (Data, Information and Statistic)
19:00
|
|
|
|
Statistics baisc 1 (Frequency, Distrubution and Histogram)
6:00
|
|
|
|
Satistics basic 1 (DIKW Hierarchy)
6:00
|
|
|
|
Statistics basic 1 (Measures of Central Tendency - Mean, Media & Mode)
20:00
|
|
|
|
Statistics basic 1 (Scales of Measurement)
10:00
|
|
|
|
Statistics basic 1 (Types of Statistics - Descriptive and Inferential Statistics (an introduction))
12:00
|
|
|
|
Statistic fundamental 2 (Percentile Quantile)
9:00
|
|
|
|
Statistic fundamental 2 (Data Analysis Toolpak - in excel)
|
|
|
|
Statistic fundamental 2 (Box Plot Chart and IQR)
|
|
|
|
Statistic fundamental 2 (Common Mistakes & Misinterpretations (Descriptive Stats))
|
|
|
|
Statistic fundamental 2 (Data Visualizations and Types of charts)
5:00
|
|
|
|
Statistic fundamental 2 (Skewness & Kurtosis)
|
|
|
|
Statistic fundamental 2 (Understanding Variability and why it is important)
|
|
|
|
Statistic Fundamental 2 (Correlation coefficient and scatter plots)
|
|