TheKenhal

Learn Power BI, Excel, and Project thru interactive HD Videos in English at TheKenhal.

Why UnPivot in Power Query (2 Ways)? Transpose, UnPivot, Pivot.
Why UnPivot in Power Query (2 Ways)? Transpose, UnPivot, Pivot.
Why Sort Left To Right in Excel?
Why Sort Left To Right in Excel?
MS Project Custom Field
MS Project Custom Field
Column Chart Green on Target
Column Chart Green on Target
MS Project Calendar
MS Project Calendar
Correct Dot Date Format
Correct Dot Date Format
Double Subtotal & Filter Subtotal
Double Subtotal & Filter Subtotal
Scrolling Chart in Excel
Scrolling Chart in Excel
Nested XLOOKUP
Nested XLOOKUP
Dropdown with Symbol
Dropdown with Symbol
Vlookup Entire Record
Vlookup Entire Record
#TheKenhal Live Totals in (3) Charts - Advanced XL
#TheKenhal Live Totals in (3) Charts - Advanced XL
Combine Sheets Correctly in Excel - 2 Examples (No Macro)
Combine Sheets Correctly in Excel - 2 Examples (No Macro)
Merge Excel Files Correctly - 2 Examples (No Macro)
Merge Excel Files Correctly - 2 Examples (No Macro)
Dynamic Chart with Drop-down - Advanced Excel
Dynamic Chart with Drop-down - Advanced Excel
Top 3 Unique Values in Excel - Work XL
Top 3 Unique Values in Excel - Work XL
Find Top 3 Values in Excel (4 Ways) - Work XL
Find Top 3 Values in Excel (4 Ways) - Work XL
Pivot Table Carries Source Data Also - Work XL
Pivot Table Carries Source Data Also - Work XL
Filter Last Column in Pivot - Quick XL
Filter Last Column in Pivot - Quick XL
EMI Calculator - Quick XL
EMI Calculator - Quick XL
VLookup with IfError - Work XL
VLookup with IfError - Work XL
Basic VLookup - Work XL
Basic VLookup - Work XL
COUNTIFS (6 Ways) - Work XL
COUNTIFS (6 Ways) - Work XL
Chart Target Individual - Advanced XL
Chart Target Individual - Advanced XL
Chart Target Fixed - Advanced XL
Chart Target Fixed - Advanced XL
SUMIFS (5 Ways) - Work XL
SUMIFS (5 Ways) - Work XL
Cumulative using Pivot - Quick
Cumulative using Pivot - Quick
Cumulative on normal Selection - Quick
Cumulative on normal Selection - Quick
Check big Range - Quick
Check big Range - Quick
Serial Number does not change on Sort - Quick
Serial Number does not change on Sort - Quick