Excel is Fun | 553E66EACBA724678E6CACF98F462868F9CA230D

Excel is Fun

Name	Excel is Fun! 2	DOWNLOAD Copy Link
Total Size	17.4 GB
Total Files	901
Hash	553E66EACBA724678E6CACF98F462868F9CA230D

/.../MANY Magic Tricks/
627 FREQUENCY Array Function (10 Examples).flv	111.0 MB
452 IF Function Formula 16 Examples.flv	84.6 MB
703 Extract Records Multiple Criteria (AND OR logic) Filter. Formula. Adv. Filter.flv	77.4 MB
440 Array Formulas Advanced Tips.flv	67.2 MB
524 Extract Records Partial Text Not Criteria 4 Methods.flv	65.9 MB
690 Extract Unique Records Based on 2 Columns. List Values Horizontally.flv	59.0 MB
604 Mixed Cell References in Formulas - Budgeted Income Statement.flv	57.7 MB
265 Mixed Cost Accounting Linear Regression - Ron's Class.flv	57.5 MB
502 Excel Date Formatting & Calculations (21 Examples).flv	54.1 MB
506 Summarize Data - Multiple Sheets & Banks Accounts - Checkbook Register.flv	53.8 MB
449 Excel Data Analysis Abbreviated Notes.flv	53.4 MB
698 Extract Unique Items for Data Validation Drop-Down List.flv	51.8 MB
762 Two Way Lookup from Multiple Tables & Lookup Tables Sorted Descending.flv	46.3 MB
362 12 Amazing Counting Formulas.flv	45.1 MB
616 LARGE & SMALL Functions (8 Examples).flv	44.9 MB
349 Automatic Dynamic Chart for Last Nine Weeks of Data.flv	44.8 MB
744 Break Even Analysis Formulas Chart & Plotting Break Even Point On Chart.flv	43.7 MB
759 Array Formula to Sort List & Remove Duplicates - Dynamic Named Range.flv	43.6 MB
754 Extract Records for Invoices 30 Days Past Due -- Formula Method.flv	42.0 MB
337 RANK function 10 Examples.flv	41.5 MB
758-1 Extract Data With Two Criteria - 5 Formula Methods.flv	41.3 MB
712 Formula to Take Data in Column and Make Proper Table for Name and E-mail.flv	41.1 MB
629 HR Salary Calculation Based On Relevant Years Worked (2 methods).flv	40.8 MB
718 Calculate Hours Worked (Day or Night Shift) & Subtract Lunch.flv	40.8 MB
479 Reverse Two Way Lookup - Robust Formula for Duplicate Situations.flv	40.8 MB
709 Defined Name Dynamic Range Formula w Relative References & Data Extract.flv	40.5 MB
407 Amortization Table W Variable Rate.flv	40.0 MB
756-2 Add Monday to Friday Sales Only From Totals On Many Sheets.flv	38.6 MB
620 Count Unique Items in List - Robust Formulas & A Few Array Formula Tricks.flv	38.5 MB
473 Extract Unique Records with Formula (Complex Array Formula).flv	38.3 MB
488 VLOOKUP with 2 Lookup Values Return Table of Values & Track #Down Errors.flv	38.1 MB
699 VLOOKUP Mixed Number & Letter Partial Text Extract for Lookup Value.flv	37.9 MB
113 Nested IF & Short Term Loans.flv	37.8 MB
104 National Debt Web Query.flv	36.7 MB
356 Dynamic Two-Way Look Form Different Workbook.flv	36.7 MB
274 Probabilities Binomial Distribution.flv	36.4 MB
755 Extract Records for Invoices 30 Days Past Due -- Advanced Filter & MACRO.flv	36.2 MB
308 Extract Data to New Workbook W Formula.flv	35.7 MB
758-2 Extract Data With Four Criteria VLOOKUP & INDEX SUM. AND. OR Functions.flv	35.5 MB
683 3 AND criteria & 3rd AND has OR criteria -- Add. Count & Conditional Format.flv	35.5 MB
125 Charting functions of X in Excel.flv	35.3 MB
108 Exchange Rate Table From Web Query.flv	35.3 MB
458 OR and AND criteria Together in Data Extract Array Formula Boolean Logic Math.flv	35.1 MB
144-1 Formula Avoid Data Validation 1 Rule Limit.flv	34.9 MB
741 Avoid Errors & Blanks in Chart Using Formulas & Defined Name Dynamic Ranges.flv	34.9 MB
142-2 Array Formula for Counting Dates.flv	34.9 MB
623 PayDay LoansAre Bad Finance -- APR & EAR & Amortization Table.flv	34.4 MB
697 Extract Month Year Records From Transactional Data - 3 Methods.flv	34.2 MB
704 Analyzing Problem and Building Robust Solution.flv	34.1 MB
142-1 Custom Number Format & Conditional Formatting for Dates & Weekends.flv	33.8 MB
368 Count Unique Items With More Than One Criteria.flv	33.8 MB
609 Array Formula to Return Multiple Items - List Periods That Students Have Free.flv	33.7 MB
358 Part 1 Return Multiple Items From One Lookup Value for Table w Formula.flv	33.5 MB
515 Amortization Table Pay Off Early & Trouble Shoot Formula Creation.flv	33.4 MB
636 Dynamic Frequency Table & Histogram Chart.flv	33.2 MB
589 Stem & Leaf Chart for Decimals - Array Formula - Statistics.flv	33.1 MB
180 COUNTIF function formula 21 Examples.flv	33.1 MB
584 Dynamic Range for Periodic Data Dumps into Excel OFFSET & Defined Names.flv	33.0 MB
521 Bankers Rounding (Half-Way-Even) vs Arithmetic Rounding.flv	32.4 MB
569 Extract Past Due Loans - Dynamic Formula.flv	32.4 MB
538 Dynamic Sub Tables Based On Master Sheet Array Formula & Drilling Through.flv	32.2 MB
735 Find Max Running Three Week Totals SUBTOTAL OFFSET Array Formula.flv	32.0 MB
200 2007 Table Formula Nomenclature.flv	31.9 MB
673 Varying Commission Rate Lookup Formula SUMPRODUCT Amazing Solution!!.flv	31.9 MB
117 Reverse 2-Way Lookup Part 1.flv	31.8 MB
574 Array Formula for Filtering Data With Categories of Criteria.flv	31.8 MB
213 Dynamic Data Extract w Formula.flv	31.7 MB
760 OR AND AND Logical Test to Extract Data With Formula or Advanced Filter.flv	31.4 MB
559 Extract Nth Word in Text String.flv	31.3 MB
124 Box Plot or Box & Whisker.flv	31.3 MB
626 Time Gantt Chart -- Conditional Formatting & Data Validation Custom Formulas.flv	31.3 MB
334 VLOOKUP & Data Validation for Invoice.flv	30.8 MB
336 Incrementing Numbers in Formulas.flv	30.7 MB
320 Lookup Adding SUMPRODUCT & SUMIF.flv	30.5 MB
608 Array Formula to Return Multiple Items - List Students With Free Periods.flv	30.5 MB
442 Summarize Monthly Sales With Daily Transactional Dates - 5 Methods.flv	30.4 MB
161 Go to Tricks Complete Story.flv	30.4 MB
126 Macro Advanced Filter Extract Text.flv	30.1 MB
251 Formula Unique List within Unique List.flv	30.0 MB
642 SUMIFS function or PivotTable for Household Budget Summary Table.flv	29.9 MB
576 Dynamic Break Even Chart using INDEX and MATCH functions.flv	29.8 MB
714 Three Criteria Lookup Adding SUMIF. INDEX. MATCH. SUMPRODUCT (2 examples).flv	29.8 MB
122 Sum With More Than 1 Criteria.flv	29.7 MB
315 SUMIF Only Accept Ranges. Not Arrays.flv	29.2 MB
501 Excel Time Format & Calculations (10 Examples).flv	29.2 MB
329 Frequency Polygon With 2 or More Line.flv	29.1 MB
497 Unit Inventory Total for Each Store SUMIFS or SUMPRODUCT functions.flv	29.1 MB
628 VLOOKUP Data Validation IF Function Date Math Total After Discount Template.flv	28.9 MB
148 Dynamic List from Table #3.flv	28.7 MB
644 Recorded Macro And Formulas to Re-Arrange Data Set.flv	28.6 MB
131 Ranking w MIN IF OFFSET.flv	28.4 MB
253 Data Table 1 Variable What If Analysis.flv	28.3 MB
507 Fix Bad Data So We Can Add With Two Criteria & Make Summary Report.flv	28.3 MB
232 Add w 3 Criteria OR 2 Criteria.flv	28.3 MB
519 SUBSTITUTE & REPLACE Functions.flv	28.3 MB
508 VLOOKUP with Dynamic Table using OFFSET function.flv	28.1 MB
369 Compare 2 Lists. Extract Records Not Listed Twice.flv	27.9 MB
261 Random Num 1- 100 Not Divisible By 3.flv	27.8 MB
371 Average Time Between Customer Orders AVERAGEIF & AVERAGE IF.flv	27.7 MB
647 Dynamic Line Chart for Cash Balance using OFFSET function.flv	27.7 MB
111 Build A Questionnaire.flv	27.6 MB
745 Allocating Indirect Expenses to Calculate Departmental Net Income Accounting.flv	27.6 MB
263 Math Function of X & Dynamic Charts.flv	27.3 MB
597 Counting With 4 Criteria Including All Criteria Robust Formula.flv	27.3 MB
241 Data Validation w Shrinking List.flv	27.2 MB
130 3 Dimensional Database in Excel.flv	27.2 MB
661 AGGREGATE function Contains 19 different functions.flv	27.1 MB
708 Lookup Multiplying -- SUMPRODUCT. Boolean. & INDEX MATCH solution.flv	27.0 MB
242 Excel Sudoku Puzzle.flv	27.0 MB
438 Counting Workdays Without NETWORKDAYS Function (Weekend is not Sat. & Sun.).flv	26.9 MB
607 Match 3 Lists Matching Accounting Documents PO. Receiving & Invoice.flv	26.7 MB
540 Extract New Records Not in Old List - Array Formula Method.flv	26.7 MB
187 Unique List w Dynamic Formula.flv	26.6 MB
185-2 Advanced Filter Data Extract 1criter.flv	26.6 MB
376 Stem & Leaf Chart for Big Numbers.flv	26.4 MB
409 VLOOKUP MAX Value. Return More Than 1 Record.flv	26.3 MB
021 BINOMDIST function for Probability.flv	26.2 MB
393 Remove Last Two Words From Column of Data.flv	26.1 MB
297-2 Conditional Sum for Varying Columns.flv	26.1 MB
532 Count Blanks in Dynamic Range INDEX MATCH COUNTBLANK functions.flv	26.1 MB
183 Income Statement by Year & Month.flv	26.0 MB
496 Attendance Sheet with Freeze Pane. IF & SUM functions. Custom Date Formatting.flv	25.9 MB
652 Boolean Logic for Logical & Array Formulas.flv	25.9 MB
219 Pivot Table Macro w Dynamic Range #2.flv	25.8 MB
272 Count Unique or Duplicate Records.flv	25.8 MB
149-1 Reverse 2-Way Lookup No Duplicates.flv	25.7 MB
335 VLOOKUP & Data Validation for Recipes.flv	25.7 MB
403 March End Quarterly Comparative Report - Pivot Table.flv	25.6 MB
617 Fiscal Years Not Ending Dec 31 - Total Sales & Year Over Year Formulas.flv	25.6 MB
625 INDIRECT SUBSTITUTE SUBSTITUTE Silly Two Way Lookup Formula.flv	25.4 MB
205 Get C21 Values From Across Sheets.flv	25.3 MB
671 AGGREGATE function Array Formula #5 Extract Records 2 criteria.flv	25.2 MB
233 2 Business Math Tricks.flv	25.2 MB
478 Reverse Two Way Lookup for Date and Time Column and Row Headers.flv	25.2 MB
583 AVERAGEIF & IFERROR functions Mixed Cell References Gross Profit Percentage.flv	25.1 MB
110 Partial Text Conditional Formatting.flv	25.1 MB
022 NORMDIST function for Probability.flv	25.1 MB
431 Excel 4 GET.CELL Macro Function.flv	25.0 MB
565 Excel 2010 Daily Gantt Chart.flv	25.0 MB
687 Exclude Values Less Than Zero From Non-Contiguous Ranges - Amazing!.flv	24.8 MB
328 VLOOKUP Without 1st Column.flv	24.8 MB
215 Dynamic Print Range.flv	24.7 MB
121 Count With More Than 1 Criteria Condition.flv	24.7 MB
757-1 Two Lookup Values & 2 Lookup Columns Great Formula INDEX & MATCH.flv	24.7 MB
184 Setup Database in Excel.flv	24.5 MB
520 FIND & SEARCH Functions.flv	24.4 MB
133 Import CSV Data.flv	24.4 MB
254 Data Table Creates 100 Formulas.flv	24.3 MB
670 AGGREGATE Function Array Formula #4 Extract Records 1 criterion.flv	24.3 MB
549 Dynamic Data Validation List Drop-Down OFFSET or Table Feature.flv	24.3 MB
415 Summarize Survey Results 2 Different Methods.flv	24.3 MB
677 AVERAGE Last 3 Scores -- Mr Excel Message Board Array Formula.flv	24.2 MB
176 Get Last Item in Column on Diff Sheet.flv	24.2 MB
158 VLOOKUP w 2 Variables As Criteria.flv	24.2 MB
509 VLOOKUP with Dynamic Table using Table Nomenclature.flv	24.1 MB
288 Count Character or Nums. in Text String.flv	24.0 MB
489 Extract Only Numbers From Text String Array Formula.flv	24.0 MB
454 Get Last Number or Word or Anything 4 Amazing LOOKUP functions.flv	24.0 MB
313 Some Facts About Array Formulas.flv	23.9 MB
455 Advanced Filter Macro Extract Grant Records Under A Cumulative Total.flv	23.9 MB
542 PivotTable Count How Many Times A Word Occurs in Word Document.flv	23.8 MB
765 Formula to Sort Top 3. Including Ties.flv	23.7 MB
757-2 Two Lookup Columns or Sum With Two Criteria.flv	23.6 MB
174 Smartest Excel People in the World.flv	23.5 MB
317 MID function Pattern Recognition.flv	23.4 MB
557 CHOOSE function to lookup Formula or Function (2 Examples).flv	23.4 MB
720 Show Records Between 2 Dates Filter. Logical Formula. Conditional Formatting.flv	23.2 MB
360 Part 3 Return Multiple Items From One Lookup Value for Row w Formula.flv	23.1 MB
624 Hours Worked Part Day Shift & Part for Night Shift MEDIAN Function for Hurdle.flv	23.0 MB
165-1 MACRO Advanced Filter Extract B-days.flv	23.0 MB
293 Dynamic Count Unique Words in Column.flv	22.9 MB
505 INDIRECT function 2-Way Lookup Date Trouble.flv	22.9 MB
231 VLOOKUP w 3 Tables on Diff Sheets.flv	22.9 MB
517 Vendor Name for Low Bid & % Cheaper Than Next Lowest Bid Formula.flv	22.7 MB
162 LARGE IF & INDEX w 4 Criteria.flv	22.7 MB
679 Adding Yearly Totals From Monthly Data - Date Formatting Trouble (2 Examples).flv	22.7 MB
327 Gantt Chart with Weekends and Holidays.flv	22.6 MB
306 MCONCAT LOOKUP functions (CAT = 593).flv	22.6 MB
156 List of Unique Items w Formula From 2 Lists.flv	22.5 MB
197 Grade Book with Weights.flv	22.4 MB
568 SUMIFS function Monthly Running Total from Transaction Data.flv	22.4 MB
667 AGGREGATE Function Array Formula #2 Return 5 Largest Values.flv	22.3 MB
289 LEN & SUBSTITUTE functions Counting Tricks.flv	22.2 MB
534 Conditional Formatting for Weekends and Holidays.flv	22.2 MB
733 Expected Returns for Portfolio SUMPRODUCT & MMULT functions.flv	22.1 MB
182 Workbook References.flv	22.0 MB
297-1 Add Certain Column Only.flv	22.0 MB
100 Instead of Long IF. Use MEDAIN function Commission W Hurdle Calculation.flv	22.0 MB
701 Take Table of Values and Place in Column With Formula.flv	21.8 MB
296 Conditional Format Intersection Row & Column.flv	21.8 MB
196 Grade Book That Subtracts Two Lowest.flv	21.7 MB
354 2 Criteria Counting for Blood Sugar Levels.flv	21.7 MB
352 English and Math Comparative Operators.flv	21.7 MB
453 VLOOKUP for Commission Brackets Calculation (LOOKUP function also).flv	21.7 MB
173 Time Over or Under (Negative Time).flv	21.7 MB
571 VLOOKUP to Create Form from Access Linked Data Import.flv	21.6 MB
575 Conditional Formatting & Counting with 3 Criteria & Find Formula Mistakes.flv	21.6 MB
587 Conditional Formatting 3 Criteria including SEARCH for Text Contains Criteria.flv	21.6 MB
301 1900 Date Problems and Fixes.flv	21.6 MB
307 Invert Range With Formula.flv	21.5 MB
659 Advanced Filter Using Formula Criteria to Extract Sample Data.flv	21.5 MB
255 Data Table 2 Variable What If Analysis.flv	21.4 MB
323 Partial Text VLOOKUP (Fuzzy Match).flv	21.0 MB
262 Dynamic Weekly Chart.flv	21.0 MB
153 Conditional Formatting for Incentive.flv	20.8 MB
338 Extract Records By E-mail Extension.flv	20.8 MB
434 Extract Completed Records with Formula.flv	20.8 MB
303 VLOOKUP from middle of text-string.flv	20.8 MB
498 6 PivotTable Calculation Tricks (Pivot Table).flv	20.7 MB
236 Excel for Home Improvement.flv	20.7 MB
526 Grading Pass Fail or Letter Grade Formula IF. AND. VLOOKUP functions.flv	20.7 MB
185-1 Dynamic Formula Extract Data 1criteria.flv	20.6 MB
160 Find & Replace Format or Formula.flv	20.5 MB
287 Lookup Adding - Array & Non-Array Formula.flv	20.5 MB
425 Functions That Can Handle Array Syntax - But are Not Array FormulasFunctions.flv	20.5 MB
748 Count Weekends With No Events Scheduled Formula.flv	20.4 MB
324 Dynamic Data Validation List of Dates.flv	20.3 MB
163 Formula Return Descending Sorted List.flv	20.3 MB
752 Fill Column With Categories Using Approximate Lookup Formula.flv	20.3 MB
518 Show Multiple Vendor Names Associated With Low Bid Array Formula INDEX.flv	20.3 MB
243 MEAN MEDIAN MODE STDEV Histogram.flv	20.2 MB
614 Extract Full Date from Monthly Dates Listed As Text -- Pivot Table.flv	20.2 MB
165-2 MACRO Advanced Filter Extract B-days.flv	20.2 MB
150 Formatting Guidelines (Eye Candy).flv	19.9 MB
264 Absolute & Relative Macro Fix Data.flv	19.9 MB
168 Cross Tabulation for a Survey.flv	19.8 MB
622 Array Formula to Return Even Row Data Only.flv	19.8 MB
531 Extract Numbers from Middle of Text String BB34G to 34 (2 methods).flv	19.8 MB
510 Amortization Table That Changes When Year Input is Changed.flv	19.8 MB
294 Filter Pie Chart w Formula & Pivot Table.flv	19.7 MB
118 Reverse 2-Way Lookup Part 2.flv	19.7 MB
132 Borders for an Accounting Template.flv	19.6 MB
203 SUMIF function formula 21 Examples.flv	19.5 MB
702 VLOOKUP Return Two Values to One Cell or Two Cells.flv	19.5 MB
666 AGGREGATE Function Array Formula #1 Single Cell Array Formula.flv	19.5 MB
316 Concatenate Selection w Criteria (MoreFunc Excel Add-in functions).flv	19.5 MB
286 MOD function & Time Calculations (Time for Night Shift. or Negative Time).flv	19.3 MB
606 INDEX & MATCH Two Lookup Values.flv	19.2 MB
149-2 Reverse 2-Way Lookup w Duplicates.flv	19.2 MB
562 Extract Names - Some Names in List Have Middle Name Some Do Not.flv	19.1 MB
357 Excel Efficiency Proper Data Setup. Then Lookup From Different Sheet.flv	19.1 MB
208 Ctrl + Enter 6 Examples of Efficiency.flv	19.1 MB
764 CHOOSE Function to Mash Columns Together to Create Lookup Tables.flv	19.0 MB
445 Complicated Criteria for MODE calculation LOOKUP.flv	19.0 MB
480 Percentage of Total - Formula or PivotTable (Pivot Table).flv	19.0 MB
650 Formula to Extract All Rows in Data Set into 1 Column INDEX function.flv	19.0 MB
267 Percentage Change Formula & Chart.flv	18.9 MB
724 VLOOKUP Check #If Quantities are Equal in Two Lists Show Differences If Not.flv	18.9 MB
240 Dynamic Range New Data at Top.flv	18.9 MB
258 Chart From Noncontiguous Data.flv	18.8 MB
672 AGGREGATE function Replaces SMALL Function Array Formula.flv	18.8 MB
700 Return Every Other Cell (Cell Reference That Skips Columns) INDEX Function.flv	18.8 MB
729 VLOOKUP When Multiple Lookup Items in Cell LOOKUP & SEARCH functions.flv	18.8 MB
602 SUMIF Does Lookup Total Sales Array Formula w 1 Criteria SUMIF Function.flv	18.8 MB
154 Personal Budgets and VLOOKUP.flv	18.7 MB
094 VLOOKUP into Web Query.flv	18.7 MB
351 Dynamic Area Chart (Plot x & f(x) on Area Chart).flv	18.6 MB
381 Merge Two Lists Tables w Advanced Filter and Remove Duplicates Feature.flv	18.6 MB
596 Counting With 4 Criteria Including All Criteria As A Possibility.flv	18.6 MB
722 Calculate Gross Pay for Week From Time Values in Range & Hourly Wage.flv	18.6 MB
404 Quarterly Comparative Report SUMIFS function.flv	18.5 MB
577 Find Duplicates. Then Extract Unique Records.flv	18.5 MB
305 SUM digits from string.flv	18.5 MB
621 Conditional Formatting Unique Items With One Criteria.flv	18.5 MB
446 Time in & Time Out in Same Cell Bad Setup Leads to Complicated Formula.flv	18.4 MB
536 List All Modes in Multimodal Data Set MODE.MULT Excel 2010 Function.flv	18.4 MB
359 Part 2 Return Multiple Items From One Lookup Value for Column w Formula.flv	18.3 MB
436 VLOOKUP W 4 Lookup Columns.flv	18.3 MB
146-1 Dynamic List from Table #1.flv	18.3 MB
188 Page Setup Across Multiple Sheets.flv	18.3 MB
341 Extract Data w OFFSET & INDEX function.flv	18.2 MB
135 Find Last Row & Column Dynamic Range.flv	18.2 MB
564 Daily Gantt Chart.flv	18.2 MB
167-2 IF function formula 12 Examples!.flv	18.2 MB
447 AND & OR functions for Advanced Filter Extract to New Sheet.flv	18.1 MB
551 Count Mondays or Sundays or Tuesdays. etc. Between Start & End Date.flv	18.1 MB
102 Conditional Formatting Duplicates.flv	18.1 MB
528 Check #Two Lists for Discrepancies MATCH and VLOOKUP functions.flv	18.1 MB
151 DATEDIF function (between two dates).flv	18.0 MB
688 Lookup All Values in Expanding Dynamic Row and then Add.flv	18.0 MB
668 AGGREGATE Function Array Formula #3 Calculate 90 Percentile CPA Scores.flv	18.0 MB
171 MACRO Data Validation from 3 lists.flv	18.0 MB
175 Count Between Upper & Lower Value.flv	18.0 MB
276 MoreFunc Excel add-in 66 New functions.flv	17.9 MB
655 Frequency Polygon Line Chart.flv	17.8 MB
207 Business Math Word Problem Setup.flv	17.8 MB
401 Quarterly Comparative Report - Pivot Table (PivotTable).flv	17.8 MB
198 3 Formulas for Frequency Distribution.flv	17.7 MB
105 Extract Records Trick.flv	17.7 MB
588 2 VLOOKUP Functions looking into 2 Different Tables.flv	17.7 MB
696 Identify First Occurrence in Column (5 methods).flv	17.6 MB
613 Array Formula Year Over Year Sales Calculation From Dates Listed As Text.flv	17.5 MB
011 How Good is Your Average.flv	17.5 MB
674 OR Criteria Counting 3 Examples COUNTIF. SUMPRODUCT & SUM-COUNTIF.flv	17.5 MB
761 Formula Displaying Multiple Modes & Counting Modes Excel 2010 MODE.MULT.flv	17.4 MB
186-1 Dynamic Formula Extract Data 2 criteria.flv	17.4 MB
572 COUNTIF & SUMIFS functions & Logical Formulas have Different Syntax.flv	17.3 MB
514 Conditional Formatting Duplicate Values (3 Methods).flv	17.3 MB
400 Show List of Values in Cells After Using Data Validation Drop-Down.flv	17.2 MB
273 Extract Top 5 Records w Formula.flv	17.2 MB
167-1 IF function formula 12 Examples!.flv	17.2 MB
382 Match Two Lists. Extract Column Data From Each List.flv	17.1 MB
204 Scatter & Bar Chart Together.flv	17.1 MB
753 Extract Records for Invoices 30 Days Past Due -- Filter Method.flv	17.1 MB
147 Dynamic List from Table #2.flv	17.0 MB
145-4 STDEV IF Standard Deviation IF.flv	17.0 MB
189 Count Days Not Sunday.flv	16.9 MB
548 Data Validation Drop-Down List in A Cell Same Sheet or Different Sheet.flv	16.9 MB
001 Formulas & Cell References.flv	16.9 MB
103 Pie Chart for Student Scores.flv	16.9 MB
682 Averaging Times Entered As Text (3 Examples) Array Formula.flv	16.9 MB
013 SUM or COUNT only certain items! SUMIF COUNTIF functions.flv	16.9 MB
128 VLOOKUP Categories.flv	16.9 MB
664 AGGREGATE function Ignores Nested SUBTOTALs for Calculations.flv	16.9 MB
225 2 Way Lookup With Duplicates.flv	16.8 MB
246 Waterfall Profit Chart.flv	16.8 MB
239 Graphing Functions of X Scatter Diag.flv	16.7 MB
312 Extract Date & Time From Text String.flv	16.7 MB
015 SUM or COUNT Above Some Limit!.flv	16.6 MB
580 Extract Digits to Right of Decimal into Individual Cells.flv	16.5 MB
527 VLOOKUP 3rd Argument 4 Methods Number. COLUMN. COLUMNS. MATCH.flv	16.5 MB
451 Prefix Lookup & White and Greater Than 15 lbs Lookup.flv	16.5 MB
465 Lookup Entire Row (ALL COLUMNS) with INDEX for Cake Manufacturing Calculation.flv	16.5 MB
493 Repeat a List of Names 7 times.flv	16.5 MB
194 Grade Book Based on Percentages.flv	16.5 MB
291 Add Nums Associated w Codes From String.flv	16.5 MB
727 Calculate Hours Worked Night or Day Shift With Break for Lunch.flv	16.3 MB
345 Find 1st Positive number and assign 1 MATCH & COUNTIF functions.flv	16.3 MB
482 2 Pivot Tables with Different Date Groupings On Same Sheet.flv	16.2 MB
535 Count Weekdays Including Half Days NETWORKDAYS & NETWORKDAYS.INTL.flv	16.2 MB
372 WORKDAY function - Find Date in Future.flv	16.2 MB
738 Goal Seek. PMT function for Loan Payment. Cash Flows and Balloon Payment.flv	16.2 MB
114 GetPivotData ISERROR and IF function.flv	16.2 MB
637 Lookup A Chart -- Defined Names. INDIRECT function and Formulas in Pictures.flv	16.1 MB
332 Insert Text with REPLACE function.flv	16.1 MB
143 VBA Avoid Data Validation 1 Rule Limit.flv	16.1 MB
706 Extract Number From Cell With A Time. A Dash and A Number.flv	16.1 MB
539 Extract New Records Not in Old List -- Filter Method.flv	16.1 MB
018 Randomly Generate Letters.flv	16.0 MB
713 Count Max Number in Succession in Column FREQUENCY function magic!.flv	16.0 MB
692 More About Incrementing Numbers in Formulas.flv	16.0 MB
552 Display VLOOKUP Results Vertically.flv	15.9 MB
611 Array Formula Year Over Year Sales Calculation From Daily Transactional Data.flv	15.9 MB
271 Conditional Format w DATEDIF function.flv	15.8 MB
355 VLOOKUP for Mortgage Calculator.flv	15.8 MB
319 VLOOKUP - Lookup Table in Descending Order Use INDEX & MATCH.flv	15.8 MB
230 Dynamic Stock Chart Excel Table List.flv	15.8 MB
558 VLOOKUP to verify if Whole Record is in Table.flv	15.8 MB
675 Double VLOOKUP Custom Formula Dynamic Data Validation.flv	15.7 MB
424 Conditional Formatting for Dynamic Range.flv	15.7 MB
314 Convert TRUE & FALSE to 1 and 0.flv	15.7 MB
736 Formula & Conditional Formatting to Show Waste From Cutting Rebar.flv	15.7 MB
344 MAX IF & RANK functions without Zeros.flv	15.6 MB
590 Nested IF function Convert From Actual Days to Billed Days.flv	15.6 MB
731 Retrieve Cell Address of Minimum Value in Column.flv	15.6 MB
414 Retroactive Dynamic Ranges!.flv	15.6 MB
492 Count Matches in Single Cell.flv	15.6 MB
144-2 Formula Avoid Data Validations 1 Rule Limit.flv	15.5 MB
420 VLOOKUP w SUM function in 3rd argument (Football Betting Table).flv	15.5 MB
550 Data Validation List Drop-Down Based On 2nd Data Validation List Drop-Down.flv	15.5 MB
678 SUM only Values After Deadline Dynamic Range using INDEX Function.flv	15.5 MB
529 Count Sales Over Last 7 Days for Given Product.flv	15.5 MB
107 Array Formula for Monthly Sales.flv	15.4 MB
707 RANK with Criteria - SUMPRODUCT.flv	15.4 MB
443 SUMIF Cumulative Sales Formula & Pivot Table Cumulative Sales Table.flv	15.4 MB
767 Count Months from Start and End Date.flv	15.3 MB
224 Extract Prefix From Product ID.flv	15.3 MB
612 Pivot Table Year Over Year Sales Calculation From Dates Listed As Text.flv	15.2 MB
471 Sort Horizontal With Formula 3 Examples.flv	15.2 MB
106 Gantt Chart for Daily Schedule.flv	15.2 MB
591 Paste Special Operations Add & Multiply.flv	15.2 MB
295 DV Dropdown From Diff Workbook.flv	15.1 MB
257 Convert Dates as Text to Dates As No.flv	15.1 MB
218 Pivot Table Macro w Dynamic Range #1.flv	15.1 MB
248 PERCENTILE QUARTILE functions Decile.flv	15.1 MB
259 Dynamic DV List Based On DV List.flv	15.1 MB
309 Partial Text Match Why 2^15.flv	15.0 MB
005 Data Validation List & VLOOKUP.flv	15.0 MB
166 CONCATENATE function & Ampersand.flv	15.0 MB
737 Sorting Wrecks Formula. Use VLOOKUP function to Solve Problem.flv	14.9 MB
486 Avoid #DIV0! Error in Formula 4 Examples (Divide By Zero Error).flv	14.9 MB
282 Lookup Name When Today is Birthday.flv	14.8 MB
134 Find Last Value in List.flv	14.8 MB
017 Randomly Generate Whole Numbers.flv	14.7 MB
290 Count Codes From Column of Text Strings.flv	14.7 MB
686 Fill Column & Concatenate With LOOKUP Last Word Expandable Range Trick.flv	14.7 MB
203 Sequential Numbers in Formulas ROWS function.flv	14.7 MB
193 Grade Book Based on Total Score.flv	14.6 MB
427 Determine Day Name for Future Date.flv	14.6 MB
129 More than 7 Nested IF functions.flv	14.6 MB
010 3 types of Averages!.flv	14.6 MB
195 Grade Book That Subtracts Lowest Score.flv	14.6 MB
459 Non-Zero numbers = TRUE IF Function logical_test Argument Tricks.flv	14.6 MB
155 VLOOKUP & TRIM function.flv	14.6 MB
140 Sheet Cell References in Formulas.flv	14.5 MB
746 Payback #Rule Dynamic Single Cell Array Formula LOOKUP function Array Magic.flv	14.5 MB
582 Excel Errors 9 Types - What They Mean - How to Fix Them.flv	14.5 MB
756-1 Create Sequential Dates Across Sheets & Extract Sheet Name to Cell.flv	14.4 MB
457 SUMPRODUCT & OR Criteria.flv	14.1 MB
340 Weighted Percent without 2 Lowest (SMALL & LARGE functions).flv	14.1 MB
413 Copied Web Site Data Trouble CLEAN TRIM Text to Columns.flv	14.0 MB
278 Return Every 10th Value w Formula.flv	14.0 MB
586 Count Records 3 Criteria Including Contains Text & SEARCH function.flv	14.0 MB
146-2 Dynamic List from Table #1.flv	13.9 MB
139 HYPERLINK function & Drop Down List.flv	13.9 MB
763 Formula to Sort Words (including Duplicates) and extract data.flv	13.9 MB
468 Count Spaces at Beginning & End of Text String (Array Formula).flv	13.8 MB
410 VLOOKUP Convert Web Query Result 78.9k to 78.900.flv	13.8 MB
206 Artists Commissions & VLOOKUP.flv	13.8 MB
292 Reverse Last & First Name Tricks.flv	13.7 MB
417 Get Last Value from Multiple Sheets.flv	13.6 MB
145-2 MODE IF.flv	13.6 MB
435 Extract Duplicate Records with Formula.flv	13.6 MB
717 List 2 Same Order as List 2 MATCH and ROWS functions.flv	13.5 MB
228 Text Formula & Forced Wrap Text.flv	13.5 MB
490 Conditional Format for Budget Less Than $500.flv	13.4 MB
476 SUMPRODUCT Function for Weighted Average Cost From Transaction Data.flv	13.4 MB
311 Verify ID prefix w OR function 3 Examples.flv	13.4 MB
592 Extract Word That Occurs Most Frequently - MODE for Word - Data Array Formula.flv	13.4 MB
159 VLOOKUP Duplicates 1st Column.flv	13.3 MB
544 Conditional Formatting Row With Multiple Criteria in Other Columns.flv	13.3 MB
333 #DIV0! Error IF & ISERROR or IFERROR functions.flv	13.3 MB
545 Count Between Dates with 3 Criteria COUNTIFS & DCOUNTA & SUMPRODUCT.flv	13.3 MB
211 Advanced Filter Extract ID Variable.flv	13.3 MB
353 Date VLOOKUP for Seasons.flv	13.2 MB
214 Circular Reference in Formula.flv	13.2 MB
680 Add A Scenario Button to Toolbar or Ribbon Excel 2010.flv	13.2 MB
466 SUM every Nth value SUMPRODUCT. MOD & ROW functions.flv	13.2 MB
405 Quarterly Comparative Report SUMPRODUCT function.flv	13.2 MB
416 Add Invoices w Same Prefix (Number v Text problem examined).flv	13.2 MB
012 Date Math!.flv	13.1 MB
634 Text to Text or Number to Number Matches for Logical Formulas.flv	13.1 MB
463 4 ways to Add New Data to A Chart.flv	13.1 MB
601 VLOOKUP & IF functions for Bonus Based On Years Worked.flv	13.1 MB
615 Adding With Approximate Criteria SUMIF Function and Wildcard.flv	13.1 MB
223 Count Single Character in Text String.flv	13.1 MB
639 Approximate Match Lookup with Unsorted Column Across Multiple Columns.flv	13.1 MB
137 Array Syntax for USA & Norway.flv	13.0 MB
421 Conditional Formatting Row with MAX or MIN Value.flv	13.0 MB
237 ROUND to Digit or Multiple.flv	13.0 MB
662 AGGREGATE function Ignores Hidden Rows for Calculations.flv	12.9 MB
547 Calculating Last Time File Was Accessed From Server Computer.flv	12.9 MB
172 Running Total Formula or Pivot Table.flv	12.9 MB
610 Pivot Table Year Over Year Sales Calculation From Daily Transactional Data.flv	12.9 MB
136 Two 2 way lookup with VLOOKUP & MATCH.flv	12.8 MB
695 Allocate Total Costs across Categories Including Extra Pennies.flv	12.8 MB
573 VLOOKUP & OR functions for Filtering Data With Categories of Criteria.flv	12.8 MB
191 Extract Middle Name Formula.flv	12.7 MB
721 Convert Text Time Numbers Without A Colon to Time 0655 into 0655 AM.flv	12.7 MB
411 Expandable Ranges in SUMIFS function.flv	12.6 MB
511 Extract First. Middle. Last Names From Bad Data With Extra Characters.flv	12.6 MB
398 VLOOKUP with Two Lookup Values (IFERROR function also) 2 lookup values.flv	12.6 MB
019 Randomly Generate Words.flv	12.6 MB
321 Match Text Substrings.flv	12.5 MB
003 AVERAGE & Go to Blanks.flv	12.5 MB
119 is Item in List 2 Examples.flv	12.5 MB
728 COUNTIF & AND Functions Check #Whether 3 Specific People Worked Together.flv	12.4 MB
285 Markup On Sell Price Formula.flv	12.4 MB
343 Delete Blanks Rows & Keyboard Magic.flv	12.4 MB
302 Randomly Select Names No Repeats.flv	12.3 MB
373 Randomize with No Repeats (Numbers or Words).flv	12.2 MB
270 Conditional Format Based On Diff Cell.flv	12.2 MB
179 are All Four Word the Same.flv	12.1 MB
638 Two Horizontal Axes for A Chart.flv	12.1 MB
388 Conditional Formatting and the Active Cell.flv	12.1 MB
743 Conditional Formatting to Match Items in List On A Different Sheet.flv	12.1 MB
318 MID Text (substring) VLOOKUP Trouble.flv	12.0 MB
554 Conditional Formatting for Weekends and Holidays Better than EMT 534.flv	12.0 MB
120 ISNUMBER & SEARCH functions.flv	12.0 MB
397 VLOOKUP Copied Down a Column (VLOOKUP Basics).flv	12.0 MB
711 Count Employees in a given County Based on Zip Code SUMPRODUCT COUNTIF.flv	12.0 MB
220 Count Dates in Each Month.flv	12.0 MB
419 Add Two Largest. But Skip Columns C & E.flv	11.9 MB
402 Monthly Comparative Report - Pivot Table.flv	11.8 MB
238 Round Times to 5 Minutes.flv	11.8 MB
719 Comparing Two Lists Trouble 2 Examples (Numbers Not Match Numbers As Text).flv	11.8 MB
750 7 Days Past Due Conditional Formatting & Logical Formula.flv	11.7 MB
299 Date & Time Number - Total Days & Hours Formula.flv	11.7 MB
541 Get Last Price in Column Based On Criteria in Other Columns.flv	11.7 MB
556 Change PivotTable Source Data (Pivot Table).flv	11.6 MB
566 Conditional Format A Chart Student Grades.flv	11.6 MB
766 Count Times Before And After A Stated Time.flv	11.5 MB
116 Find Best Poker Game.flv	11.5 MB
090 Consolidation.flv	11.5 MB
098 Conditional Formatting for Calendar.flv	11.5 MB
663 AGGREGATE function Ignores Error Values for Calculations.flv	11.4 MB
101 IS Functions.flv	11.4 MB
676 Defined Name Dynamic Range Formula (column number varies) INDEX Function.flv	11.3 MB
512 Frugal Bargain Hunters - Series Discounts to Calculate Total Savings.flv	11.3 MB
581 Unique List With Criteria Using Advanced Filter.flv	11.3 MB
450 Number Formatting Abbreviated Notes (House Paint or Halloween Mask).flv	11.3 MB
256 162 Excel Keyboard Shortcuts.flv	11.2 MB
014 Amazing Find & Go to Trick!.flv	11.2 MB
651 Comparative Operators & Logical Formulas.flv	11.2 MB
157 Conditional Format Part of Table.flv	11.1 MB
640 VLOOKUP and Conditional Formatting to Highlight Row with Low Rank.flv	11.1 MB
190 Rearrange First Last Name w Formula.flv	11.1 MB
325 Aggregate Daily Cost to Monthly Cost.flv	11.1 MB
383 Conditional Formatting Between a Max and Min.flv	11.1 MB
394 IF Function and Conditional Formatting.flv	11.1 MB
006 Conditional Formatting for a Row.flv	11.1 MB
279 Create the Series AA. AB. ZZ w For.flv	11.0 MB
725 Which Quartile are You in INPUT your Score. Formula Says Quartile You are In.flv	11.0 MB
164 CEILING function in Price Formula.flv	11.0 MB
374 COUNT Odd or Even Numbers.flv	10.9 MB
595 DGET #NUM! Error same as Advanced Filter Duplicate Problem Extract Record.flv	10.9 MB
483 Sort sees Date Serial Numbers. Filter Sees Format or Serial Numbers.flv	10.8 MB
747 Expected Returns and Standard Deviation Single Cell Array Formula.flv	10.8 MB
202 Calculate Vacation Days.flv	10.8 MB
684 VLOOKUP 1 item & Add Values from Multiple RowsColumns - HLOOKUP.flv	10.8 MB
412 Data Validation Drop Down List & OFFSET function.flv	10.8 MB
395 When ROUND function Must Be Used.flv	10.7 MB
216 Pivot Table 4 Variable Cross Tabulatio.flv	10.7 MB
665 AGGREGATE function Ignores Filtered Values When Making Calculations.flv	10.7 MB
723 COUNTIF Error With Workbook References. Use SUMPRODUCT Instead.flv	10.6 MB
266 Count Words Only w COUNTIF.flv	10.6 MB
734 Downloaded Decimal (Percentage) Grades into Actual Integer Grades.flv	10.5 MB
365 Return First Non-Blank (Not An Array Formula).flv	10.4 MB
002 Chart Keyboard Trick.flv	10.4 MB
715 Take Number with Spaces and Convert to Number.flv	10.4 MB
646 VLOOKUP to add column of categories to Apparel Data Set.flv	10.4 MB
095 DOLLAR function.flv	10.3 MB
009 Join 2 Cells into 1.flv	10.3 MB
649 Formula to increment number pattern 1.1.1.2.2.2.3.3.3.flv	10.3 MB
277 Add 01-12-13-14-15 Text String From.flv	10.2 MB
422 Conditional Formatting 1st Two Rows Regardless of Sort.flv	10.2 MB
268 Conditional Formatting Max in Row.flv	10.2 MB
516 Conditional Formatting Duplicates in Each Row COUNTIF & Mixed Cell References.flv	10.2 MB
363 Return Cell Address of First Non-Blank.flv	10.1 MB
300 YEAR DATE TEXT functions for Date Label.flv	10.1 MB
339 Sum Differences with 2 Criteria SUMPRODUCT.flv	10.1 MB
370 Conditional Formatting Odd & Even Numbers.flv	10.0 MB
561 Wildcards and.flv	10.0 MB
092 Two Chart Types in One Chart!.flv	10.0 MB
209 Formula or Function Confusion.flv	9.9 MB
462 Show Formula Formula - Excel 4 Macro Function GET.CELL.flv	9.9 MB
099 Instead of IF function use MAX and MIN!.flv	9.6 MB
322 NOT Advanced Filter Data Extract.flv	9.6 MB
330 DCOUNT DSUM between 2 Numbers.flv	9.6 MB
467 Conditional Formatting every Nth value (Conditional Format).flv	9.6 MB
710 average with 3 Criteria Using PivotTable Pivot Table.flv	9.5 MB
460 Transpose Range with INDEX. COLUMNS and ROWS functions.flv	9.5 MB
429 Count IDs that are the Equivalent (DELTA function).flv	9.5 MB
648 Interesting Formula to Create A Data Set ROWS. COLUMNS and CAR functions.flv	9.5 MB
654 Charts Line & X Y Scatter.flv	9.4 MB
691 Look at Cell C2 No Matter How Many Rows or Columns You Insert or Delete.flv	9.3 MB
423 INDEX Delivers Cell Reference - Sum Dynamic Range Without OFFSET Function.flv	9.3 MB
657 EOMONTH function for Invoices. Financials. and Quarterly Reports.flv	9.3 MB
593 Mondays Only Data Validation using Custom Formula with WEEKDAY function.flv	9.3 MB
350 Conditional Format Values Listed 3 Times COUNTIF function Trick.flv	9.2 MB
537 Drill Through Spreadsheets -- Formatting. Formulas. Editing.flv	9.2 MB
494 Active Cell Keyboard Shortcut Selection Trick.flv	9.2 MB
361 Line Chart Diastolic & Systolic Blood Pressure.flv	9.2 MB
115 Find 2nd Positive Number.flv	9.2 MB
470 Formula for Days in Any Given Month.flv	9.2 MB
553 SUMIF for Dollars and Euros.flv	9.2 MB
221 LEN function Counts Spaces.flv	9.2 MB
235 Custom Number Format for Inches.flv	9.1 MB
199 Histogram w Conditional Formatting.flv	9.1 MB
377 Add Every Other Number in Range of Cells.flv	9.0 MB
386 Less Than the Letter M Conditional Formatting.flv	9.0 MB
310 D Functions & Date Criteria.flv	9.0 MB
169 Randomly Select Employee From List.flv	9.0 MB
016 Randomly Generate Numbers (0-1).flv	9.0 MB
387 Data Validation Drop-Down List & Cell References.flv	8.9 MB
141-1 Day Numbers to Dates.flv	8.9 MB
152 Extract records w Field Not Blank.flv	8.9 MB
495 Print Labels On Each Page for Large Spreadsheet.flv	8.8 MB
631 Conditional Formatting Invoices 90 Days Past Due.flv	8.8 MB
522 30 Days in Each Month Calculations.flv	8.8 MB
390 Increment Word & Number 2 Methods.flv	8.8 MB
432 Find & Extract Duplicate Records.flv	8.7 MB
730 SUMIF with Approximate Criteria.flv	8.7 MB
304 Charts Add Secondary Axis to Frequency Column Chart.flv	8.7 MB
346 EXPONENTS Formula and Formatting in Excel.flv	8.6 MB
619 Space in Cell Causes Trouble in Formulas. Replace. COUNTA. CLEAN. TRIM.flv	8.6 MB
645 CUMIPMT Function Cumulative Interest for A Loan.flv	8.6 MB
461 Progress Toward Goal Chart or Thermometer Chart.flv	8.5 MB
284 Create Line Chart W Two Number Series.flv	8.5 MB
472 Count Spaces at Beginning & End of Text String Simple Formula.flv	8.5 MB
533 DateTime Calculation excluding Holidays & Weekends.flv	8.5 MB
732 SERIES Chart Function.flv	8.4 MB
245 Matching 2 Lists w IF & OR functions.flv	8.4 MB
269 COUNTIF & Ampersand.flv	8.4 MB
364 Return First Non-Blank (Array Formula).flv	8.3 MB
742 Wrap Text in Chart Label Using CHAR function and Code 10.flv	8.3 MB
693 HOW Long to Double Your Money NPER function or Rule of 72.flv	8.3 MB
249 Data Extract to New Workbook.flv	8.2 MB
326 Hyperlink Worksheet to Worksheet.flv	8.2 MB
366 Lookup Adding for Accounting Estimate.flv	8.2 MB
685 Conditional Format for Alternative Rows.flv	8.2 MB
097 AVEDEV function.flv	8.2 MB
145-3 AVERAGE IF before 2007 Excel.flv	8.2 MB
112 Add Cumulatively.flv	8.2 MB
430 Count Sales Numbers Greater Than Hurdle (GESTEP function).flv	8.1 MB
145-1 MEDIAN IF.flv	8.1 MB
635 Find Perfect Match in Column Using IF & AND functions.flv	8.0 MB
212 Filter Copy Paste Data Extract.flv	8.0 MB
694 SUMIF Can't Handle Arrays. SUMIF(YEAR(A2A10).2010.B2B10) Won't Work.flv	8.0 MB
260 Delete All Invoices w TBO.flv	7.9 MB
347 Magic Moments in Excel! MROUND v ROUND functions.flv	7.9 MB
177 Data Validation Trouble.flv	7.9 MB
433 Custom Number Format for Showing Numbers Rounded to Thousands Position.flv	7.9 MB
740 Avoid Errors & Blanks in Chart Using Filter.flv	7.8 MB
578 Formula to Grade Student Answer Where More Than One Possibility Exists.flv	7.8 MB
170 Conditional Format to Hide Items.flv	7.8 MB
204 Adding w Case Sensitive Criteria.flv	7.8 MB
594 How Old are You DATEDIF Function.flv	7.8 MB
530 Does Text String Contain Repair OR Rework OR SEARCH ISNUMBER functions.flv	7.6 MB
283 Lookup Vendor Name With Low Bid.flv	7.6 MB
441 Count Times That Start With 7 (700. 715. etc.).flv	7.6 MB
599 ROUND Only the Total Column Using SUM & ROUND Array Formula.flv	7.6 MB
192 Extract Middle Name Text to Column.flv	7.6 MB
127 Count Less Than 70% of Max.flv	7.5 MB
252 Text Cell Range in A Function.flv	7.5 MB
379 Round to Nearest 110th Hour for Payroll.flv	7.5 MB
244 Advanced Filter Extract to New Sheet (Word Criteria).flv	7.4 MB
331 EXTRACT Numbers without Leading Zeros.flv	7.4 MB
555 IF & VLOOKUP Formula for Two Distinct Commission Calculations.flv	7.4 MB
186-2 Advanced Filter Data Extract 2 criteria.flv	7.4 MB
546 is Item List Case Sensitive OR & EXACT functions.flv	7.3 MB
181 Count Words Case Sensitive.flv	7.3 MB
504 3D Formatting for Cells Using Borders.flv	7.1 MB
378 Field Names Should Be Formatted.flv	7.1 MB
250 Pivot Table Unique List in Unique List.flv	7.0 MB
500 Years Worked Formula YEARFRAC. INT. DATEDIF functions.flv	6.9 MB
653 Boolean Math Bonus Instead of IF Function.flv	6.9 MB
008 Text to Column.flv	6.9 MB
399 NA Error Trouble in Array Formula.flv	6.9 MB
392 CHOOSE function Randomly Generate 1. 0 or Blank.flv	6.9 MB
585 Deleting Content. Cells. Formatting & the Problem with Right-Click #Delete.flv	6.8 MB
598 Hours Worked in Day Including Lunch Breaks.flv	6.8 MB
234 Trig functions PI RADIANS DEGREES.flv	6.8 MB
484 Stop Automatic Copyright symbol ©.flv	6.7 MB
141-2 Series of Dates.flv	6.7 MB
298 MOD function Formula for Total Time Worked.flv	6.7 MB
275 Reduce Column of Numbers By 35%.flv	6.7 MB
007 Clear Formatting Only!.flv	6.7 MB
485 Create Shorthand to speed up typing using AutoCorrect.flv	6.6 MB
210 Formula Not Calculating Stuck.flv	6.6 MB
487 Hyperlink That Opens Different Workbook or Goes to Different Sheet.flv	6.6 MB
605 IF Function to Fill in Column With Missing Values Paste Special Values.flv	6.5 MB
633 Conditional Format Dates for Year From A List of Dates With Different Years.flv	6.5 MB
469 VLOOKUP for Horsepower Calculation.flv	6.4 MB
217 IF Function Text Logical Test.flv	6.4 MB
348 Formula for Unit Inventory Total SUMIF function Trick.flv	6.4 MB
439 NETWORKDAYS.INTL function Excel 2010.flv	6.3 MB
600 Convert Hours to Days & Hours using MOD & INT functions.flv	6.3 MB
247 Add Leading Zeroes w Formula.flv	6.3 MB
481 Change Operator in Formula from Drop-Down Using CHOOSE function.flv	6.2 MB
726 Count 1 for Each Item in List 1 That is in List 2 No Double Count for Dups.flv	6.2 MB
689 Fill Column With 1 to 1000 Two Methods 1) Series & 2) GoTo.flv	6.2 MB
499 Does Cell Have Number or Text Formula Solution.flv	6.2 MB
751 Freeze Panes for Large Workbooks Freeze either a Row. Column. or Both.flv	6.1 MB
513 Equivalent Earnings Simple Formula.flv	6.0 MB
020 Lightening Fast Copy Trick!.flv	6.0 MB
004 SUM function Keyboard Trick.flv	6.0 MB
229 Dump Data Pivot Table Macro.flv	6.0 MB
396 COUNTIF function and Multiplying.flv	5.9 MB
091 FORECAST function.flv	5.9 MB
385 Generate Random Letters without RANDBETWEEN function.flv	5.8 MB
448 OFFSET Function to Avoid #REF! Error.flv	5.8 MB
749 Add Yearly Totals From Daily Date Data without SUMIF Function.flv	5.8 MB
426 VLOOKUP to Assign Category to A Sales Number.flv	5.7 MB
375 Keyboard Shortcut for Copying Columns.flv	5.7 MB
658 COUNT vs COUNTA function.flv	5.6 MB
632 Count Dates Within Given Year From A List of Dates With Different Years.flv	5.6 MB
641 Create PivotChart in 1 click #(Great Keyboard Shortcut for Charts).flv	5.6 MB
281 Formula for Vest Date.flv	5.5 MB
560 Conditional Formatting Select OK. Column Numbers Get Font White.flv	5.5 MB
093 Gantt Cell Chart Conditional Formatti.flv	5.5 MB
096 EXACT function.flv	5.5 MB
660 Advanced Filter Unique Records Only.flv	5.5 MB
418 Reference Every Third Value.flv	5.4 MB
226 Apply Names to Formulas.flv	5.4 MB
567 Collapsible Expandable Cell Ranges.flv	5.3 MB
525 Advanced Filter With Wild Cards.flv	5.3 MB
384 Keyboard Shortcut to Highlight 1000 Cells.flv	5.3 MB
563 WORKDAY.INTL & WORKDAY Excel 2010 Functions.flv	5.3 MB
491 Count Matches in Individual Cells.flv	5.2 MB
474 Conditional Format at Every Change in Value.flv	4.9 MB
656 Excel Will Talk to You.flv	4.9 MB
579 MOD function and Date Math Each Successive Date is Repeated Twice.flv	4.9 MB
603 Why 1001.1 = 110 Means Increase by 10%.flv	4.8 MB
408 VLOOKUP MIN Value.flv	4.8 MB
643 IF Function to Pull Data From A Different Column.flv	4.7 MB
222 Find and Count Longest Word Text.flv	4.6 MB
437 NETWORKDAYS Function for Counting Workdays.flv	4.5 MB
138 Names Cell If Name in Cell.flv	4.4 MB
739 Three Ways to Do Double Underline in Excel.flv	4.4 MB
428 Trouble Entering Dates - Date Syntax.flv	4.4 MB
705 Keyboard Shortcut for Finding Formula Dependents and Precedents.flv	4.3 MB
380 Negative Numbers Round to Nearest 5.flv	4.1 MB
630 Drag Formula Without Dragging Keyboard Shortcuts Through Huge Range.flv	4.1 MB
570 Remove Duplicate Records Excel 2007 2010 Feature.flv	4.1 MB
391 Custom Number Format to Insert Symbol Automatically.flv	4.0 MB
123 Date Data Validation.flv	4.0 MB
477 13 Digit Number ID Shows Scientific Notation!.flv	4.0 MB
716 Max of Absolute Values MAX & ABS functions Array Formula.flv	3.9 MB
389 Ctrl + Period Keyboard Shortcut.flv	3.7 MB
201 Custom Number Format for Pro ID.flv	3.7 MB
475 SUMPRODUCT for Bank Deposit Calculation.flv	3.7 MB
523 Fill in Blanks With Custom Number Formatted Number.flv	3.7 MB
618 Keyboard Shortcut for Date And Time in Same Cell.flv	3.6 MB
543 Build Time Schedule With 15 Minute Intervals.flv	3.6 MB
669 AGGREGATE function Can Not Handle 3-D Cell References.flv	3.4 MB
681 Find Smallest Number That is Greater Than Zero Array Formula.flv	3.4 MB
456 Add Only Integer Part SUM & INT functions.flv	3.3 MB
503 Custom Number Format for Turnover Ratio.flv	3.3 MB
406 Add 1 Extra for Each Deposit.flv	3.2 MB
444 Multiply Column Times Row With TRANSPOSE Function.flv	3.1 MB
367 Any Number Not Zero = TRUE.flv	3.0 MB
178 Best Value Per 1 Unit of Stats Value.flv	2.9 MB
280 Calculate the Year You Retire.flv	2.6 MB
/.../Slaying Excel Dragons/
2 Excel 2010 Keyboard Shortcuts are Fast!.flv	49.6 MB
3 Raw Data into Information SUMIFS. PivotTable & Verifying Formulas & Data.flv	45.2 MB
4 Table Format Structure for Raw Data.flv	16.6 MB
1 How Excel 2010 is Set Up. Customize Ribbon and Toolbar.flv	15.6 MB
Slaying Excel Dragons Book is Out in Print! Also Cool Excel MONTH Function Trick.flv	13.0 MB
/.../YouTubers Love Excel series/
130 Income Statement from Excel Table Array For.flv	44.3 MB
017 Hide Bank Rec Formula.flv	38.0 MB
126 VLOOKUP & INDIRECT & COLUMN functions.flv	37.2 MB
021 Solver for Linear Algebra.flv	36.9 MB
125 Array Formula w IF & AVERAGE functions.flv	36.8 MB
088 Macro to Remove Rows. Absolute.flv	36.4 MB
089 Relative & Absolute Macro together.flv	36.4 MB
046 VLOOKUP & Previous Bracket Trick.flv	36.3 MB
064 D Function DAVERAGE DSUM & more.flv	35.2 MB
028 Complex & Amazing Excel Trick.flv	35.2 MB
095-1 Complex Advanced Filter Extract.flv	34.9 MB
063.5 Range of Array Formulas.flv	34.7 MB
070 PivotTable & TRIM function & AVERAGES.flv	34.1 MB
083 Two or Fewer Decimals Only into the Cell.flv	33.5 MB
031 Dates. Cash Flow & Logic.flv	33.4 MB
071 Randomize Math Problems for Kids. Excel.flv	33.2 MB
106 Alternatives to Pivot Tables - Excel.flv	32.2 MB
077 INDEX INDIRECT MATCH functions for Payroll.flv	32.0 MB
117 Select Sample Data from List.flv	31.9 MB
050 Macro & Form Button.flv	31.5 MB
116 Edit Recorded Macro.flv	30.6 MB
080 Conditional Format MATCH & INSUMBER functions.flv	30.5 MB
105 Excel OFFSET for Dynamic Range in Function.flv	30.3 MB
100 Array Formula Database Customer Evaluation.flv	30.3 MB
067 VLOOKUP & DGET functions.flv	30.0 MB
012 Pivot Table AVERAGEIF SUMIFCOUNTIF.flv	29.6 MB
065 Merge 2 Tables VLOOKUP & Advanced Filter.flv	28.9 MB
084 A Few Data Validation Tricks.flv	28.8 MB
011 Pivot Table SUMPRODUCT & SUMIFS.flv	28.0 MB
098 Excel ADDRESS function.flv	27.6 MB
032 Delete Unique Records MATCH & ROW.flv	27.0 MB
081 Conditional Format CHART.flv	27.0 MB
039 Formula for Sheet Name.flv	26.7 MB
048 VLOOKUP for TIME.flv	26.3 MB
052 VLOOKUP & Workbook References.flv	26.3 MB
066.5 3 ways to Hide Formula Errors.flv	25.6 MB
025 Dynamic Range for Pivot Table & Chart.flv	25.2 MB
090 Formula Average w MONTH criteria.flv	24.5 MB
094 Excel's Best Keyboard Shortcut.flv	23.9 MB
107 Excel Time Across 2 Days Trouble.flv	23.5 MB
121 CHAR & CODE & MID functions.flv	23.0 MB
118 Form Controls Linked to Cells.flv	22.8 MB
119 Amazing Lookup Solution!.flv	22.3 MB
076 Data Analysis & INDIRECT function.flv	22.3 MB
104 Find 1st Positive# in Excel List.flv	22.1 MB
051 VLOOKUP & Variable Labels.flv	21.7 MB
013 Date Math and IF function.flv	21.3 MB
027 Data Validation From Different Sheet.flv	21.0 MB
102 Count Dates given 2 Criteria - Excel.flv	20.9 MB
089 part 2 VBA Code for Relative & Absolute Macro.flv	20.8 MB
120 Formula to Wrap Text.flv	20.8 MB
079 Formula for Running Total (Inventory).flv	20.8 MB
047 VLOOKUP & 2 Cost Formulas.flv	20.7 MB
128 Set Default Chart.flv	20.4 MB
023 Add Time with Formula or Format.flv	20.4 MB
049 Data Forms.flv	20.0 MB
124 Pivot Table Bowling Average.flv	19.9 MB
020 Variable Growth Cash Flow Formula.flv	19.4 MB
101 Custom Number & Conditional Formatting - Excel.flv	19.2 MB
018 Logical Formula to Verify Patterns.flv	19.1 MB
035 IF AND vs VLOOKUP.flv	18.8 MB
074 CLEAN & TRIM functions to fix Bad Data.flv	18.5 MB
122 Advanced Filter to a New Sheet (Formula Criteria).flv	18.4 MB
022 EOM Terms with IF. DAY & EOMONTH fun.flv	18.0 MB
029 Conditional Formatting & LEFT function.flv	18.0 MB
086 Pivot Table Filtering & Functions.flv	18.0 MB
056 Excel Count Unique Values Greater Than $30.flv	17.8 MB
091 PivotTable Average w MONTH criteria.flv	17.7 MB
063 Array Formula Vendor Max Rating Min Cost.flv	17.6 MB
069 Auto Fill Options (Dates are the Best!!).flv	17.5 MB
123 Array Formula to Count E-mails.flv	16.7 MB
045 SUMPRODUCT & TEXT functions.flv	16.6 MB
129 Zip Code. VLOOKUP & TEXT functions.flv	16.1 MB
085 Isolate Unique Records w OR function.flv	15.9 MB
126 part 3 Conditional Formatting w Formulas.flv	15.9 MB
016 Percent Number Formatting Tricks.flv	15.5 MB
097 5 Ways to Enter Formula in Excel.flv	15.5 MB
059 Pivot Table for Age Account Receivable.flv	15.5 MB
075 DV Drop-Down based on DV Drop-Down.flv	15.4 MB
108 Excel Number of Days in Year.flv	15.0 MB
040 Extract top 5 scores.flv	15.0 MB
111 Excel AVERAGE w Multiple Criteria.flv	14.8 MB
082 Enter UPPER Case Text Only into the Cell.flv	14.6 MB
043 Data Validation & Conditional Format.flv	14.4 MB
044 Convert Formula Text to Number.flv	14.1 MB
114 Copy Table & Name to New Workbook.flv	14.0 MB
087 Remove Rows w Blanks Go to Trick.flv	13.5 MB
014 NOT function for logic formulas.flv	13.4 MB
019 Steady Growth Cash Flow Formula.flv	13.2 MB
068 3 Ways to Use Fill Handle for Copying.flv	13.2 MB
037 Formula Input Efficiency.flv	13.1 MB
103 Excel Goal Seek.flv	12.9 MB
026 Text to Column Trouble.flv	12.8 MB
034 Hide Columns Copy Problem.flv	12.7 MB
026.2 Formulas do not like TEXT Time.flv	12.7 MB
115 Time Delayed Formula TODAY & IF functions.flv	12.5 MB
062 VLOOKUP INDIRECT & Lookup in Different Tables.flv	12.1 MB
053 Excel Pivot Table and COUNTIF function.flv	11.8 MB
113 VLOOKUP RIGHT 5 characters only.flv	11.7 MB
093 Go to Special Blanks Caveat.flv	11.6 MB
112 VLOOKUP Problem (Sort Ascending).flv	11.5 MB
110 Excel Forms Scroll Bar Linked to Cell.flv	11.4 MB
096 Names. Printing. AREAS function.flv	11.3 MB
058 Data Validation & Excel 2007 Tables.flv	11.1 MB
126 part 2 VLOOKUP & INDIRECT & ROW.flv	11.1 MB
054 Excel Advanced Filter and COUNTIF function.flv	10.8 MB
109 Daily Interest RATE Schedule in Excel.flv	10.8 MB
041 Prevent Duplicates COUNTIF Data Valid.flv	10.8 MB
066 VLOOKUP replaces IF. Again!.flv	10.6 MB
030 Keyboard Shortcut Tricks.flv	10.6 MB
024 Add Time by Hour. Minute or Day.flv	10.4 MB
095-2 Identifying Customers in Database.flv	9.5 MB
099 the Number e in Excel.flv	9.4 MB
072 Turn Off Auto Format.flv	9.2 MB
078 Conditional Format for Entire Table.flv	9.0 MB
055 Excel 2007 Remove Duplicates and COUNTIF function.flv	8.6 MB
042 Format Negative Numbers.flv	8.6 MB
033 Extract Red Cells.flv	8.4 MB
073 Custom Number Format 00000.flv	8.1 MB
127 AVERAGE When Hurdle Met.flv	8.0 MB
057 NPER function and Infinity.flv	7.0 MB
092 AVERAGE function sees Zeroes but not Blanks!.flv	7.0 MB
036 VLOOKUP increase based on Rating.flv	6.7 MB
015 Mixed Number formulas and Format.flv	6.3 MB
060 Hide Columns by Grouping.flv	6.2 MB
/Excel/
Excel Cell References 15 Examples Formulas. Conditional Formatting & Data Validation.flv	132.7 MB
Plot F(x) Function & Chart in Excel - Gregory's Physics Class Acceleration of Block Up Down Ramp.flv	54.6 MB
The Beauty of Excel #2 Formulas. Functions & Charts.flv	35.0 MB
The Beauty of Excel #1 Formulas & Functions.flv	35.0 MB
Insert Magibon Mririan into Speardsheet!.flv	5.9 MB
Excel.flv	3.8 MB
What is Art What is Excel.flv	394.7 KB
/.../Office 2010 Class/
18 Excel Intro Project 01 Data. Formatting. Formulas. Page Setup.flv	106.6 MB
41 Introduction to Databases and Access.flv	80.8 MB
09 Word Research Paper Tricks Footnotes. Citations. Bibliographies. Styles. Find.flv	78.5 MB
05 Word Formatting. Insert Picture. Navigation. Selection Tricks. Backup Files.flv	77.2 MB
04 Introduction to Word. Ribbons. QAT. Non-Printing Characters. Clipboard & More.flv	76.0 MB
17 How to PowerPoint Tricks.flv	73.1 MB
33 Excel Charts Column. Bar. Pie. Line. X-Y Scatter. Sparklines Formatting.flv	73.0 MB
25 Excel Cell References Relative. Absolute. Mixed.flv	72.9 MB
42 Access Create Database. Import Table. Create Table. Data Validation for Table.flv	70.5 MB
35 Excel Sort and Filter (Data Analysis).flv	69.0 MB
45 Creating Queries in Access (16 Examples).flv	65.9 MB
36 Excel PivotTables Pivot Tables 15 examples (Data Analysis).flv	65.4 MB
21 Excel Formulas & Functions Formula Inputs Numbers or Cell References.flv	64.2 MB
26 Excel Assumption Tables (Formula Inputs) & Cell Ranges in Functions.flv	55.3 MB
23 Excel Functions & Defined Names. SUM. COUNT. COUNTA. SUMIF. COUNTIF.flv	54.2 MB
19 Excel Intro Project 02 Formulas. Charts. Page Setup Net Income.flv	52.4 MB
15 Word Business Letter & Letterhead.flv	51.1 MB
28 Excel Number Formatting Formatting As Facade.flv	48.6 MB
08 Word Three Levels of Formatting Character. Paragraph. Section.flv	46.0 MB
16 Word Style Tricks Send Word to PowerPoint & Table of Contents.flv	41.8 MB
20 What is Excel. Editing Ribbons & Quick Access Toolbar. File Extensions.flv	41.7 MB
24 Excel Functions COUNTIF & SUMIF Count and Add with one Condition (Criteria).flv	39.3 MB
39 Excel VLOOKUP Function Formula Made Easy (3 Examples).flv	37.5 MB
10 Word Tables & Paste Special Link Excel Table into Word Document.flv	34.5 MB
01 Windows Explorer and Introduction to Office 2010.flv	34.5 MB
03 Creating System of Folders for File Management Using Windows Explorer.flv	32.9 MB
07 Spell Check. Custom Dictionary -- Auto Correct for Spelling and Shorthand.flv	31.0 MB
29 Excel ROUND Function How And When to Use It.flv	30.3 MB
27 Excel Stylistic Formatting & Page Setup for Reports.flv	28.5 MB
02 Using Windows Explorer for File Management.flv	28.4 MB
38 Excel IF Function Formula Made Easy (7 examples).flv	27.7 MB
06 Word Hyperlinks and Save As Web Page.flv	27.0 MB
31 Excel Time Number Format & Payroll Time Sheet Calculations.flv	25.4 MB
46 Access Create Report Based On A Query.flv	23.4 MB
22 Excel Formulas Math Operators and Order of Operations.flv	21.4 MB
34 How Data Must Be Setup to Use Excel Data Analysis Features.flv	19.3 MB
32 Excel Percentage Number Format (6 Examples).flv	15.8 MB
11 Word Tabs Left. Right. Center. Decimal. Bar.flv	13.7 MB
12 Word Objects & Word Wrap.flv	13.6 MB
44 Access Create Forms (User Interface). Enter Data Tricks.flv	13.2 MB
37 Excel Table Feature for Dynamic Ranges in Functions. Charts. PivotTables.flv	12.9 MB
47 Export Data From Access to Excel. PDF or Text File.flv	12.8 MB
43 Access One to Many Relationship Between Tables.flv	11.4 MB
30 Excel Date Formulas Days Invoice Past Due. Loan Maturity Date. Project Days.flv	8.4 MB
13 Word Theme affects Shapes. Tables. Smart Art. Numbered Lists and Styles.flv	7.8 MB
14 Word Print Preview and Print Dialog Box are the Same.flv	5.7 MB
40 Excel SUM Function Keyboard Shortcut for 5000 Rows of Data.flv	4.8 MB
/
ExcelIsFun Search & Find Excel Videos. Playlists. Download Excel Workbooks and more.flv	18.1 MB
How to Post Questions at the Mr Excel Message Board.flv	11.8 MB
Promotion Bill Mr Excel Jelen is Here at YouTube.flv	5.0 MB
Total files 901