TheKenhal - VideoAndMovie

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

Why UnPivot in Power Query (2 Ways)? Transpose, UnPivot, Pivot.

12:13

Why UnPivot in Power Query (2 Ways)? Transpose, UnPivot, Pivot.

Why Sort Left To Right in Excel?

5:44

Why Sort Left To Right in Excel?

MS Project Custom Field

9:38

MS Project Custom Field

Column Chart Green on Target

7:43

Column Chart Green on Target

MS Project Calendar

9:11

MS Project Calendar

Correct Dot Date Format

1:59

Correct Dot Date Format

Double Subtotal & Filter Subtotal

9:12

Double Subtotal & Filter Subtotal

Scrolling Chart in Excel

20:53

Scrolling Chart in Excel

Nested XLOOKUP

3:48

Nested XLOOKUP

Dropdown with Symbol

5:42

Dropdown with Symbol

Vlookup Entire Record

6:15

Vlookup Entire Record

#TheKenhal Live Totals in (3) Charts - Advanced XL

16:39

#TheKenhal Live Totals in (3) Charts - Advanced XL

Combine Sheets Correctly in Excel - 2 Examples (No Macro)

12:17

Combine Sheets Correctly in Excel - 2 Examples (No Macro)

Merge Excel Files Correctly - 2 Examples (No Macro)

14:17

Merge Excel Files Correctly - 2 Examples (No Macro)

Dynamic Chart with Drop-down - Advanced Excel

8:24

Dynamic Chart with Drop-down - Advanced Excel

Top 3 Unique Values in Excel - Work XL

7:41

Top 3 Unique Values in Excel - Work XL

Find Top 3 Values in Excel (4 Ways) - Work XL

8:47

Find Top 3 Values in Excel (4 Ways) - Work XL

Pivot Table Carries Source Data Also - Work XL

7:18

Pivot Table Carries Source Data Also - Work XL

Filter Last Column in Pivot - Quick XL

2:21

Filter Last Column in Pivot - Quick XL

EMI Calculator - Quick XL

3:32

EMI Calculator - Quick XL

VLookup with IfError - Work XL

5:07

VLookup with IfError - Work XL

Basic VLookup - Work XL

7:48

Basic VLookup - Work XL

COUNTIFS (6 Ways) - Work XL

5:52

COUNTIFS (6 Ways) - Work XL

Chart Target Individual - Advanced XL

5:51

Chart Target Individual - Advanced XL

Chart Target Fixed - Advanced XL

7:22

Chart Target Fixed - Advanced XL

SUMIFS (5 Ways) - Work XL

13:54

SUMIFS (5 Ways) - Work XL

Cumulative using Pivot - Quick

2:07

Cumulative using Pivot - Quick

Cumulative on normal Selection - Quick

3:05

Cumulative on normal Selection - Quick

Check big Range - Quick

2:44

Check big Range - Quick

Serial Number does not change on Sort - Quick

2:37

Serial Number does not change on Sort - Quick