1
You Tubers Love Excel#11: Pivot Table, SUMPRODUCT & SUMIFS
8:09
2008-04-17
2
YouTubers Love Excel 12: Pivot Table AVERAGEIF SUMIF/COUNTIF
8:17
2008-04-17
3
YouTubersLoveExcel#13: Date Math and IF function
6:12
2008-04-23
4
YouTubersLoveExcel#14: NOT function for logic formulas
3:53
2008-04-23
5
YouTubersLoveExcel#15: Mixed Number formulas and Format
1:50
2008-04-23
6
YouTubersLoveExcel#16: Percent Number Formatting Tricks
4:32
2008-04-23
7
YouTubersLoveExcel#17: Hide Bank Rec Formula
10:37
2008-05-23
8
YouTubersLoveExcel#18: Logical Formula to Verify Patterns
5:32
2008-05-23
9
YouTubersLoveExcel#19: Steady Growth Cash Flow Formula
3:51
2008-05-23
10
YouTubersLoveExcel#20: Variable Growth Cash Flow Formula
5:38
2008-05-23
11
YouTubersLoveExcel#21: Solver for Linear Algebra
10:19
2008-05-23
12
YouTubersLoveExcel#22: EOM Terms with IF, DAY & EOMONTH fun
5:14
2008-05-30
13
YouTubersLoveExcel#23: Add Time with Formula or Format
5:55
2008-05-30
14
YouTubersLoveExcel#24: Add Time by Hour, Minute or Day
3:02
2008-05-30
15
YouTubersLoveExcel#25: Dynamic Range for Pivot Table & Chart
7:19
2008-05-30
16
YouTubersLoveExcel#26: Text To Column Trouble
3:44
2008-05-30
17
YouTubersLoveExcel#26.2: Formulas do not like TEXT Time
3:41
2008-06-06
18
YouTubersLoveExcel#27: Data Validation From Different Sheet
6:06
2008-06-06
19
YouTubersLoveExcel#28: Complex & Amazing Excel Trick
9:45
2008-06-07
20
YouTubersLoveExcel 29 Conditional Formatting & LEFT function
5:15
2008-06-06
21
YouTubersLoveExcel#30: Keyboard Shortcut Tricks.
3:03
2008-06-06
22
YouTubersLoveExcel#31: Dates, Cash Flow & Logic
9:27
2008-06-11
23
YouTubersLoveExcel#32: Delete Unique Records: MATCH & ROW
7:51
2008-06-11
24
YouTubersLoveExcel#33: Extract Red Cells
2:26
2008-06-11
25
YouTubersLoveExcel#34: Hide Columns Copy Problem
3:30
2008-06-11
26
YouTubersLoveExcel#35: IF AND vs. VLOOKUP
5:30
2008-06-16
27
YouTubersLoveExcel#36: VLOOKUP increase based on Rating
1:57
2008-06-16
28
YouTubersLoveExcel#37: Formula Input Efficiency
3:48
2008-06-16
29
YouTubersLoveExcel#39: Formula for Sheet Name
7:47
2008-06-17
30
YouTubersLoveExcel#40: Extract top 5 scores
4:21
2008-06-17
31
YouTubersLoveExcel#41: Prevent Duplicates COUNTIF Data Valid
3:09
2008-06-27
32
YouTubersLoveExcel#42: Format Negative Numbers
2:30
2008-06-27
33
YouTubersLoveExcel#43: Data Validation & Conditional Format
4:12
2008-06-27
34
YouTubersLoveExcel#44: Convert Formula Text To Number
4:06
2008-06-27
35
YouTubersLoveExcel#45: SUMPRODUCT & TEXT functions
4:49
2008-06-27
36
YouTubersLoveExcel#46: VLOOKUP & Previous Bracket Trick
10:07
2008-06-27
37
YouTubersLoveExcel#47: VLOOKUP & 2 Cost Formulas
5:59
2008-06-27
38
YouTubersLoveExcel#48: VLOOKUP for TIME
7:38
2008-06-27
39
YouTubersLoveExcel#49: Data Forms
5:48
2008-07-07
40
YouTubersLoveExcel#50: Macro & Form Button
9:09
2008-07-07
41
YouTubersLoveExcel#51: VLOOKUP & Variable Labels
6:10
2008-07-07
42
YouTubersLoveExcel#52: VLOOKUP & Workbook References
7:38
2008-07-07
43
YTLE#53: Excel Pivot Table and COUNTIF function
3:26
2008-07-14
44
YTLE#54: Excel Advanced Filter and COUNTIF function
3:09
2008-07-14
45
YTLE#55: Excel 2007 Remove Duplicates and COUNTIF function
2:30
2008-07-14
46
YTLE#56: Excel Count Unique Values Greater Than $30
10:52
2009-01-06
47
YTLE#57: NPER function and Infinity
2:03
2008-07-14
48
YTLE#58: Data Validation & Excel 2007 Tables
3:15
2008-07-18
49
YTLE#59: Pivot Table for Age Account Receivable
4:30
2008-07-18
50
YTLE#60: Hide Columns by Grouping
1:39
2008-07-18
51
YTLE#62: VLOOKUP INDIRECT & Lookup in Different Tables
3:30
2008-07-18
52
YTLE#63: Array Formula: Vendor Max Rating Min Cost
5:07
2008-07-23
53
YTLE#63.5: Range of Array Formulas
9:47
2008-07-24
54
YTLE#64: D Function: DAVERAGE DSUM & more
10:11
2008-07-24
55
YTLE#65: Merge 2 Tables: VLOOKUP & Advanced Filter
8:00
2008-07-24
56
YTLE#66: VLOOKUP replaces IF, Again!
3:06
2008-07-24
57
YTLE#66.5: 3 ways to Hide Formula Errors
7:16
2008-07-24
58
YTLE#67: VLOOKUP & DGET functions
7:55
2008-07-28
59
YTLE#68: 3 Ways To Use Fill Handle for Copying
3:50
2008-07-28
60
YTLE#69: Auto Fill Options (Dates Are The Best!!)
4:57
2008-07-28
61
YTLE#70 PivotTable & TRIM function & AVERAGES
8:32
2008-07-28
62
YTLE#71: Randomize Math Problems for Kids. Excel.
9:35
2008-07-28
63
YTLE#72: Turn Off Auto Format
2:42
2008-07-30
64
YTLE#73: Custom Number Format 00000
2:21
2008-07-30
65
YTLE#74: CLEAN & TRIM functions to fix Bad Data
5:21
2008-07-30
66
YTLE#75: DV Drop-Down based on DV Drop-Down
4:28
2008-07-30
67
YTLE#76: Data Analysis & INDIRECT function
6:27
2008-07-30
68
YTLE#77: INDEX INDIRECT MATCH functions for Payroll
9:01
2008-07-30
69
YTLE#78: Conditional Format for Entire Table
2:34
2008-08-04
70
YTLE#79: Formula for Running Total (Inventory)
6:02
2008-08-04
71
YTLE#80: Conditional Format MATCH & INSUMBER functions
8:18
2008-08-04
72
YTLE#81: Conditional Format CHART??
7:27
2008-08-04
73
YTLE#82: Enter UPPER Case Text Only Into The Cell
4:16
2008-08-07
74
YTLE#83: Two Or Fewer Decimals Only Into The Cell
9:45
2008-08-07
75
YTLE#84: A Few Data Validation Tricks
8:23
2008-08-07
76
YTLE#85: Isolate Unique Records w OR function
4:29
2008-08-07
77
YTLE#86: Pivot Table Filtering & Functions
5:15
2008-08-07
78
YTLE#87: Remove Rows w Blanks Go To Trick
3:54
2008-08-11
79
YTLE#88: Macro to Remove Rows, Absolute
10:19
2008-08-11
80
YTLE#89 part 2: VBA Code for Relative & Absolute Macro
5:47
2008-08-12
81
YTLE#90: Formula: Average w MONTH criteria
7:07
2008-08-11
82
YTLE#91: PivotTable: Average w MONTH criteria
4:59
2008-08-11
83
YTLE#92: AVERAGE function sees Zeroes but not Blanks!
1:59
2008-08-11
84
YTLE#93: "Go To Special Blanks" Caveat
3:22
2008-08-12
85
YTLE#94: Excel's Best Keyboard Shortcut
6:56
2008-08-12
86
YTLE#95: Complex Advanced Filter Extract
10:07
2008-08-12
87
YTLE#95.2: Identifying Customers in Database
5:29
2008-08-12
88
YTLE#96: Names, Printing, AREAS function
3:17
2008-08-12
89
YTLE#97: 5 Ways To Enter Formula in Excel
4:31
2008-08-13
90
YTLE#98: Excel ADDRESS function
8:01
2008-08-13
91
YTLE#99: The Number e in Excel
2:44
2008-08-13
92
YTLE#100: Array Formula Database Customer Evaluation
8:37
2008-08-13
93
YTLE#101: Custom Number & Conditional Formatting - Excel
5:35
2008-08-30
94
YTLE#102: Count Dates given 2 Criteria - Excel
6:04
2008-08-30
95
YTLE#103: Excel Goal Seek
3:45
2008-08-30
96
YTLE#104: Find 1st Positive# in Excel List
6:24
2008-08-30
97
YTLE#105: Excel OFFSET for Dynamic Range in Function
8:49
2008-08-30
98
YTLE#106: Alternatives To Pivot Tables - Excel
9:23
2008-08-30
99
YTLE#107: Excel Time Across 2 Days Trouble
6:51
2008-08-30
100
YTLE#108: Excel Number of Days In Year
4:21
2008-08-30
101
YTLE#109: Daily Interest RATE Schedule in Excel
3:08
2008-08-30
102
YTLE#110: Excel Forms Scroll Bar Linked To Cell
3:21
2008-08-30
103
YTLE#111: Excel AVERAGE w Multiple Criteria
4:20
2008-08-30
104
YTL Excel #112: VLOOKUP Problem (Sort Ascending)
3:22
2008-09-09
105
YTL Excel #113: VLOOKUP RIGHT 5 characters only
2:55
2008-09-09
106
YTL Excel #114: Copy Table & Name to New Workbook
4:05
2008-09-09
107
YTL Excel #115: Time Delayed Formula TODAY & IF functions
3:38
2008-09-09
108
YTL Excel #116: Edit Recorded Macro
8:54
2008-09-09
109
YTL Excel #117: Select Sample Data from List
9:14
2008-09-09
110
YTL Excel #118: Form Controls Linked To Cells
6:37
2008-09-09
111
YTL Excel #119: Amazing Lookup Solution! INDIRECT &SUBSTITUTE functions & Defined Names
6:28
2008-09-09
112
YTL Excel #120: Formula To Wrap Text
5:55
2008-09-09
113
YTL Excel #121: CHAR & CODE & MID functions
6:31
2008-09-11
114
YTL Excel #122: Advanced Filter to a New Sheet (Formula Criteria)
5:19
2008-09-11
115
YTL Excel #123: Array Formula To Count E-mails
4:50
2008-09-11
116
YTL Excel #124: Pivot Table Bowling Average
5:40
2008-09-11
117
YTL Excel #125: Array Formula w IF & AVERAGE functions
10:28
2008-09-11
118
YTL Excel #126: VLOOKUP & INDIRECT & COLUMN functions
10:34
2008-09-17
119
YTL Excel # 126 part 2: VLOOKUP & INDIRECT & ROW
3:06
2008-09-17
120
YTL Excel # 126 part 3: Conditional Formatting w Formulas
4:25
2008-09-17
121
YTL Excel #127: AVERAGE When Hurdle Met
2:20
2008-09-17
122
YTL Excel #128: Set Default Chart
5:40
2008-09-17
123
YTL Excel #129: Zip Code, VLOOKUP & TEXT functions
4:40
2008-09-17
124
YTL Excel #130: Income Statement from Excel Table: Array For
10:21
2008-09-17