YouExcel Tutorials

WORKDAY || NETWORKDAYS || WORKDAY.INTL || NETWORKDAYS.INTL || Important Date Functions

Combine Texts in Excel || Power Query || Text.Combine || Textjoin Function

Extract Unique Items from a List in Excel || Three (3) Fast & Easy Ways

Calculated Fields & Calculated Items in a Pivot Table (Detailed video)

SUM Vs SUMIF(S) - Multiple Criteria || Same Column || Different Columns

Pivot Tables - AutoFilter, Slicers & Timeline (Including pro tips)

Extract Texts in Excel || Fix Date Format || Power Query || Formulas || Column from Examples

Direct Import from External Data (Excel & Text files) in Power Pivot - #02

WORKDAY || NETWORKDAYS || WORKDAY.INTL || NETWORKDAYS.INTL || Important Date Functions

Scrollable Excel Table and Chart || IndexMatch/ XLookup || Scroll Bar (Form Control)

DAX vs EXCEL FUNCTIONS | RELATED | LOOKUPVALUE | RELATEDTABLE

Turn off structured references

IFS - Advanced IF Functions PART I

Ctrl + H || Find & Replace Formats in Excel

Variance Analysis || DAX || VSTACK || Data Analysis || Financial Analysis

What is an array in Excel || Array Constants || Array Formulas

What is Cohort Analysis? || Retention Rate || Data Analysis || Dynamic Array Formulas

Alternatives to Nested IF Formulas || IFS || SWITCH || CHOOSE Functions

Scenario Analysis in Financial Modeling || What-if Analysis in Excel

Format numbers in thousands

Alternatives to Merge and Center in

Convert Month Number to Month Name in MSExcel

Trivia Time: Most used Excel Function

TEXTSPLIT Function vs SPLIT Function

Filter Function || Multiple Criteria || Same Column || Different Columns

😲VLOOKUP pictures

GETPIVOTDATA || Dynamic Financial Reporting || PivotTable || Data Model || Cube Functions

LTM Analysis || Financial and Data Analysis || Excel || DAX || Power Pivot

Excel Super Users || 10 questions you should answer

Parameter Query || Filter Power Query data from Excel

Format multiple sheets is less than a minute!

Six (6) PivotTable Tips

Basic Concepts in Power Pivot for Excel

UNIQUE vs DISTINCT values in Excel

Easy dynamic list of dates

Hyperlink Function in Excel (SIMPLY EXPLAINED)

F2 Key in Excel

Cell References in Excel - Absolute Reference

10 Common Accounting & Finance Terms You Should Know #1

What is Power Query?

Remove PivotTable Grand Totals

Sum between dates

TAKE || DROP || Dynamic Range || Alternatives to OFFSET function

Five (5) Excel Tips

Remove sheets in PivotTables

Calculate Retention & Churn || Cohort Analysis || Data Analysis

Cell References in Excel - Relative Reference

Intro to Power Query || Load Data from Power Query to the Data Model - #07

Measures (Implicit & Explicit) in Power Pivot || SUMX Function - #06

Transpose, Unpivot and Pivot in Power Query - Understand the difference