Excel is Fun | 9522D1FF618C09CD442DB3D314FBD05578656A27

Excel is Fun

Name	Excel is Fun! 1	DOWNLOAD Copy Link
Total Size	14.4 GB
Total Files	518
Hash	9522D1FF618C09CD442DB3D314FBD05578656A27

/Excel/1 Basics/
02 Keyboard Shortcuts.flv	31.3 MB
20 Data Analysis Pivot Tables PivotTables.flv	25.9 MB
22 IF function formula made easy!.flv	24.4 MB
17 Page Setup.flv	22.3 MB
21 Data Analysis Filter &Dynamic Ranges.flv	21.6 MB
11 Spreadsheet Setup & Cell References.flv	21.1 MB
15 Date & Time Format & Calculations.flv	21.0 MB
16 Chart Basics - Excel Charts.flv	20.2 MB
19 Data Analysis Subtotals.flv	20.0 MB
18 Data Analysis Sort.flv	19.8 MB
01 What is Excel.flv	19.6 MB
06 Names Cell Ranges and Functions.flv	19.4 MB
08 Cell References Relative & Absolute.flv	18.4 MB
12 Stylistic & Number Formatting.flv	18.1 MB
23 VLOOKUP function formula.flv	17.8 MB
09 Mixed Cell References in Formulas.flv	17.6 MB
05 Formulas Operators and Math.flv	17.5 MB
14 ROUND function & Number Formatting.flv	16.9 MB
04 Formulas and Functions.flv	15.9 MB
03 Formulas w Cell References.flv	15.8 MB
13 Percentage Number Format.flv	13.6 MB
10 Formulas Copy vs Cut.flv	10.2 MB
07 Range Functions.flv	9.4 MB
/.../2 Highline Excel Class/
45 INDEX function & MATCH function 12 Unusual Examples.flv	104.9 MB
40 VLOOKUP 11 Unusual Examples.flv	89.5 MB
20 Pivot Tables 20 Examples.flv	83.4 MB
36 Array Formulas Basics.flv	80.5 MB
19 Advanced Filter Extract Data 9 Examples.flv	78.2 MB
11 Logical formulas. IS & IF functions.flv	76.8 MB
28 More Excel Basics Review.flv	71.6 MB
42 Versatile LOOKUP function 10 Examples.flv	68.3 MB
27 Custom Number Format & TEXT function.flv	68.1 MB
03 Names. Cell References. Formula Inputs.flv	67.3 MB
33 IF AND OR Customer Credit Analysis.flv	64.2 MB
53 Relative & Absolute Macro Recorder.flv	63.3 MB
05 Charts. Page Setup. Data Analysis.flv	61.0 MB
52-1 Recorded Macro Basics.flv	60.5 MB
21 Conditional Formatting 12 Examples.flv	59.6 MB
13 Text functions & AMPERSAND.flv	57.9 MB
39 Forcing Functions to Become Arrays.flv	57.3 MB
37 SUMPRODUCT function.flv	56.5 MB
07 VLOOKUP function formula 7 Examples.flv	54.9 MB
44 Basics of INDEX & MATCH functions.flv	54.9 MB
23 Import Different Types of Data.flv	54.1 MB
32 More Charts & SUMIFS & AVERAGEIFS.flv	53.2 MB
02 Excel Formulas & Excel Functions.flv	52.5 MB
29 Basic Statistics Numerical Measures.flv	50.2 MB
31 Histogram & LARGE SMALL functions.flv	47.8 MB
48 Interest Rates 6 Examples.flv	45.8 MB
30 SUMIF. RANK & Bonuses.flv	40.1 MB
47 PMT function 5 Examples.flv	39.5 MB
22 Budgets. Scenarios & Scenarios Report.flv	35.9 MB
49 Spreadsheet to Compare Loans.flv	35.6 MB
26 Fixing Other Peoples Spreadsheets.flv	35.2 MB
54 Excel VBA code From Internet.flv	34.3 MB
04 Style & Number Format & ROUND.flv	32.9 MB
24 Order of Precedents.flv	32.7 MB
16 Sort. Sorting 10 Examples.flv	32.2 MB
50 Value Asset PV NPV & XNPV function.flv	32.2 MB
10 VLOOKUP SUMIF & Percentage Increase.flv	31.6 MB
18 Subtotals.flv	31.3 MB
25 Fix Problems & Errors in Spreadsheet.flv	31.2 MB
15 Excel 2007 Tables 7 Examples.flv	29.9 MB
17 Filter. Filtering 8 Examples.flv	27.9 MB
46 CHOOSE function 4 Examples.flv	27.7 MB
01 Back to Basics.flv	27.7 MB
51 Life Time Savings Plan.flv	27.2 MB
34 IF function Formula Payroll Formula.flv	26.8 MB
09 SUMIF Function Formula 3 Examples.flv	26.5 MB
06 Worksheet & Workbook References.flv	25.6 MB
12 DATE functions & Formulas.flv	23.4 MB
35 IF Function vs VLOOKUP Function.flv	20.9 MB
43 MATCH function.flv	18.3 MB
14 How to Setup Data in Excel.flv	17.8 MB
38 Array Functions TRANSPOSE FREQUENCY.flv	16.4 MB
08 3-D Cell References Add Across Sheets.flv	14.6 MB
52-2 Macro Security.flv	7.1 MB
41 HLOOKUP ROWS Horizontal Lookup.flv	5.7 MB
/.../Array Formula series/
13 LINEST function.flv	35.9 MB
14-3 Portfolio Standard Deviation.flv	35.6 MB
14-2 Beginning Stock Analysis.flv	35.3 MB
07 Boolean Logic & Criteria.flv	34.7 MB
01 Basics of Array Formulas.flv	28.7 MB
14-1 Stock Returns.flv	23.7 MB
08 FREQUENCY function.flv	19.1 MB
10 Amazing Syntax Array Trick.flv	17.8 MB
14-4 Stock Portfolio Analysis.flv	17.0 MB
11 ROW & COLUMN functions.flv	16.8 MB
06 Statistics Bayes' Theorem.flv	13.6 MB
03 Expected Return for Stocks.flv	12.5 MB
04 Find Largest Improvement.flv	10.7 MB
05 SUM 3 Largest Values.flv	9.2 MB
12 MMULT function Matrix Algebra.flv	8.0 MB
02 TRANSPOSE function.flv	7.6 MB
09 Count Characters in Range.flv	6.3 MB
/.../Business Math series/
39 Incentive Rate Formulas 8 Examples.flv	99.4 MB
38 Gross Pay and Overtime 5 Examples.flv	91.2 MB
56 Compound Interest & Future Value.flv	81.6 MB
53 Simple Interest & Loans Notes.flv	80.3 MB
46 Cash Discounts.flv	76.3 MB
61 Present Value Annuities PV & PMT function.flv	75.6 MB
42 Federal Income Tax Payroll Deduction.flv	72.1 MB
44 Series Trade Discounts.flv	63.6 MB
43 Invoices & Trade Discounts.flv	57.9 MB
41 Payroll Deductions With Ceilings (FICA).flv	51.8 MB
59 Annuities Math & Excel.flv	49.8 MB
35 Check Accounts Service Charge & Balance.flv	49.4 MB
60 Future Value Annuities FV & PMT function.flv	46.7 MB
57 Future Value Calculations.flv	46.3 MB
36 Bank Service Terms & Credit Card Calculations.flv	45.3 MB
62 Sinking Funds.flv	40.4 MB
16 Fractions & Fraction Formatting.flv	39.7 MB
48 Basics of Markup (Cost & Selling).flv	37.8 MB
20 Adding & Subtracting Fractions.flv	37.6 MB
37 Bank Reconciliation.flv	37.2 MB
31 Increase & Decrease Math Problems.flv	36.8 MB
12 Multiplying & Dividing in Excel.flv	36.8 MB
34 Bank Checks.flv	36.3 MB
13 Math Word Problems #1.flv	33.0 MB
49 Markup On Cost.flv	31.2 MB
08 Whole. Decimal Numbers & Formatting.flv	28.5 MB
50 Markup On Selling Price.flv	28.3 MB
10 Adding and Subtracting.flv	28.1 MB
09 ROUNDING Numbers in Excel.flv	28.1 MB
55 Simple Interest Discount Note.flv	28.0 MB
15 Large Math Word Problem.flv	27.4 MB
22 Convert Decimals & Fractions to Percent.flv	27.0 MB
05 Functions & Formulas.flv	26.8 MB
02 Formulas and Math Operators.flv	26.8 MB
29 Rate of Change Formulas.flv	26.8 MB
58 Present Value Calculations.flv	26.6 MB
30 Rate of Change Business Problems.flv	26.1 MB
51 Convert Markups & Perishable Sell Price.flv	25.3 MB
28 Solve for Rate in Percent Formula.flv	24.5 MB
04 the Importance of Formatting in Math.flv	23.5 MB
25 Part = Rate Base = Percent Formula.flv	22.6 MB
21 Fraction Word Problem.flv	22.4 MB
01 What is Excel.flv	21.7 MB
33 Stock Values Web Query & Rate of Change.flv	21.3 MB
18 Decimal into Fraction.flv	20.2 MB
40 Equivalent Earning Formulas 12 Examples.flv	19.6 MB
03 Math Order of Operations.flv	19.1 MB
26 Solve for Part in Percent Formula.flv	18.8 MB
14 Math Word Problems #2.flv	18.3 MB
27 Solve for Base in Percent Formula.flv	18.0 MB
32 Markup & Markdown Math Problems.flv	17.1 MB
24 Fraction and Percent Equivalents.flv	16.7 MB
52 Markup & Markdown.flv	16.0 MB
54 Simple Interest Part & Base & Rate.flv	15.9 MB
19 Multiplying & Dividing Fractions.flv	15.1 MB
17 Primes & Reducing Fractions.flv	14.8 MB
11 Order of Operations for Math.flv	14.7 MB
23 Rules for Percents in Excel - Percentage.flv	12.9 MB
07 When ROUND function is Required.flv	11.5 MB
45 Trade Discount Word Problem.flv	9.5 MB
47 Partial Invoice Payment w Discount.flv	9.0 MB
06 Relative & Absolute Cell References.flv	8.1 MB
/Excel/Dynamic Charts/
10 OFFSET Function Dynamic Range.flv	36.3 MB
09 4 Week Chart Dynamic Formula & Dynamic Data Validation Formula.flv	29.7 MB
11 Dynamic Area Chart with IF Function - Normal Distribution Chart Statistics.flv	21.6 MB
07 SUMIFS function.flv	21.0 MB
12 INDEX function as Alternative to OFFSET function for Dynamic Ranges.flv	20.1 MB
15 Array Formula & Table Nomenclature for Top 10 Wrestling Score Chart.flv	19.3 MB
16 Dynamic Average Hurdle Line for Bar Chart. Scatter and Bar Chart Together.flv	18.7 MB
04 Advanced Filter.flv	16.2 MB
14 Progress Chart Linked to Stock Market (Stock Prices vs Target Sell Price).flv	12.8 MB
05 Dynamic Chart Labels using TEXT function and Ampersand &.flv	12.2 MB
06 PivotTable PivotChart.flv	12.0 MB
13 Web Query Stock Percent of Target Chart.flv	11.7 MB
03 Table Feature (Excel 2010, 2007) List Feature (Excel 2003).flv	9.9 MB
02 Filter & Sort Feature.flv	9.7 MB
01 Hide-Unhide Rows.flv	8.7 MB
08 SUMPRODUCT function (Excel 2003 substitute for SUMIFS).flv	6.3 MB
/.../Excel 2010 Preview/
8 Five New T-Distribution Functions that Replace TINV & TDIST.flv	21.6 MB
6 Normal Distribution Statistic Functions NORM.DIST & NORM.S.DIST.flv	8.2 MB
3 New Percentile Function PERCENTILE.EXC.flv	8.0 MB
4 Pivot Table Slicer (ReportPage Filter Slicer).flv	7.5 MB
5 Conditional Formatting Negative Data Bars.flv	6.5 MB
7 Confidence Intervals for T-Distribution CONFIDENCE.T function.flv	6.4 MB
2 Copy & Paste Special Magic.flv	6.4 MB
1 New Rank Function RANK.AVE.flv	5.3 MB
/Excel/Finance Class/
008 Intro to Corporate Financial Management.flv	97.7 MB
011 Finance Cash Flow From Accounting Information.flv	88.9 MB
014 Financial Statement Ratio Analysis - #1 Trick for Ratio Analysis.flv	72.4 MB
009 Balance Sheet. Working Capital. Liquidity. Debt. Equity. Market Value.flv	70.9 MB
021 Future Value Lump Sum Calculations. Simple & Compound Interest.flv	66.1 MB
046 Bonds Just A Set of Cash Flows Discounted at Market Rate - Coupon or Zero.flv	65.9 MB
086 Estimating Cash Flows for NPV calculation Comprehensive Example.flv	55.1 MB
003 Math Operators and Order of Operations.flv	54.4 MB
099 US Capital Market History 5 Types Investments (2 Good Lessons).flv	52.7 MB
073 Investment Criteria Internal Rate of Return IRR Function Plot Chart.flv	52.5 MB
002 Getting Started with Formulas. Functions. Formula Inputs and Cell References.flv	52.4 MB
010 Income Statement. Non Cash Depreciation Expense. Matching Principal.flv	49.2 MB
017 Leverage & Solvency Ratios Debt to Equity. Equity Multiplier. more.flv	48.4 MB
069 Net Present Value Profile -- Build Table and Chart in Excel NPV Function.flv	46.6 MB
026 Multiple Cash Flow Valuation Future Value and Present Value FV PV Functions.flv	44.0 MB
018-1 Asset Efficiency Ratio and Cash Cycle in Days.flv	43.5 MB
028 Relationship Between APR. Period Rate and Effective Annual Rate.flv	42.4 MB
082 Relevant Costs for Discounted Cash Flow Analysis = Incremental Cash Flows.flv	41.9 MB
036 PMT Function 7 Examples & Adjusted APR with Points and RATE function.flv	40.8 MB
059 Common & Preferred Stock.flv	40.8 MB
068 Net Present Value. NPV Excel Function & Capital Budgeting.flv	39.5 MB
045 Interest Rates Real. Nominal. Inflation and the Fisher Effect.flv	38.9 MB
060 Basics of Financial Markets.flv	38.8 MB
029 Calculate Future Value of An Annuity (FV Function).flv	38.0 MB
022 Present Value Lump Sum Calculations and PV Function.flv	37.6 MB
088 Scenario Analysis for Cash Flow & NPV Calculations.flv	37.1 MB
019 Profitablility Rations Return On Equity & Return On Assets & DuPont Analysis.flv	36.7 MB
016 Liquidity. Current Ratio and How Current Ratio Can Be Manipulated.flv	36.2 MB
083 Estimating Cash Flows for NPV calculation.flv	35.9 MB
096 Comparing Geometric Mean with Arithmetic Mean for Average Stock Returns.flv	35.7 MB
081 XNPV Function XIRR Function - See Algorithm That XNPV uses.flv	34.1 MB
001 Intro to Excel 2007 & 2010.flv	33.9 MB
004 the Importance of Number Formatting in Financial Calculations.flv	33.2 MB
012 Cash Flow Advantage to Debt & Average and Marginal Tax Rates.flv	32.8 MB
015 Common Sized Financial Statements.flv	32.3 MB
020 Growth Ratios and Market Value Ratios.flv	31.6 MB
106 Unexpected Information. Market & Asset Specific Risk. Diversification. Beta.flv	31.4 MB
067 Irregular Dividend Payments. Followed by Constant Growth -- Stock Valuation.flv	30.7 MB
057 Compare Cash Flows for a Coupon & A Zero Coupon Bond.flv	28.6 MB
107 Calculating Beta (2 Methods) & Chart Beta. SLOPE CORREL & STDEV functions.flv	28.4 MB
089 Sensitivity Analysis for Cash Flow & NPV Calculations.flv	28.2 MB
005 Percent. Percent Change Increase Decrease Percentage Number Formatting.flv	27.2 MB
024 Solve for Period Rate & Annual Rate When You Know PV. FV and # of Periods.flv	27.1 MB
098 Stock Return Variation Measured with Standard Deviation (Risk of Stock).flv	26.6 MB
104 Expected Return & Standard Deviation for 1 Stock -- Estimating Future.flv	26.5 MB
085 MACRS Depreciation & Asset Sale Impacts on NPV Cash Flows.flv	25.2 MB
075 IRR and Mutually Exclusive Projects - Plot Chart to See Cross 0Over Rate.flv	24.6 MB
105 Expected Return & Standard Deviation for Portfolio -- Estimating Future.flv	24.5 MB
071 Investment Criteria Payback Rule.flv	24.2 MB
054 Bonds & Interest Rate Risk.flv	23.9 MB
032 Calculate Present Value of Annuity (PV Function).flv	22.7 MB
033 Full Life Retirement Plan PV Annuity & FV Annuity PV & PMT Functions.flv	22.4 MB
072 Investment Criteria Average Accounting Return.flv	21.7 MB
006 Relative and Absolute Cell References in Copied Formulas.flv	21.4 MB
051 Par - Discount - Premium Bonds.flv	21.4 MB
018-2 Ratios for Cash Cycle in Days.flv	20.4 MB
076 Investment Criteria MIRR - Modified Internal Rate of Return.flv	20.2 MB
053 Bond Discount or Premium Journal Entries.flv	19.7 MB
061 Stock Value Based on Present Value of Future Dividend Cash Flows.flv	19.3 MB
110 Security Market Line (SML) & Capital Asset Pricing Model (CAPM).flv	19.3 MB
042 Consumer Amortized Loans.flv	19.1 MB
056 Tax Implications for Zero Coupon Bonds.flv	19.0 MB
079 Investment Criteria NPV. IRR. Payback. AAR. Profitability Index.flv	18.7 MB
064 Chart How Stock Value Changes for Dividend Growth Model as Inputs Change.flv	18.6 MB
047 Selling Bond When Coupon Rate is Different Than Discount Rate (YTM Rate).flv	18.3 MB
087 Cost Savings Example Estimating Cash Flows for NPV calculation.flv	17.9 MB
084 Undoing Accrual Accounting to Discover Cash Flows for Estimating NPV.flv	17.3 MB
074 IRR and Non-conventional Cash Flows. Plot Chart to See Multiple IRR.flv	17.1 MB
080 Recognizing Patterns of Cash Flows for Discounted Cash Flow Analysis.flv	17.0 MB
050 Bond Rates are Inversely Related to Bond Price (Scatter Diagram Excel Chart).flv	16.5 MB
027 Asset Valuation Using Discounted Cash Flow Analysis and PV Function.flv	16.3 MB
078 NPV for Irregular Cash Flows and Time Periods XNPV. NPV and PV functions.flv	15.7 MB
031 Calculate PMT for Future Value of Annuity (PMT Function).flv	15.6 MB
052 Bond Discount or Premium Amortization Table.flv	14.9 MB
058 After Tax Cash Flows & After Tax Interest Rates.flv	14.4 MB
030 Future Value for Interest Paid Daily. But Deposits Made Monthly.flv	13.9 MB
065 Calculate Stock Price at Time t using Dividend Growth Model.flv	13.8 MB
108 Reward to Risk Ratio - Treynor Index.flv	13.7 MB
090 Period (Holding) Returns for Stock.flv	13.7 MB
013 Banks. Fundamental Problem With Banks. & the Big Short.flv	13.6 MB
102 in the Short Run Financial Markets Can Be Inefficient Mispriced Assets.flv	13.0 MB
044 Deep Discount Loans.flv	12.9 MB
103 2 Ways to Calculate Geometric Mean.flv	12.1 MB
023 Solve for Total Number of Periods When You Know PV. FV and Period Rate.flv	12.0 MB
049 Bond Quoted Price & Yield to Market.flv	11.4 MB
063 Stock Valuation with Dividend Growth Model.flv	10.3 MB
094 Period (Holding) Returns for Less 0Than 1 Year. APR and EAR.flv	9.4 MB
091 Period (Holding) Nominal. Real & Dollar Returns for Coupon Bond.flv	9.4 MB
025 Future Value for Lender or Borrower.flv	9.1 MB
007 Stylistic Formatting.flv	8.6 MB
097 Using Geometric Mean & Arithmetic Mean to Estimate Future Returns.flv	8.3 MB
066 Calculate Implied Return using Dividend Growth Model.flv	8.3 MB
095 Using Past Period Holding Returns to Estimate Future Returns Arithmetic Mean.flv	8.2 MB
100 Real Rate and Inflation or Deflation for T-bills.flv	8.2 MB
109 Beta for Portfolio.flv	8.1 MB
092 Period (Holding) Returns for Zero Bond.flv	7.9 MB
037 How Much Do I Get Each Month During Retirement.flv	7.6 MB
048 Calculate YTM and Effective Annual Yield From Bond Cash Flows RATE & EFFECT.flv	7.6 MB
062 Preferred Stock Valuation as A Perpetuity.flv	7.5 MB
070 Investment Criteria Net Present Value.flv	7.3 MB
101 Average Real Return for A Stock Based On Historical Data.flv	7.3 MB
034 Present Value of Annuity for Asset Valuation.flv	7.3 MB
043 Business 0Amortized Loans.flv	7.1 MB
055 Tax Advantage of Muni Bond.flv	6.9 MB
111 Treynor Index & CAPM.flv	6.7 MB
040 Perpetuity (consol) Preferred Stock Valuation Formula.flv	6.6 MB
039 How Long to Pay Off Credit Card With Minimum Payment.flv	5.9 MB
077 Investment Criteria Profitability Index.flv	5.7 MB
035 Calculate PMT for Present Value of Annuity PMT Function for Loan Payment.flv	5.4 MB
093 Period (Holding) Returns for Preferred Stock.flv	5.3 MB
038 Calculate APR and EAR Given Cash Flows From Annuity.flv	4.8 MB
041 Interest Only Loan Schedule.flv	3.5 MB
/Excel/Finance Tricks/
02 Simple & Compound Interest.flv	37.9 MB
08 Complete Loan Analysis.flv	36.7 MB
17 Amortization Table w x Column.flv	36.6 MB
03 PMT function Lender or Borrower.flv	32.4 MB
16 Work Life & Retirement Finance.flv	29.7 MB
18 CUMIPMT function for Interest.flv	29.4 MB
05 PMT & FV function & Delayed Payments.flv	23.2 MB
10 Interest Rate for Pay Day Loans.flv	21.0 MB
15 PV & NPV don't work XNPV function.flv	20.3 MB
01 FV PV & Time Value of Money.flv	16.3 MB
09 Daily Interest But Monthly Deposits!.flv	15.1 MB
06 RATE function and Loan Points.flv	14.5 MB
13 PV function Capital Invest Decision.flv	12.6 MB
12 SLN & DDB Depreciation functions.flv	12.2 MB
14 NPV function Capital Invest Decision.flv	12.0 MB
04 PMT function & Balloon payment.flv	11.8 MB
11 How Long Pay Off Credit Card Balance.flv	11.1 MB
07 EFFECT function (EAR Rate).flv	8.2 MB
/Excel/Formula Efficiency/
03 Database D Functions are Fast.flv	31.7 MB
01 SUMPRODUCT function 12 Examples.flv	26.9 MB
04 SUMIFS & COUNTIFS are Fast.flv	23.1 MB
11 Pivot Table Faster Than Formula.flv	21.0 MB
06 Concatenated Field Speeds Up Formula.flv	20.4 MB
02 Time Your Formulas for Speed.flv	19.4 MB
07 Helper Column Speeds Calculation.flv	19.3 MB
12 Fastest Formula in Excel.flv	17.4 MB
05 Helper Cell Speed Up Calculation.flv	11.2 MB
08 Custom VBA Function Can Be Fast.flv	9.9 MB
10 Automatic & Manual Calculation.flv	8.9 MB
09 Faster Running Total Formula.flv	6.7 MB
/Excel/Law Class/
1 Create Comparative Budget - Jessica's Law Class.flv	99.2 MB
3 Statistics for Age Discrimination Case - Jessica's Law Class.flv	35.1 MB
2 Child Support Payments Template - Jessica's Law Class.flv	21.5 MB
/Excel/Lookup series/
13 INDEX & MATCH functions Example 3!.flv	38.6 MB
04 PART 1 VLOOKUP Function 4th Example.flv	32.6 MB
05 VLOOKUP Function 5th Example.flv	30.6 MB
01 VLOOKUP Function 1st Example.flv	27.5 MB
07 LOOKUP Function.flv	25.1 MB
02 VLOOKUP Function 2nd Example.flv	19.8 MB
04 PART 2 VLOOKUP Function 4th Example.flv	18.1 MB
12 INDEX & MATCH functions Example 2!.flv	17.0 MB
11 INDEX & MATCH functions Two 2 Way Lookup.flv	16.4 MB
08 MATCH Function.flv	14.5 MB
10 INDEX function 2nd Example.flv	14.0 MB
14 CHOOSE function.flv	13.5 MB
06 HLOOKUP Function.flv	13.3 MB
03 VLOOKUP Function 3rd Example.flv	12.5 MB
09 INDEX function 1st Example.flv	11.2 MB
/.../MrExcel & ExcelIsFun friendly challenge/
66 Slaying Excel Dragons E-Book Available at Mr Excel Web Site!.flv	42.5 MB
42 Lookup Picture in Excel Formula or VBA.flv	39.9 MB
41 VBA or Formula Extract Prefix for VLOOKUP.flv	38.8 MB
07 Reverse Lookup VBA or Formula.flv	37.4 MB
20 Summarize Survey Pivot Table.flv	36.3 MB
40 VLOOKUP to 3 Different Lookup Tables (3 table_arrays).flv	33.7 MB
31 Word Wrap Problem Formula or VBA solution.flv	33.7 MB
54 Approximate Lookup to Return Multiple Items.flv	32.5 MB
05 Horizontal Subtotals.flv	30.4 MB
08 Top 10 Filter Trouble.flv	30.2 MB
27 COUNT w More Than 1 Criteria 10 Examples!.flv	30.1 MB
25 Extract Records NOT Swim or Ski (Filter or Formula).flv	30.0 MB
04 Comparative Charts.flv	29.7 MB
22 Conditional Formatting VBA or OFFSET.flv	29.2 MB
36 VLOOKUP w Approximate Match & Unsorted Table.flv	29.0 MB
38 Weekly Report Formula or Pivot Table.flv	27.9 MB
14 Trending Up Down Arrows.flv	27.5 MB
33 First Monday for Reporting Period.flv	27.2 MB
30 Count Bills for Money Transaction.flv	26.7 MB
19 VLOOKUP to Left (MATCH & INDEX or LOOKUP).flv	26.1 MB
23 Excel 2010 New Functions.flv	25.7 MB
32 Three Methods for 2-Way Look.flv	25.2 MB
53 Extract State When Text String Has Varying Number of Commas.flv	24.8 MB
58 Sorting Formula for Biggest Sales and Sales Rep Names with Ties.flv	24.7 MB
51 Extract Dates from Cell With Dates and Words.flv	24.4 MB
34 Dynamic Range for Adding Three Methods.flv	24.0 MB
52 Lookup Two Criteria SUMIFS. DGET. or Array Formula.flv	24.0 MB
63 2 Criteria Lookup and Multiple Table Lookup From Different Sheets.flv	23.5 MB
06 Get Last Value in Row.flv	23.3 MB
29 Existing Customers in Prospect List.flv	23.2 MB
68 Count Dates in Column That Match Year and Month Criteria.flv	22.6 MB
01 Two 2 Way Lookup.flv	22.2 MB
15 Frequency Distribution.flv	21.3 MB
12 Sort Numbers With Formula.flv	21.1 MB
47 Unlink Chart.flv	21.0 MB
16 Scroll Bar for Percentage.flv	20.7 MB
62 Conditional Format Chart Auto Feature or Formula.flv	20.5 MB
18 IF function with FIND SEARCH AND OR ISERROR & ISNUMBER functions.flv	20.4 MB
03 Wildcard Count.flv	19.5 MB
26 Randomize Between 2 Dates.flv	19.4 MB
17 Count Times Greater Than 5 M.flv	19.4 MB
37 Evalualte Text Math VBA. Excel 4 Macro Function. MoreFunc add-in.flv	19.4 MB
70 Lookup & Return Last 5 Numbers in a List.flv	19.3 MB
24 VLOOKUP. MAX. Boolean. IF. Which is Best.flv	19.0 MB
60 Conditional Format High Blood Pressures -- 4 Methods.flv	18.9 MB
39 Lookup Row (ALL COLUMNS) w VLOOKUP & OFFSET wrapped in SUMPRODUCT.flv	18.8 MB
57 Extract Many Years from Just Two Years.flv	18.8 MB
69 Count Saturdays.flv	18.4 MB
11 Randomly Select A Name.flv	18.3 MB
13 AVERAGE without Zeroes.flv	17.2 MB
67 Extract Initials From Full Name VBA or Formula.flv	16.9 MB
28 Find Earliest Date From List of Dates Given 2 Criteria.flv	16.7 MB
10 Turn Column Row Upside Dow.flv	15.9 MB
35 3 Way Lookup INDEX or OFFSET function.flv	15.5 MB
59 Custom Lists. Defined Names. PivotTable & COUNTIF Function.flv	14.5 MB
56 Copy Formula Down. Have Range Move Across.flv	14.4 MB
43 End Inventory Value From Transactional Records SUMPRODUCT SUMIF.flv	14.0 MB
61 Formula to Report Cell Reference 5 Examples.flv	13.7 MB
55 Calculate Grade & Exclude Scores When Student is Absent.flv	12.6 MB
50 SUM Non - #NA errors SUMIF or AGGREGATE.flv	12.5 MB
46 Lookup a value and Retrieve the two items to the Right INDEX & MATCH.flv	12.4 MB
64 Extract Records With Not Criteria VBA or Filter.flv	12.4 MB
45 + or with Formula or Custom Number Formatting Math Plus or Minus.flv	12.3 MB
58.5 Sorting Formula for Biggest Sales and Sales Rep Names with Ties.flv	12.2 MB
44 Count Mondays Between 2 Dates WEEKDAY or TEXT.flv	11.0 MB
21 Excel 2010 Sparklines (Amazing Cell Charts!!).flv	10.6 MB
02 Decrease Values By 35%.flv	9.7 MB
48 Screen Tip & Excel is Broken.flv	6.5 MB
/Excel/Name Tricks/
09 Create Name Formulas.flv	34.6 MB
01 Names in Excel 2003 & 2007.flv	31.5 MB
03 Names in Formulas and Functions.flv	25.5 MB
12-1 F2 Key and Apply Names.flv	25.2 MB
06 Names COUNTIF & wildcards.flv	24.6 MB
05 Names for Pivot Tables & more.flv	23.7 MB
10 Store Lookup Tables in Memory.flv	20.9 MB
07 INDIRECT function. Names and LOOKUP.flv	18.3 MB
11 Global Percentage Change Formula.flv	17.7 MB
08 Names Relative Cell Reference for Sheet.flv	16.5 MB
12-2 Names & Excel 2007 Tables.flv	10.6 MB
04 Names & Quick Formula Creation.flv	8.9 MB
02 Names for Go to Quick Navigation.flv	7.4 MB
12-3 Paste Name List.flv	4.7 MB
/Excel/Statistics/
88 Confidence Interval & Hypothesis Tests.flv	101.0 MB
89 Hypothesis Testing With Critical Value & p-value.flv	81.2 MB
51 Probability Basics with Excel.flv	69.0 MB
57 Build Discrete Probability Distribution & Chart.flv	64.3 MB
32 Frequency Distribution Summary (Pivot Table & Formula).flv	62.9 MB
80 Confidence Interval Sigma Known.flv	62.0 MB
76 Sampling Distribution of Sample Mean & Central Limit Theorem.flv	58.5 MB
62 Binomial Experiments & Probabilities.flv	57.0 MB
50 Probability Basics (by hand notes).flv	55.3 MB
49 Outliers & Box Plot with Median and Mean.flv	54.7 MB
70 #2 Normal Probability Excel Functions & Area Charts.flv	51.8 MB
41 Sample Standard Deviation (Variability).flv	51.0 MB
09 What is Statistics.flv	47.6 MB
59 Discrete Probability Mean & Standard Deviation SUMPRODUCT function.flv	47.5 MB
33 Measures of Location.flv	45.8 MB
47 Empirical Rule (Bell Shaped Curve).flv	43.3 MB
69 #1 Normal Probability Excel Functions & Area Charts.flv	41.4 MB
22 Histogram & Ogive Charts & % Cumulative Frequency.flv	38.5 MB
75 Point Estimates & Sample Error.flv	38.2 MB
66 Continuous Probability Distributions (Normal. Uniform. Exponential).flv	37.8 MB
12 Categorical Frequency Distribution w Formulas.flv	37.3 MB
56 Discrete Probability Distributions (Basics).flv	36.7 MB
10 Data & ScalesLevels of Measurement.flv	36.5 MB
74 Taking a Sample with RAND & VLOOKUP.flv	36.4 MB
52 Probability Laws (by hand notes).flv	36.0 MB
15 Category Frequency Distribution w Pivot Table & Pie Chart.flv	35.7 MB
06 Don't get tricked by Number Formatting.flv	35.7 MB
35 Weighted Mean & Geometric Mean.flv	35.6 MB
20 P1 Quantitative Freq. Dist. w Formulas.flv	35.5 MB
02 Calculations. Operators. Formulas.flv	35.2 MB
04 Frequency Pivot Table Chart Basics.flv	35.2 MB
11 Descriptive & Inferential Statistics.flv	35.1 MB
01 Intro to Excel 2007 for Statistics.flv	35.0 MB
03 Data Analysis Sorting & Pivot Tables.flv	34.9 MB
24 Quantitative Freq. Dist. w Pivot Table.flv	34.8 MB
21 P2 Quantitative Freq. Dist. w Formulas.flv	34.8 MB
25 % Freq. Dist.& Histogram w Pivot Table.flv	34.7 MB
67 Uniform Probability Distributions.flv	34.1 MB
17 Categorical Cross Tabulation with Formulas.flv	33.9 MB
05 Cell References in Formulas.flv	33.0 MB
77 Probabilities for Sampling Distribution of Sample Mean.flv	32.0 MB
34 MEAN. MEDIAN. MODE (Averages).flv	31.6 MB
71 #3 Normal Probability Excel Functions & Area Charts.flv	31.4 MB
27 Dot Plot Chart w REPT & COUNTIF functions.flv	31.0 MB
54 Joint Probability Table and More!.flv	30.9 MB
68 Normal (Bell) & Standard Normal Characteristics.flv	29.6 MB
18 Pareto Chart for Categorical Data See how to create.flv	29.6 MB
26 Cumulative Freq. Dist w Pivot Table (Running Total).flv	29.3 MB
82 Confidence Interval Sigma Not Known TINV function.flv	29.0 MB
14 Categorical Relative & Percent Freq. Dist. w Formulas.flv	28.6 MB
53 Probability Laws with Excel.flv	27.9 MB
63 BINOMDIST & Mean & Standard Deviation for Binomial Probability Distribution.flv	27.1 MB
16 Categorical Cross Tabulation with Pivot Table.flv	27.1 MB
46 Chebyshev's Theorem.flv	26.5 MB
65 POISSON function Poisson Probability Distribution.flv	26.5 MB
91 TINV & TDIST functions for Critical Value and P-value 6 examples.flv	26.5 MB
28 Stem & Leaf Chart w REPT & COUNTIF functions.flv	25.8 MB
13 Column Chart From Frequency Distribution.flv	25.8 MB
44 Skew & SKEW function.flv	25.8 MB
64 Cumulative BINOMDIST with IF Function for Cumulative Distribution Charts.flv	25.2 MB
37 PERCENTILE & QUARTILE.flv	25.1 MB
30 Scatter Diagram for 2 Quantitative Variables.flv	24.3 MB
81 Confidence Interval Sigma Known From Raw Data.flv	23.8 MB
73 Exponential Probability EXPONDIST function.flv	23.2 MB
55 Probability Pivot Table.flv	22.9 MB
38 Data Analysis Add-in Rank & Percentile.flv	22.8 MB
19 Grouping Categories w Formula & Pivot Table.flv	22.7 MB
85 Confidence Intervals for Proportions #1.flv	22.7 MB
35.2 Geometric Average V Arithmetic Mean - Finance Example.flv	21.6 MB
79 Proportions Sampling Distribution.flv	21.0 MB
31 Histogram using Data Analysis Add-in.flv	20.7 MB
29 Quantitative Cross Tabulation W Pivot Table.flv	20.5 MB
39 Variability Chart - Visual Approach (Dispersion or Spread).flv	20.1 MB
87 Sample Size for Confidence Intervals.flv	19.9 MB
93 Hypothesis Test Proportions.flv	17.5 MB
84 Confidence Interval Data Analysis Add-in Descriptive Statistics.flv	17.4 MB
90 NORMSINV for Critical Value NORMSDIST for P-value 6 examples.flv	17.1 MB
45 Z-Score (# Standard Deviations From Mean).flv	16.3 MB
92 Hypothesis Test T Distribution.flv	16.3 MB
07 Calculate Proportions and Percentages.flv	15.8 MB
58 Discrete Probability Chart with 2 Data Sets.flv	15.8 MB
61 Stock Expected Return & Standard Deviation (Probability).flv	15.1 MB
42 Coefficient of Variation.flv	14.7 MB
60 Budget Income Statement (Probability) SUMPRODUCT function.flv	14.7 MB
23 Skew in Histograms.flv	13.8 MB
36 Trimmed Mean.flv	13.6 MB
40 Range & Interquartile Range (Variability).flv	13.4 MB
83 Confidence Interval for Advertising TINV function.flv	13.0 MB
78 Relationship Standard Error & Sample Size.flv	12.5 MB
86 Confidence Intervals for Proportions #2.flv	12.3 MB
72 Find X Given Normal Probabilities NORMINV & NORMSINV functions.flv	11.9 MB
48 Empirical Rule vs Chebyshev's Theorem.flv	9.4 MB
08 Install Excel 2007 Data Analysis Add-in.flv	9.4 MB
55.5 Bayes Theorem Posterior Probabilities.flv	8.1 MB
43 Data Analysis Add-in Descriptive Statistics.flv	6.5 MB
Total files 518