Канал: YouExcel Tutorials

Remove sheets in PivotTables #msexcel #youexceltutorials #shorts

Remove sheets in PivotTables #msexcel #youexceltutorials #shorts

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

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

10 Common Accounting & Finance Terms You Should Know #1

10 Common Accounting & Finance Terms You Should Know #1

Easy dynamic list of dates #msexcel #youexceltutorials #shorts

Easy dynamic list of dates #msexcel #youexceltutorials #shorts

Five (5) Excel Tips #msexcel #youexceltutorials #shorts

Five (5) Excel Tips #msexcel #youexceltutorials #shorts

What is Power Query? #msexcel #shorts #youexceltutorials

What is Power Query? #msexcel #shorts #youexceltutorials

😲VLOOKUP pictures #msexcel #shorts #youexceltutorials

😲VLOOKUP pictures #msexcel #shorts #youexceltutorials

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

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

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

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

Turn off structured references #msexcel #shorts #youexceltutorials

Turn off structured references #msexcel #shorts #youexceltutorials

Six (6) PivotTable Tips #msexcel #shorts

Six (6) PivotTable Tips #msexcel #shorts

Format numbers in thousands #msexcel #shorts

Format numbers in thousands #msexcel #shorts

Sum between dates #msexcel #shorts

Sum between dates #msexcel #shorts

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

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

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

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

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

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

UNIQUE vs DISTINCT values in Excel

UNIQUE vs DISTINCT values in Excel

DAX vs EXCEL FUNCTIONS | RELATED | LOOKUPVALUE | RELATEDTABLE

DAX vs EXCEL FUNCTIONS | RELATED | LOOKUPVALUE | RELATEDTABLE

Basic Concepts in Power Pivot for Excel #shorts #msexcel

Basic Concepts in Power Pivot for Excel #shorts #msexcel

Remove PivotTable Grand Totals #shorts #msexcel

Remove PivotTable Grand Totals #shorts #msexcel

Trivia Time: Most used Excel Function #msexcel #shorts

Trivia Time: Most used Excel Function #msexcel #shorts

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

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

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

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

Ctrl + H || Find & Replace Formats in Excel #shorts #msexcel

Ctrl + H || Find & Replace Formats in Excel #shorts #msexcel

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

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

Excel Super Users || 10 questions you should answer

Excel Super Users || 10 questions you should answer

Identify and highlight duplicates in a list #msexcel #shorts

Identify and highlight duplicates in a list #msexcel #shorts

Easy techniques to insert additional series to Excel charts #msexcel #shorts

Easy techniques to insert additional series to Excel charts #msexcel #shorts

Fix Time Format || Split time values with no delimiter || Excel Formulas || Power Query

Fix Time Format || Split time values with no delimiter || Excel Formulas || Power Query

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

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

Format multiple sheets is less than a minute! #shorts #msexcel

Format multiple sheets is less than a minute! #shorts #msexcel

Identify and fix row and column errors easily in #msexcel #shorts

Identify and fix row and column errors easily in #msexcel #shorts

What is CAGR? || LAMBDA Function || RRI function in Excel || Financial Analysis

What is CAGR? || LAMBDA Function || RRI function in Excel || Financial Analysis

TEXTSPLIT Function vs SPLIT Function #shorts #msexcel

TEXTSPLIT Function vs SPLIT Function #shorts #msexcel

Format number stored as Text #shorts #msexcel

Format number stored as Text #shorts #msexcel

Create Index Number for Grouped Data || Excel Formula vs Power Query

Create Index Number for Grouped Data || Excel Formula vs Power Query

Parameter Query || Filter Power Query data from Excel

Parameter Query || Filter Power Query data from Excel

Who modified my Excel file? #msexcel #shorts

Who modified my Excel file? #msexcel #shorts

Multi-Currency Income Statement || Financial Modeling || Radio/ Option button in Excel

Multi-Currency Income Statement || Financial Modeling || Radio/ Option button in Excel

Create duplicates easily #shorts #msexcel

Create duplicates easily #shorts #msexcel

Analyze Data Quickly || Quick Analysis Tool #msexcel #shorts

Analyze Data Quickly || Quick Analysis Tool #msexcel #shorts

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

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

Alternatives to Merge and Center in #Excel #shorts

Alternatives to Merge and Center in #Excel #shorts

Append and Reconcile tables easily in Excel with Power Query

Append and Reconcile tables easily in Excel with Power Query

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

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

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

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

TEXTJOIN Function || Combine Texts in Excel

TEXTJOIN Function || Combine Texts in Excel

F9 Key || Evaluate and Debug Formulas #Excel #Shorts

F9 Key || Evaluate and Debug Formulas #Excel #Shorts

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

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

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

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

Excel Skills Test for Financial Analysts || Accountants || Excel Users || Employment Test

Excel Skills Test for Financial Analysts || Accountants || Excel Users || Employment Test

Protect Worksheet || Allow Edit Ranges #shorts #excel

Protect Worksheet || Allow Edit Ranges #shorts #excel

Import a table from PDF to Excel with Power Query || Microsoft 365, Excel 2019 & Others

Import a table from PDF to Excel with Power Query || Microsoft 365, Excel 2019 & Others

Watch Window (monitor important cells) in Excel

Watch Window (monitor important cells) in Excel

Year to Date (YTD) Analysis in #Excel || Sum a Dynamic Range with INDEX/MATCH and XLOOKUP

Year to Date (YTD) Analysis in #Excel || Sum a Dynamic Range with INDEX/MATCH and XLOOKUP

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

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

Distinct Count with a PivotTable #shorts

Distinct Count with a PivotTable #shorts

F2 Key in Excel #shorts

F2 Key in Excel #shorts

Create Conditional formatting with formulas || 5 Useful Examples

Create Conditional formatting with formulas || 5 Useful Examples

Cell References in Excel - Mixed Reference #shorts

Cell References in Excel - Mixed Reference #shorts

Cell References in Excel - Absolute Reference #shorts

Cell References in Excel - Absolute Reference #shorts

Cell References in Excel - Relative Reference #shorts

Cell References in Excel - Relative Reference #shorts

What is EBITDA? || EBITDA Bridge || Waterfall Chart in Excel || Financial Performance

What is EBITDA? || EBITDA Bridge || Waterfall Chart in Excel || Financial Performance

Stop your Excel chart from disappearing #shorts

Stop your Excel chart from disappearing #shorts

Extract Specific Columns || Filter Function vs Advanced Filter || Simply Explained Part 2

Extract Specific Columns || Filter Function vs Advanced Filter || Simply Explained Part 2

Filter Function vs Advanced Filter || Simply Explained || Part 1

Filter Function vs Advanced Filter || Simply Explained || Part 1

IS Functions in Excel

IS Functions in Excel

Six Excel Functions that have no Arguments || Do you know all?

Six Excel Functions that have no Arguments || Do you know all?

Common Size (Vertical) Analysis in Excel || Financial Analysis || Clustered Column Chart

Common Size (Vertical) Analysis in Excel || Financial Analysis || Clustered Column Chart

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

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

The structure of an Excel Function || A beginner’s guide

The structure of an Excel Function || A beginner’s guide

Three Ways to Quickly Display Formulas in Excel (Short Video)

Three Ways to Quickly Display Formulas in Excel (Short Video)

Year-Over-Year (YoY) analysis in Excel || Conditional Formatting Icon Sets || Company Performance

Year-Over-Year (YoY) analysis in Excel || Conditional Formatting Icon Sets || Company Performance

Vertical & Wildcard Match: XLOOKUP || INDEX/ MATCH || INDEX/ XMATCH || VLOOKUP - (Multiple Criteria)

Vertical & Wildcard Match: XLOOKUP || INDEX/ MATCH || INDEX/ XMATCH || VLOOKUP - (Multiple Criteria)

Multiple Criteria: XLOOKUP || INDEX/MATCH || INDEX/XMATCH || VLOOKUP -(Vertical & Horizontal Search)

Multiple Criteria: XLOOKUP || INDEX/MATCH || INDEX/XMATCH || VLOOKUP -(Vertical & Horizontal Search)

XLOOKUP || INDEX/ MATCH || INDEX/ XMATCH || VLOOKUP (Intro) Part 1 of 3

XLOOKUP || INDEX/ MATCH || INDEX/ XMATCH || VLOOKUP (Intro) Part 1 of 3

Flash Fill - Automatically fill in values in Excel (Short Video)

Flash Fill - Automatically fill in values in Excel (Short Video)

Date Table || Hierarchies || KPIs in Power Pivot for Excel - #08 (Free download)

Date Table || Hierarchies || KPIs in Power Pivot for Excel - #08 (Free download)

Prevent Duplicate Data Entries in Excel (Short Video)

Prevent Duplicate Data Entries in Excel (Short Video)

Excel Combo Chart || Highlight Maximum Value/Point

Excel Combo Chart || Highlight Maximum Value/Point

Consolidate Multiple Excel Worksheets (Short Video)

Consolidate Multiple Excel Worksheets (Short Video)

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

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

Ten (10) Shortcuts for Navigation in an Excel Worksheet

Ten (10) Shortcuts for Navigation in an Excel Worksheet

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

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

Calculated Columns PowerPivot (Includes the Related function) - #05

Calculated Columns PowerPivot (Includes the Related function) - #05

Create a Pivot Table with Power Pivot Data Model - #04

Create a Pivot Table with Power Pivot Data Model - #04

Define and create relationships in Power Pivot - #03

Define and create relationships in Power Pivot - #03

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

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

Copy & paste regular/ pivot chart formats to another chart (Short Video)

Copy & paste regular/ pivot chart formats to another chart (Short Video)

Connect Multiple Excel Tables in a Pivot Table (Don't use VLOOKUP!) - #01

Connect Multiple Excel Tables in a Pivot Table (Don't use VLOOKUP!) - #01

Hide and group cells in Excel (Short Video)

Hide and group cells in Excel (Short Video)

Lookup Pictures/ Images (XLOOKUP & INDEX/MATCH) in Excel without VBA

Lookup Pictures/ Images (XLOOKUP & INDEX/MATCH) in Excel without VBA

Excel Checkbox (create a simple To-Do List)

Excel Checkbox (create a simple To-Do List)

Change Text Case in Excel (Short Video)

Change Text Case in Excel (Short Video)

PIVOT CHARTS [for all chart types]

PIVOT CHARTS [for all chart types]

Password Protect an Excel Workbook (Short video)

Password Protect an Excel Workbook (Short video)

Map charts in Excel (including geography data type)

Map charts in Excel (including geography data type)

Hyperlink Function in Excel (SIMPLY EXPLAINED)

Hyperlink Function in Excel (SIMPLY EXPLAINED)

Create Icon & Shape Charts (Using a Column chart)

Create Icon & Shape Charts (Using a Column chart)

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

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

Four Simple Techniques to Copy Visible Cells in Excel

Four Simple Techniques to Copy Visible Cells in Excel

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

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

Pivot Tables - Comprehensive Introduction (Including pro tips)

Pivot Tables - Comprehensive Introduction (Including pro tips)

How to Insert a PDF file into Excel

How to Insert a PDF file into Excel

Create a simple Gauge (Speedometer) chart in Excel

Create a simple Gauge (Speedometer) chart in Excel

MAXIFS & MINIFS - Advanced IF Functions PART 4

MAXIFS & MINIFS - Advanced IF Functions PART 4

Quick techniques to copy and paste formulas as values

Quick techniques to copy and paste formulas as values

Vlookup, Match & Index Functions (Understand the differences and learn how to apply in a simple way)

Vlookup, Match & Index Functions (Understand the differences and learn how to apply in a simple way)

Simple Progress Circle Charts

Simple Progress Circle Charts

Basic Pie Charts - Detailed Summary

Basic Pie Charts - Detailed Summary

How to change the default chart for shortcut keys

How to change the default chart for shortcut keys

Keyboard shortcuts for number formats

Keyboard shortcuts for number formats

SUMIFS & AVERAGEIFS - Advanced IF Functions PART 3

SUMIFS & AVERAGEIFS - Advanced IF Functions PART 3

COUNTIFS - Advanced IF Functions PART 2

COUNTIFS - Advanced IF Functions PART 2

Insert picture in Excel comment

Insert picture in Excel comment

IFS - Advanced IF Functions PART I

IFS - Advanced IF Functions PART I

Simple Actual to Budget Charts

Simple Actual to Budget Charts

Welcome to YouExcel!

Welcome to YouExcel!

Excel Tables: All you need to Know!

Excel Tables: All you need to Know!

Subtotals in Excel

Subtotals in Excel

Convert Mixed Data Types in Power Query

Convert Mixed Data Types in Power Query

Convert Month Number to Month Name in MSExcel

Convert Month Number to Month Name in MSExcel