Power Query in Excel – The Secret Behind Smart Analysts (1 of 25)
JET Joy Excel Training
Power Query in Excel – The Secret Behind Smart Analysts (1 of 25)
9:30
Master These XLOOKUP Techniques to Boost Your Excel Efficiency
JET Joy Excel Training
Master These XLOOKUP Techniques to Boost Your Excel Efficiency
9:54
Stop Using IF Function in Excel! | Use along with advanced options as AND, OR, NOT
JET Joy Excel Training
Stop Using IF Function in Excel! | Use along with advanced options as AND, OR, NOT
13:04
How to Use XLOOKUP for Non-Adjacent Columns in Excel | Easy Excel Tutorial
JET Joy Excel Training
How to Use XLOOKUP for Non-Adjacent Columns in Excel | Easy Excel Tutorial
3:36
AGGREGATE Function in Excel – The Advanced SUBTOTAL You MUST Use!
JET Joy Excel Training
AGGREGATE Function in Excel – The Advanced SUBTOTAL You MUST Use!
8:29
XLOOKUP in multiple sheet | Advance Excel Tip
JET Joy Excel Training
XLOOKUP in multiple sheet | Advance Excel Tip
3:53
Focus Cell: Discover Excel's Amazing New Feature!
JET Joy Excel Training
Focus Cell: Discover Excel's Amazing New Feature!
1:43
Advanced XNPV and XIRR functions, which use actual dates for unparalleled accuracy
JET Joy Excel Training
Advanced XNPV and XIRR functions, which use actual dates for unparalleled accuracy
7:47
Excel Magic! Auto Reconcile Sheets & Spot Variances Instantly! 🔥 by using advance excel 365 formulas
JET Joy Excel Training
Excel Magic! Auto Reconcile Sheets & Spot Variances Instantly! 🔥 by using advance excel 365 formulas
10:56
Say Goodbye to Manual Splitting: Discover new TEXTSPLIT Formula in MS Excel
JET Joy Excel Training
Say Goodbye to Manual Splitting: Discover new TEXTSPLIT Formula in MS Excel
4:05
Convert Pivot Table Values to Crores: Simplify Your Data in Excel
JET Joy Excel Training
Convert Pivot Table Values to Crores: Simplify Your Data in Excel
1:41
Say goodbye to complex nested IF statements and use XLOOKUP for Aging calculation
JET Joy Excel Training
Say goodbye to complex nested IF statements and use XLOOKUP for Aging calculation
5:18
Transform Your Excel Charts: Highlight Highs & Lows with Dynamic Colors!
JET Joy Excel Training
Transform Your Excel Charts: Highlight Highs & Lows with Dynamic Colors!
4:05
Doughnut Progress Circle Chart in Excel as NEVER seen before!
JET Joy Excel Training
Doughnut Progress Circle Chart in Excel as NEVER seen before!
10:35
Actual vs Budget Chart with Variance Analysis with Emoji Indicators 🟢🔴👍
JET Joy Excel Training
Actual vs Budget Chart with Variance Analysis with Emoji Indicators 🟢🔴👍
7:05
Search multiple files in folder by using Excel 365 - TEXTJOIN -Don’t miss out on these expert tips
JET Joy Excel Training
Search multiple files in folder by using Excel 365 - TEXTJOIN -Don’t miss out on these expert tips
2:00
Magic of the UNIQUE function in Excel – Say no to duplicates!
JET Joy Excel Training
Magic of the UNIQUE function in Excel – Say no to duplicates!
5:03
MS Excel to create a Half Donut Chart and visually represent your data in an eye-catching way
JET Joy Excel Training
MS Excel to create a Half Donut Chart and visually represent your data in an eye-catching way
8:15
Budget vs actual 3D chart in Excel - In less than 5 minutes
JET Joy Excel Training
Budget vs actual 3D chart in Excel - In less than 5 minutes
4:49
Discover the Art of Advanced Filtering - Transform Your Data World (Part-6)-Shortcut to launch
JET Joy Excel Training
Discover the Art of Advanced Filtering - Transform Your Data World (Part-6)-Shortcut to launch
1:08
Discover the Art of Advanced Filtering - Transform Your Data World (Part-4), - And/OR/wildcards
JET Joy Excel Training
Discover the Art of Advanced Filtering - Transform Your Data World (Part-4), - And/OR/wildcards
3:29
Discover the Art of Advanced Filtering - Transform Your Data World - (Part-3)-Extract filter only
JET Joy Excel Training
Discover the Art of Advanced Filtering - Transform Your Data World - (Part-3)-Extract filter only
2:47
Discover the Art of Advanced Filtering - Transform Your Data World (Part-2) - Multiple criteria
JET Joy Excel Training
Discover the Art of Advanced Filtering - Transform Your Data World (Part-2) - Multiple criteria
1:22
Discover the Art of Advanced Filtering - Transform Your Data World (Part 1)
JET Joy Excel Training
Discover the Art of Advanced Filtering - Transform Your Data World (Part 1)
1:43
Excel Magic: Send Emails Without Coding! Hyperlink Hacks for Email Wizards 🚀✉️
JET Joy Excel Training
Excel Magic: Send Emails Without Coding! Hyperlink Hacks for Email Wizards 🚀✉️
4:24
Mastering Excel: Uncover Hidden Insights with Advanced Data Comparison Techniques
JET Joy Excel Training
Mastering Excel: Uncover Hidden Insights with Advanced Data Comparison Techniques
3:09
Auto Currency Conversion in MS Excel - New Feature ~
JET Joy Excel Training
Auto Currency Conversion in MS Excel - New Feature ~
3:15
Large & Small Formulas in MS Excel - Less Known but very powerful
JET Joy Excel Training
Large & Small Formulas in MS Excel - Less Known but very powerful
6:16
XLOOKUP with Multiple Lookup Value | Advance EXCEL Feature
JET Joy Excel Training
XLOOKUP with Multiple Lookup Value | Advance EXCEL Feature
3:26
One Pivot Table from two or Multiple Tables - Power Pivot | Very Easy & Useful
JET Joy Excel Training
One Pivot Table from two or Multiple Tables - Power Pivot | Very Easy & Useful
6:16
Table Range - Excel Formula Typing with Ease
JET Joy Excel Training
Table Range - Excel Formula Typing with Ease
4:34
Pivot Unpivot Data in MS Excel by Using Power Query. You will be surprised at how easy it is.
JET Joy Excel Training
Pivot Unpivot Data in MS Excel by Using Power Query. You will be surprised at how easy it is.
4:42
Multiple Value Lookup in Single Cell | Very simple after 365 formulas
JET Joy Excel Training
Multiple Value Lookup in Single Cell | Very simple after 365 formulas
5:03
XLOOKUP IN ADVANCE EXCEL | WITH DYNAMIC LOOKUP RANGE
JET Joy Excel Training
XLOOKUP IN ADVANCE EXCEL | WITH DYNAMIC LOOKUP RANGE
3:39
DEPENDABLE DROPDOWN | ADVANCE EXCEL | By using Excel 365 Formulas
JET Joy Excel Training
DEPENDABLE DROPDOWN | ADVANCE EXCEL | By using Excel 365 Formulas
5:14
Dynamic Array Excel365/2021| Get Value in Multiple Cells | Change the way you write Formula in Excel
JET Joy Excel Training
Dynamic Array Excel365/2021| Get Value in Multiple Cells | Change the way you write Formula in Excel
4:24
Justify your Text in Excel | without using Wrap & Merge | Very Useful Excel Feature
JET Joy Excel Training
Justify your Text in Excel | without using Wrap & Merge | Very Useful Excel Feature
1:57
OFFSET function in Excel - To make your Cell reference Dynamic | Mysterious formulas, One must learn
JET Joy Excel Training
OFFSET function in Excel - To make your Cell reference Dynamic | Mysterious formulas, One must learn
15:55
List of Files in Folder to Excel | in just few click| Power Query
JET Joy Excel Training
List of Files in Folder to Excel | in just few click| Power Query
5:32
Sparkline in MS Excel. Mini Chart to Represent the data in row.
JET Joy Excel Training
Sparkline in MS Excel. Mini Chart to Represent the data in row.
3:00
3D Sum Formula in MS Excel. Saving Tons of Time.
JET Joy Excel Training
3D Sum Formula in MS Excel. Saving Tons of Time.
4:08
Customized Calendar + Planner in Excel (Very useful)
JET Joy Excel Training
Customized Calendar + Planner in Excel (Very useful)
9:36
Creating PowerPoint Presentation (PPT) like a Pro - Within a Second.
JET Joy Excel Training
Creating PowerPoint Presentation (PPT) like a Pro - Within a Second.
2:42
Get Financial Year and Quarter from Date in MS Excel with formula.
JET Joy Excel Training
Get Financial Year and Quarter from Date in MS Excel with formula.
4:53
Sparkling Christmas Tree in MS Excel Within a minutes.
JET Joy Excel Training
Sparkling Christmas Tree in MS Excel Within a minutes.
3:53
LET New Formula in Excel. It makes your formula calculation Easy. Must watch video!!
JET Joy Excel Training
LET New Formula in Excel. It makes your formula calculation Easy. Must watch video!!
3:08
Pivot Table from Multiple Excel Workbook by Power Query in MS Excel. Should not Miss this video.
JET Joy Excel Training
Pivot Table from Multiple Excel Workbook by Power Query in MS Excel. Should not Miss this video.
5:35
SORT Formula in MS Excel 365. One must Watch and Learn.
JET Joy Excel Training
SORT Formula in MS Excel 365. One must Watch and Learn.
2:37
IFS Formula in MS EXCEL. Alternative to IF Formula. Very simple to use in case of Multiple criteria
JET Joy Excel Training
IFS Formula in MS EXCEL. Alternative to IF Formula. Very simple to use in case of Multiple criteria
2:58
FILTER FORMULA IN EXCEL 365 ADVANCE! Filter as you Type. Make your report Faster
JET Joy Excel Training
FILTER FORMULA IN EXCEL 365 ADVANCE! Filter as you Type. Make your report Faster
5:40
XLOOKUP FORMULA IN MS EXCEL WITH 7 EXAMPLES. ALTERNATIVE TO VLOOKUP, HLOOKUP & INDEX+MATCH
JET Joy Excel Training
XLOOKUP FORMULA IN MS EXCEL WITH 7 EXAMPLES. ALTERNATIVE TO VLOOKUP, HLOOKUP & INDEX+MATCH
10:46
Restrict Data Entry in Cell - Based on entry in another cell | MS Excel
JET Joy Excel Training
Restrict Data Entry in Cell - Based on entry in another cell | MS Excel
2:32
SHARE MARKET STOCK DETAIL IN MS EXCEL 365 ! AUTO UPDATION OF SHARE DATA
JET Joy Excel Training
SHARE MARKET STOCK DETAIL IN MS EXCEL 365 ! AUTO UPDATION OF SHARE DATA
4:28
Breaklink between two MS Excel File ! Very Useful Tool
JET Joy Excel Training
Breaklink between two MS Excel File ! Very Useful Tool
1:45
SEQUENCE & RANDARRAY - NEW FORMULAS IN EXCEL 2019 & OFFICE 365
JET Joy Excel Training
SEQUENCE & RANDARRAY - NEW FORMULAS IN EXCEL 2019 & OFFICE 365
5:38
Multiple Value Lookup in Single Cell (By using UNIQUE & TEXTJOIN FORMULA)
JET Joy Excel Training
Multiple Value Lookup in Single Cell (By using UNIQUE & TEXTJOIN FORMULA)
6:21
Check Box in MS Excel with Conditional Formatting
JET Joy Excel Training
Check Box in MS Excel with Conditional Formatting
5:59
RandBetween to Create Huge Sample Data base within Seconds
JET Joy Excel Training
RandBetween to Create Huge Sample Data base within Seconds
4:28
How to Protect MS Excel Worksheet
JET Joy Excel Training
How to Protect MS Excel Worksheet
5:39
How to Set Password to MS Excel for Open and Modify
JET Joy Excel Training
How to Set Password to MS Excel for Open and Modify
5:03
CONDITIONAL FORMATTING ! ADVANCE EXCEL TOOL! Important formulas for Formatting
JET Joy Excel Training
CONDITIONAL FORMATTING ! ADVANCE EXCEL TOOL! Important formulas for Formatting
24:18
CONDITIONAL FORMATTING ! ADVANCE EXCEL TOOL! Formating data as you type date or number
JET Joy Excel Training
CONDITIONAL FORMATTING ! ADVANCE EXCEL TOOL! Formating data as you type date or number
2:32
CONDITIONAL FORMATTING ! ADVANCE EXCEL TOOL! Formating data as you type specific text
JET Joy Excel Training
CONDITIONAL FORMATTING ! ADVANCE EXCEL TOOL! Formating data as you type specific text
5:59
VLOOKUP + MATCH | AUTOMATION OF VLOOKUP FORMULA | ADVANCE EXCEL
JET Joy Excel Training
VLOOKUP + MATCH | AUTOMATION OF VLOOKUP FORMULA | ADVANCE EXCEL
5:18
VLOOKUP FORMULA EXCEL | LEARN WITHIN FEW MINUTES
JET Joy Excel Training
VLOOKUP FORMULA EXCEL | LEARN WITHIN FEW MINUTES
4:26
LEFT, RIGHT AND MID - EXCEL FORMULA | BEST WAY TO EXTRACT SPECIFIC TEXT FROM DATA
JET Joy Excel Training
LEFT, RIGHT AND MID - EXCEL FORMULA | BEST WAY TO EXTRACT SPECIFIC TEXT FROM DATA
2:51
DSUM - Advance EXCEL Formula | Alternate to SUMIFS Formula
JET Joy Excel Training
DSUM - Advance EXCEL Formula | Alternate to SUMIFS Formula
3:23
SUMIFS - Advance MS EXCEL Formula - Used for SUM involving Multiple criteria
JET Joy Excel Training
SUMIFS - Advance MS EXCEL Formula - Used for SUM involving Multiple criteria
5:00
SUMIF - Advance MS EXCEL Formula | Best Explained in video
JET Joy Excel Training
SUMIF - Advance MS EXCEL Formula | Best Explained in video
4:34
FLASH FILL | Advance MS Excel Tool | Artificial Intelligence
JET Joy Excel Training
FLASH FILL | Advance MS Excel Tool | Artificial Intelligence
2:59
Advance Filter in Excel. Best way to extract information from large data base | (Part-2)
JET Joy Excel Training
Advance Filter in Excel. Best way to extract information from large data base | (Part-2)
6:11
20 BEST SHORTCUTS FOR NEW YEAR 2020 IN MS EXCEL | VERY IMPORTANT DETAIL | SAVES LOT OF TIME
JET Joy Excel Training
20 BEST SHORTCUTS FOR NEW YEAR 2020 IN MS EXCEL | VERY IMPORTANT DETAIL | SAVES LOT OF TIME
9:27
Advance Filter in Excel. Best way to extract information from large data base | (Part-1)
JET Joy Excel Training
Advance Filter in Excel. Best way to extract information from large data base | (Part-1)
3:23
Dates formula and functions in EXCEL! One must know
JET Joy Excel Training
Dates formula and functions in EXCEL! One must know
10:48
Achieving the GOEL in EXCEL through GOEL SEEK FORMULA !.
JET Joy Excel Training
Achieving the GOEL in EXCEL through GOEL SEEK FORMULA !.
3:58
INDEX + MATCH best way to forget VLOOKUP option in EXCEL (part-2)
JET Joy Excel Training
INDEX + MATCH best way to forget VLOOKUP option in EXCEL (part-2)
4:43
INDEX + MATCH best way to forget VLOOKUP option in EXCEL (part-1)
JET Joy Excel Training
INDEX + MATCH best way to forget VLOOKUP option in EXCEL (part-1)
7:31
Create better reporting in pivot table by using slicer and grouping tools
JET Joy Excel Training
Create better reporting in pivot table by using slicer and grouping tools
8:56
Recommend Pivot table (Automatic creation of Pivot Table) and Pivot Table Design (New feature)
JET Joy Excel Training
Recommend Pivot table (Automatic creation of Pivot Table) and Pivot Table Design (New feature)
4:55
Calculated Field - Advance Excel Pivot Table Tools - you must learn
JET Joy Excel Training
Calculated Field - Advance Excel Pivot Table Tools - you must learn
3:55