Download Comprehensive Excel course >1400 sorted lessons [up to 2011-03, ENG] 1 half Torrent

Torrent Contents Size: 13.4 GB

Comprehensive Excel course >1400 sorted lessons [up to 2011-03, ENG] 1 half

Excel

1 Basics

01 What is Excel.flv	FLV	18.71 MB
02 Keyboard Shortcuts.flv	FLV	29.86 MB
03 Formulas w Cell References.flv	FLV	15.09 MB
04 Formulas and Functions.flv	FLV	15.15 MB
05 Formulas Operators and Math.flv	FLV	16.68 MB
06 Names Cell Ranges and Functions.flv	FLV	18.46 MB
07 Range Functions.flv	FLV	9 MB
08 Cell References Relative & Absolute.flv	FLV	17.56 MB
09 Mixed Cell References in Formulas.flv	FLV	16.75 MB
10 Formulas Copy vs Cut.flv	FLV	9.73 MB
11 Spreadsheet Setup & Cell References.flv	FLV	20.17 MB
12 Stylistic & Number Formatting.flv	FLV	17.24 MB
13 Percentage Number Format.flv	FLV	13 MB
14 ROUND function & Number Formatting.flv	FLV	16.11 MB
15 Date & Time Format & Calculations.flv	FLV	20.04 MB
16 Chart Basics - Excel Charts.flv	FLV	19.24 MB
17 Page Setup.flv	FLV	21.25 MB
18 Data Analysis Sort.flv	FLV	18.88 MB
19 Data Analysis Subtotals.flv	FLV	19.06 MB
20 Data Analysis Pivot Tables PivotTables.flv	FLV	24.73 MB
21 Data Analysis Filter &Dynamic Ranges.flv	FLV	20.63 MB
22 IF function formula made easy!.flv	FLV	23.31 MB
23 VLOOKUP function formula.flv	FLV	16.98 MB

2 Highline Excel Class

01 Back to Basics.flv	FLV	26.37 MB
02 Excel Formulas & Excel Functions.flv	FLV	50.08 MB
03 Names. Cell References. Formula Inputs.flv	FLV	64.19 MB
04 Style & Number Format & ROUND.flv	FLV	31.37 MB
05 Charts. Page Setup. Data Analysis.flv	FLV	58.2 MB
06 Worksheet & Workbook References.flv	FLV	24.38 MB
07 VLOOKUP function formula 7 Examples.flv	FLV	52.38 MB
08 3-D Cell References Add Across Sheets.flv	FLV	13.96 MB
09 SUMIF Function Formula 3 Examples.flv	FLV	25.27 MB
10 VLOOKUP SUMIF & Percentage Increase.flv	FLV	30.18 MB
11 Logical formulas. IS & IF functions.flv	FLV	73.21 MB
12 DATE functions & Formulas.flv	FLV	22.32 MB
13 Text functions & AMPERSAND.flv	FLV	55.18 MB
14 How to Setup Data in Excel.flv	FLV	17.01 MB
15 Excel 2007 Tables 7 Examples.flv	FLV	28.55 MB
16 Sort. Sorting 10 Examples.flv	FLV	30.7 MB
17 Filter. Filtering 8 Examples.flv	FLV	26.63 MB
18 Subtotals.flv	FLV	29.89 MB
19 Advanced Filter Extract Data 9 Examples.flv	FLV	74.57 MB
20 Pivot Tables 20 Examples.flv	FLV	79.5 MB
21 Conditional Formatting 12 Examples.flv	FLV	56.82 MB
22 Budgets. Scenarios & Scenarios Report.flv	FLV	34.19 MB
23 Import Different Types of Data.flv	FLV	51.58 MB
24 Order of Precedents.flv	FLV	31.22 MB
25 Fix Problems & Errors in Spreadsheet.flv	FLV	29.78 MB
26 Fixing Other Peoples Spreadsheets.flv	FLV	33.55 MB
27 Custom Number Format & TEXT function.flv	FLV	64.97 MB
28 More Excel Basics Review.flv	FLV	68.25 MB
29 Basic Statistics Numerical Measures.flv	FLV	47.89 MB
30 SUMIF. RANK & Bonuses.flv	FLV	38.22 MB
31 Histogram & LARGE SMALL functions.flv	FLV	45.57 MB
32 More Charts & SUMIFS & AVERAGEIFS.flv	FLV	50.71 MB
33 IF AND OR Customer Credit Analysis.flv	FLV	61.27 MB
34 IF function Formula Payroll Formula.flv	FLV	25.57 MB
35 IF Function vs VLOOKUP Function.flv	FLV	19.94 MB
36 Array Formulas Basics.flv	FLV	76.74 MB
37 SUMPRODUCT function.flv	FLV	53.86 MB
38 Array Functions TRANSPOSE FREQUENCY.flv	FLV	15.66 MB
39 Forcing Functions to Become Arrays.flv	FLV	54.66 MB
40 VLOOKUP 11 Unusual Examples.flv	FLV	85.38 MB
41 HLOOKUP ROWS Horizontal Lookup.flv	FLV	5.4 MB
42 Versatile LOOKUP function 10 Examples.flv	FLV	65.13 MB
43 MATCH function.flv	FLV	17.48 MB
44 Basics of INDEX & MATCH functions.flv	FLV	52.36 MB
45 INDEX function & MATCH function 12 Unusual Examples.flv	FLV	100.02 MB
46 CHOOSE function 4 Examples.flv	FLV	26.44 MB
47 PMT function 5 Examples.flv	FLV	37.71 MB
48 Interest Rates 6 Examples.flv	FLV	43.69 MB
49 Spreadsheet to Compare Loans.flv	FLV	33.95 MB
50 Value Asset PV NPV & XNPV function.flv	FLV	30.67 MB
51 Life Time Savings Plan.flv	FLV	25.97 MB
52-1 Recorded Macro Basics.flv	FLV	57.72 MB
52-2 Macro Security.flv	FLV	6.8 MB
53 Relative & Absolute Macro Recorder.flv	FLV	60.38 MB
54 Excel VBA code From Internet.flv	FLV	32.72 MB

Array Formula series

01 Basics of Array Formulas.flv	FLV	27.33 MB
02 TRANSPOSE function.flv	FLV	7.25 MB
03 Expected Return for Stocks.flv	FLV	11.91 MB
04 Find Largest Improvement.flv	FLV	10.25 MB
05 SUM 3 Largest Values.flv	FLV	8.74 MB
06 Statistics Bayes' Theorem.flv	FLV	12.93 MB
07 Boolean Logic & Criteria.flv	FLV	33.11 MB
08 FREQUENCY function.flv	FLV	18.24 MB
09 Count Characters in Range.flv	FLV	5.99 MB
10 Amazing Syntax Array Trick.flv	FLV	16.94 MB
11 ROW & COLUMN functions.flv	FLV	16.06 MB
12 MMULT function Matrix Algebra.flv	FLV	7.67 MB
13 LINEST function.flv	FLV	34.2 MB
14-1 Stock Returns.flv	FLV	22.58 MB
14-2 Beginning Stock Analysis.flv	FLV	33.67 MB
14-3 Portfolio Standard Deviation.flv	FLV	33.99 MB
14-4 Stock Portfolio Analysis.flv	FLV	16.24 MB

Business Math series

01 What is Excel.flv	FLV	20.74 MB
02 Formulas and Math Operators.flv	FLV	25.55 MB
03 Math Order of Operations.flv	FLV	18.22 MB
04 the Importance of Formatting in Math.flv	FLV	22.38 MB
05 Functions & Formulas.flv	FLV	25.57 MB
06 Relative & Absolute Cell References.flv	FLV	7.69 MB
07 When ROUND function is Required.flv	FLV	10.94 MB
08 Whole. Decimal Numbers & Formatting.flv	FLV	27.21 MB
09 ROUNDING Numbers in Excel.flv	FLV	26.76 MB
10 Adding and Subtracting.flv	FLV	26.84 MB
11 Order of Operations for Math.flv	FLV	14 MB
12 Multiplying & Dividing in Excel.flv	FLV	35.08 MB
13 Math Word Problems #1.flv	FLV	31.5 MB
14 Math Word Problems #2.flv	FLV	17.47 MB
15 Large Math Word Problem.flv	FLV	26.15 MB
16 Fractions & Fraction Formatting.flv	FLV	37.82 MB
17 Primes & Reducing Fractions.flv	FLV	14.09 MB
18 Decimal into Fraction.flv	FLV	19.28 MB
19 Multiplying & Dividing Fractions.flv	FLV	14.37 MB
20 Adding & Subtracting Fractions.flv	FLV	35.81 MB
21 Fraction Word Problem.flv	FLV	21.32 MB
22 Convert Decimals & Fractions to Percent.flv	FLV	25.79 MB
23 Rules for Percents in Excel - Percentage.flv	FLV	12.34 MB
24 Fraction and Percent Equivalents.flv	FLV	15.92 MB
25 Part = Rate Base = Percent Formula.flv	FLV	21.56 MB
26 Solve for Part in Percent Formula.flv	FLV	17.9 MB
27 Solve for Base in Percent Formula.flv	FLV	17.2 MB
28 Solve for Rate in Percent Formula.flv	FLV	23.36 MB
29 Rate of Change Formulas.flv	FLV	25.51 MB
30 Rate of Change Business Problems.flv	FLV	24.85 MB
31 Increase & Decrease Math Problems.flv	FLV	35.14 MB
32 Markup & Markdown Math Problems.flv	FLV	16.28 MB
33 Stock Values Web Query & Rate of Change.flv	FLV	20.31 MB
34 Bank Checks.flv	FLV	34.62 MB
35 Check Accounts Service Charge & Balance.flv	FLV	47.11 MB
36 Bank Service Terms & Credit Card Calculations.flv	FLV	43.18 MB
37 Bank Reconciliation.flv	FLV	35.48 MB
38 Gross Pay and Overtime 5 Examples.flv	FLV	87 MB
39 Incentive Rate Formulas 8 Examples.flv	FLV	94.76 MB
40 Equivalent Earning Formulas 12 Examples.flv	FLV	18.73 MB
41 Payroll Deductions With Ceilings (FICA).flv	FLV	49.42 MB
42 Federal Income Tax Payroll Deduction.flv	FLV	68.76 MB
43 Invoices & Trade Discounts.flv	FLV	55.19 MB
44 Series Trade Discounts.flv	FLV	60.66 MB
45 Trade Discount Word Problem.flv	FLV	9.04 MB
46 Cash Discounts.flv	FLV	72.72 MB
47 Partial Invoice Payment w Discount.flv	FLV	8.55 MB
48 Basics of Markup (Cost & Selling).flv	FLV	36.07 MB
49 Markup On Cost.flv	FLV	29.77 MB
50 Markup On Selling Price.flv	FLV	26.95 MB
51 Convert Markups & Perishable Sell Price.flv	FLV	24.1 MB
52 Markup & Markdown.flv	FLV	15.26 MB
53 Simple Interest & Loans Notes.flv	FLV	76.54 MB
54 Simple Interest Part & Base & Rate.flv	FLV	15.13 MB
55 Simple Interest Discount Note.flv	FLV	26.68 MB
56 Compound Interest & Future Value.flv	FLV	77.84 MB
57 Future Value Calculations.flv	FLV	44.11 MB
58 Present Value Calculations.flv	FLV	25.38 MB
59 Annuities Math & Excel.flv	FLV	47.49 MB
60 Future Value Annuities FV & PMT function.flv	FLV	44.56 MB
61 Present Value Annuities PV & PMT function.flv	FLV	72.07 MB
62 Sinking Funds.flv	FLV	38.51 MB

Dynamic Charts

01 Hide-Unhide Rows.flv	FLV	8.3 MB
02 Filter & Sort Feature.flv	FLV	9.27 MB
03 Table Feature (Excel 2010, 2007) List Feature (Excel 2003).flv	FLV	9.43 MB
04 Advanced Filter.flv	FLV	15.41 MB
05 Dynamic Chart Labels using TEXT function and Ampersand &.flv	FLV	11.61 MB
06 PivotTable PivotChart.flv	FLV	11.42 MB
07 SUMIFS function.flv	FLV	20.03 MB
08 SUMPRODUCT function (Excel 2003 substitute for SUMIFS).flv	FLV	6.02 MB
09 4 Week Chart Dynamic Formula & Dynamic Data Validation Formula.flv	FLV	28.29 MB
10 OFFSET Function Dynamic Range.flv	FLV	34.58 MB
11 Dynamic Area Chart with IF Function - Normal Distribution Chart Statistics.flv	FLV	20.55 MB
12 INDEX function as Alternative to OFFSET function for Dynamic Ranges.flv	FLV	19.15 MB
13 Web Query Stock Percent of Target Chart.flv	FLV	11.13 MB
14 Progress Chart Linked to Stock Market (Stock Prices vs Target Sell Price).flv	FLV	12.18 MB
15 Array Formula & Table Nomenclature for Top 10 Wrestling Score Chart.flv	FLV	18.45 MB
16 Dynamic Average Hurdle Line for Bar Chart. Scatter and Bar Chart Together.flv	FLV	17.86 MB

Excel 2010 Preview

1 New Rank Function RANK.AVE.flv	FLV	5.06 MB
2 Copy & Paste Special Magic.flv	FLV	6.06 MB
3 New Percentile Function PERCENTILE.EXC.flv	FLV	7.64 MB
4 Pivot Table Slicer (ReportPage Filter Slicer).flv	FLV	7.18 MB
5 Conditional Formatting Negative Data Bars.flv	FLV	6.17 MB
6 Normal Distribution Statistic Functions NORM.DIST & NORM.S.DIST.flv	FLV	7.82 MB
7 Confidence Intervals for T-Distribution CONFIDENCE.T function.flv	FLV	6.06 MB
8 Five New T-Distribution Functions that Replace TINV & TDIST.flv	FLV	20.56 MB

Finance Class

001 Intro to Excel 2007 & 2010.flv	FLV	32.33 MB
002 Getting Started with Formulas. Functions. Formula Inputs and Cell References.flv	FLV	49.99 MB
003 Math Operators and Order of Operations.flv	FLV	51.86 MB
004 the Importance of Number Formatting in Financial Calculations.flv	FLV	31.62 MB
005 Percent. Percent Change Increase Decrease Percentage Number Formatting.flv	FLV	25.94 MB
006 Relative and Absolute Cell References in Copied Formulas.flv	FLV	20.45 MB
007 Stylistic Formatting.flv	FLV	8.22 MB
008 Intro to Corporate Financial Management.flv	FLV	93.21 MB
009 Balance Sheet. Working Capital. Liquidity. Debt. Equity. Market Value.flv	FLV	67.58 MB
010 Income Statement. Non Cash Depreciation Expense. Matching Principal.flv	FLV	46.88 MB
011 Finance Cash Flow From Accounting Information.flv	FLV	84.8 MB
012 Cash Flow Advantage to Debt & Average and Marginal Tax Rates.flv	FLV	31.24 MB
013 Banks. Fundamental Problem With Banks. & the Big Short.flv	FLV	13.01 MB
014 Financial Statement Ratio Analysis - #1 Trick for Ratio Analysis.flv	FLV	69.09 MB
015 Common Sized Financial Statements.flv	FLV	30.8 MB
016 Liquidity. Current Ratio and How Current Ratio Can Be Manipulated.flv	FLV	34.49 MB
017 Leverage & Solvency Ratios Debt to Equity. Equity Multiplier. more.flv	FLV	46.17 MB
018-1 Asset Efficiency Ratio and Cash Cycle in Days.flv	FLV	41.45 MB
018-2 Ratios for Cash Cycle in Days.flv	FLV	19.48 MB
019 Profitablility Rations Return On Equity & Return On Assets & DuPont Analysis.flv	FLV	35 MB
020 Growth Ratios and Market Value Ratios.flv	FLV	30.16 MB
021 Future Value Lump Sum Calculations. Simple & Compound Interest.flv	FLV	63.04 MB
022 Present Value Lump Sum Calculations and PV Function.flv	FLV	35.88 MB
023 Solve for Total Number of Periods When You Know PV. FV and Period Rate.flv	FLV	11.45 MB
024 Solve for Period Rate & Annual Rate When You Know PV. FV and # of Periods.flv	FLV	25.82 MB
025 Future Value for Lender or Borrower.flv	FLV	8.66 MB
026 Multiple Cash Flow Valuation Future Value and Present Value FV PV Functions.flv	FLV	41.98 MB
027 Asset Valuation Using Discounted Cash Flow Analysis and PV Function.flv	FLV	15.54 MB
028 Relationship Between APR. Period Rate and Effective Annual Rate.flv	FLV	40.47 MB
029 Calculate Future Value of An Annuity (FV Function).flv	FLV	36.28 MB
030 Future Value for Interest Paid Daily. But Deposits Made Monthly.flv	FLV	13.21 MB
031 Calculate PMT for Future Value of Annuity (PMT Function).flv	FLV	14.92 MB
032 Calculate Present Value of Annuity (PV Function).flv	FLV	21.61 MB
033 Full Life Retirement Plan PV Annuity & FV Annuity PV & PMT Functions.flv	FLV	21.4 MB
034 Present Value of Annuity for Asset Valuation.flv	FLV	6.96 MB
035 Calculate PMT for Present Value of Annuity PMT Function for Loan Payment.flv	FLV	5.15 MB
036 PMT Function 7 Examples & Adjusted APR with Points and RATE function.flv	FLV	38.93 MB
037 How Much Do I Get Each Month During Retirement.flv	FLV	7.26 MB
038 Calculate APR and EAR Given Cash Flows From Annuity.flv	FLV	4.58 MB
039 How Long to Pay Off Credit Card With Minimum Payment.flv	FLV	5.58 MB
040 Perpetuity (consol) Preferred Stock Valuation Formula.flv	FLV	6.34 MB
041 Interest Only Loan Schedule.flv	FLV	3.31 MB
042 Consumer Amortized Loans.flv	FLV	18.18 MB
043 Business 0Amortized Loans.flv	FLV	6.82 MB
044 Deep Discount Loans.flv	FLV	12.33 MB
045 Interest Rates Real. Nominal. Inflation and the Fisher Effect.flv	FLV	37.12 MB
046 Bonds Just A Set of Cash Flows Discounted at Market Rate - Coupon or Zero.flv	FLV	62.85 MB
047 Selling Bond When Coupon Rate is Different Than Discount Rate (YTM Rate).flv	FLV	17.49 MB
048 Calculate YTM and Effective Annual Yield From Bond Cash Flows RATE & EFFECT.flv	FLV	7.24 MB
049 Bond Quoted Price & Yield to Market.flv	FLV	10.87 MB
050 Bond Rates are Inversely Related to Bond Price (Scatter Diagram Excel Chart).flv	FLV	15.74 MB
051 Par - Discount - Premium Bonds.flv	FLV	20.38 MB
052 Bond Discount or Premium Amortization Table.flv	FLV	14.25 MB
053 Bond Discount or Premium Journal Entries.flv	FLV	18.81 MB
054 Bonds & Interest Rate Risk.flv	FLV	22.81 MB
055 Tax Advantage of Muni Bond.flv	FLV	6.58 MB
056 Tax Implications for Zero Coupon Bonds.flv	FLV	18.16 MB
057 Compare Cash Flows for a Coupon & A Zero Coupon Bond.flv	FLV	27.26 MB
058 After Tax Cash Flows & After Tax Interest Rates.flv	FLV	13.74 MB
059 Common & Preferred Stock.flv	FLV	38.89 MB
060 Basics of Financial Markets.flv	FLV	37.04 MB
061 Stock Value Based on Present Value of Future Dividend Cash Flows.flv	FLV	18.45 MB
062 Preferred Stock Valuation as A Perpetuity.flv	FLV	7.18 MB
063 Stock Valuation with Dividend Growth Model.flv	FLV	9.86 MB
064 Chart How Stock Value Changes for Dividend Growth Model as Inputs Change.flv	FLV	17.71 MB
065 Calculate Stock Price at Time t using Dividend Growth Model.flv	FLV	13.18 MB
066 Calculate Implied Return using Dividend Growth Model.flv	FLV	7.91 MB
067 Irregular Dividend Payments. Followed by Constant Growth -- Stock Valuation.flv	FLV	29.28 MB
068 Net Present Value. NPV Excel Function & Capital Budgeting.flv	FLV	37.65 MB
069 Net Present Value Profile -- Build Table and Chart in Excel NPV Function.flv	FLV	44.44 MB
070 Investment Criteria Net Present Value.flv	FLV	7 MB
071 Investment Criteria Payback Rule.flv	FLV	23.09 MB
072 Investment Criteria Average Accounting Return.flv	FLV	20.68 MB
073 Investment Criteria Internal Rate of Return IRR Function Plot Chart.flv	FLV	50.07 MB
074 IRR and Non-conventional Cash Flows. Plot Chart to See Multiple IRR.flv	FLV	16.29 MB
075 IRR and Mutually Exclusive Projects - Plot Chart to See Cross 0Over Rate.flv	FLV	23.46 MB
076 Investment Criteria MIRR - Modified Internal Rate of Return.flv	FLV	19.25 MB
077 Investment Criteria Profitability Index.flv	FLV	5.43 MB
078 NPV for Irregular Cash Flows and Time Periods XNPV. NPV and PV functions.flv	FLV	14.97 MB
079 Investment Criteria NPV. IRR. Payback. AAR. Profitability Index.flv	FLV	17.83 MB
080 Recognizing Patterns of Cash Flows for Discounted Cash Flow Analysis.flv	FLV	16.24 MB
081 XNPV Function XIRR Function - See Algorithm That XNPV uses.flv	FLV	32.53 MB
082 Relevant Costs for Discounted Cash Flow Analysis = Incremental Cash Flows.flv	FLV	39.98 MB
083 Estimating Cash Flows for NPV calculation.flv	FLV	34.22 MB
084 Undoing Accrual Accounting to Discover Cash Flows for Estimating NPV.flv	FLV	16.53 MB
085 MACRS Depreciation & Asset Sale Impacts on NPV Cash Flows.flv	FLV	24.01 MB
086 Estimating Cash Flows for NPV calculation Comprehensive Example.flv	FLV	52.57 MB
087 Cost Savings Example Estimating Cash Flows for NPV calculation.flv	FLV	17.07 MB
088 Scenario Analysis for Cash Flow & NPV Calculations.flv	FLV	35.35 MB
089 Sensitivity Analysis for Cash Flow & NPV Calculations.flv	FLV	26.92 MB
090 Period (Holding) Returns for Stock.flv	FLV	13.04 MB
091 Period (Holding) Nominal. Real & Dollar Returns for Coupon Bond.flv	FLV	8.96 MB
092 Period (Holding) Returns for Zero Bond.flv	FLV	7.54 MB
093 Period (Holding) Returns for Preferred Stock.flv	FLV	5.01 MB
094 Period (Holding) Returns for Less 0Than 1 Year. APR and EAR.flv	FLV	8.99 MB
095 Using Past Period Holding Returns to Estimate Future Returns Arithmetic Mean.flv	FLV	7.79 MB
096 Comparing Geometric Mean with Arithmetic Mean for Average Stock Returns.flv	FLV	34.08 MB
097 Using Geometric Mean & Arithmetic Mean to Estimate Future Returns.flv	FLV	7.93 MB
098 Stock Return Variation Measured with Standard Deviation (Risk of Stock).flv	FLV	25.35 MB
099 US Capital Market History 5 Types Investments (2 Good Lessons).flv	FLV	50.25 MB
100 Real Rate and Inflation or Deflation for T-bills.flv	FLV	7.78 MB
101 Average Real Return for A Stock Based On Historical Data.flv	FLV	6.98 MB
102 in the Short Run Financial Markets Can Be Inefficient Mispriced Assets.flv	FLV	12.38 MB
103 2 Ways to Calculate Geometric Mean.flv	FLV	11.57 MB
104 Expected Return & Standard Deviation for 1 Stock -- Estimating Future.flv	FLV	25.26 MB
105 Expected Return & Standard Deviation for Portfolio -- Estimating Future.flv	FLV	23.41 MB
106 Unexpected Information. Market & Asset Specific Risk. Diversification. Beta.flv	FLV	29.95 MB
107 Calculating Beta (2 Methods) & Chart Beta. SLOPE CORREL & STDEV functions.flv	FLV	27.09 MB
108 Reward to Risk Ratio - Treynor Index.flv	FLV	13.1 MB
109 Beta for Portfolio.flv	FLV	7.77 MB
110 Security Market Line (SML) & Capital Asset Pricing Model (CAPM).flv	FLV	18.44 MB
111 Treynor Index & CAPM.flv	FLV	6.43 MB

Finance Tricks

01 FV PV & Time Value of Money.flv	FLV	15.56 MB
02 Simple & Compound Interest.flv	FLV	36.15 MB
03 PMT function Lender or Borrower.flv	FLV	30.88 MB
04 PMT function & Balloon payment.flv	FLV	11.28 MB
05 PMT & FV function & Delayed Payments.flv	FLV	22.09 MB
06 RATE function and Loan Points.flv	FLV	13.85 MB
07 EFFECT function (EAR Rate).flv	FLV	7.86 MB
08 Complete Loan Analysis.flv	FLV	35.02 MB
09 Daily Interest But Monthly Deposits!.flv	FLV	14.37 MB
10 Interest Rate for Pay Day Loans.flv	FLV	20.02 MB
11 How Long Pay Off Credit Card Balance.flv	FLV	10.62 MB
12 SLN & DDB Depreciation functions.flv	FLV	11.63 MB
13 PV function Capital Invest Decision.flv	FLV	12.04 MB
14 NPV function Capital Invest Decision.flv	FLV	11.43 MB
15 PV & NPV don't work XNPV function.flv	FLV	19.31 MB
16 Work Life & Retirement Finance.flv	FLV	28.29 MB
17 Amortization Table w x Column.flv	FLV	34.94 MB
18 CUMIPMT function for Interest.flv	FLV	28 MB

Formula Efficiency

01 SUMPRODUCT function 12 Examples.flv	FLV	25.68 MB
02 Time Your Formulas for Speed.flv	FLV	18.53 MB
03 Database D Functions are Fast.flv	FLV	30.22 MB
04 SUMIFS & COUNTIFS are Fast.flv	FLV	22 MB
05 Helper Cell Speed Up Calculation.flv	FLV	10.65 MB
06 Concatenated Field Speeds Up Formula.flv	FLV	19.49 MB
07 Helper Column Speeds Calculation.flv	FLV	18.37 MB
08 Custom VBA Function Can Be Fast.flv	FLV	9.46 MB
09 Faster Running Total Formula.flv	FLV	6.36 MB
10 Automatic & Manual Calculation.flv	FLV	8.51 MB
11 Pivot Table Faster Than Formula.flv	FLV	19.98 MB
12 Fastest Formula in Excel.flv	FLV	16.6 MB

Law Class

1 Create Comparative Budget - Jessica's Law Class.flv	FLV	94.59 MB
2 Child Support Payments Template - Jessica's Law Class.flv	FLV	20.47 MB
3 Statistics for Age Discrimination Case - Jessica's Law Class.flv	FLV	33.48 MB

Lookup series

01 VLOOKUP Function 1st Example.flv	FLV	26.25 MB
02 VLOOKUP Function 2nd Example.flv	FLV	18.91 MB
03 VLOOKUP Function 3rd Example.flv	FLV	11.96 MB
04 PART 1 VLOOKUP Function 4th Example.flv	FLV	31.1 MB
04 PART 2 VLOOKUP Function 4th Example.flv	FLV	17.23 MB
05 VLOOKUP Function 5th Example.flv	FLV	29.23 MB
06 HLOOKUP Function.flv	FLV	12.64 MB
07 LOOKUP Function.flv	FLV	23.93 MB
08 MATCH Function.flv	FLV	13.83 MB
09 INDEX function 1st Example.flv	FLV	10.68 MB
10 INDEX function 2nd Example.flv	FLV	13.32 MB
11 INDEX & MATCH functions Two 2 Way Lookup.flv	FLV	15.61 MB
12 INDEX & MATCH functions Example 2!.flv	FLV	16.2 MB
13 INDEX & MATCH functions Example 3!.flv	FLV	36.82 MB
14 CHOOSE function.flv	FLV	12.92 MB

MrExcel & ExcelIsFun friendly challenge

01 Two 2 Way Lookup.flv	FLV	21.19 MB
02 Decrease Values By 35%.flv	FLV	9.27 MB
03 Wildcard Count.flv	FLV	18.57 MB
04 Comparative Charts.flv	FLV	28.36 MB
05 Horizontal Subtotals.flv	FLV	28.98 MB
06 Get Last Value in Row.flv	FLV	22.2 MB
07 Reverse Lookup VBA or Formula.flv	FLV	35.67 MB
08 Top 10 Filter Trouble.flv	FLV	28.8 MB
10 Turn Column Row Upside Dow.flv	FLV	15.18 MB
11 Randomly Select A Name.flv	FLV	17.46 MB
12 Sort Numbers With Formula.flv	FLV	20.14 MB
13 AVERAGE without Zeroes.flv	FLV	16.39 MB
14 Trending Up Down Arrows.flv	FLV	26.26 MB
15 Frequency Distribution.flv	FLV	20.34 MB
16 Scroll Bar for Percentage.flv	FLV	19.77 MB
17 Count Times Greater Than 5 M.flv	FLV	18.54 MB
18 IF function with FIND SEARCH AND OR ISERROR & ISNUMBER functions.flv	FLV	19.42 MB
19 VLOOKUP to Left (MATCH & INDEX or LOOKUP).flv	FLV	24.9 MB
20 Summarize Survey Pivot Table.flv	FLV	34.61 MB
21 Excel 2010 Sparklines (Amazing Cell Charts!!).flv	FLV	10.15 MB
22 Conditional Formatting VBA or OFFSET.flv	FLV	27.89 MB
23 Excel 2010 New Functions.flv	FLV	24.51 MB
24 VLOOKUP. MAX. Boolean. IF. Which is Best.flv	FLV	18.15 MB
25 Extract Records NOT Swim or Ski (Filter or Formula).flv	FLV	28.61 MB
26 Randomize Between 2 Dates.flv	FLV	18.54 MB
27 COUNT w More Than 1 Criteria 10 Examples!.flv	FLV	28.73 MB
28 Find Earliest Date From List of Dates Given 2 Criteria.flv	FLV	15.94 MB
29 Existing Customers in Prospect List.flv	FLV	22.16 MB
30 Count Bills for Money Transaction.flv	FLV	25.45 MB
31 Word Wrap Problem Formula or VBA solution.flv	FLV	32.09 MB
32 Three Methods for 2-Way Look.flv	FLV	24.06 MB
33 First Monday for Reporting Period.flv	FLV	25.9 MB
34 Dynamic Range for Adding Three Methods.flv	FLV	22.93 MB
35 3 Way Lookup INDEX or OFFSET function.flv	FLV	14.81 MB
36 VLOOKUP w Approximate Match & Unsorted Table.flv	FLV	27.68 MB
37 Evalualte Text Math VBA. Excel 4 Macro Function. MoreFunc add-in.flv	FLV	18.47 MB
38 Weekly Report Formula or Pivot Table.flv	FLV	26.57 MB
39 Lookup Row (ALL COLUMNS) w VLOOKUP & OFFSET wrapped in SUMPRODUCT.flv	FLV	17.98 MB
40 VLOOKUP to 3 Different Lookup Tables (3 table_arrays).flv	FLV	32.13 MB
41 VBA or Formula Extract Prefix for VLOOKUP.flv	FLV	37.01 MB
42 Lookup Picture in Excel Formula or VBA.flv	FLV	38.09 MB
43 End Inventory Value From Transactional Records SUMPRODUCT SUMIF.flv	FLV	13.35 MB
44 Count Mondays Between 2 Dates WEEKDAY or TEXT.flv	FLV	10.49 MB
45 + or with Formula or Custom Number Formatting Math Plus or Minus.flv	FLV	11.76 MB
46 Lookup a value and Retrieve the two items to the Right INDEX & MATCH.flv	FLV	11.86 MB
47 Unlink Chart.flv	FLV	20 MB
48 Screen Tip & Excel is Broken.flv	FLV	6.23 MB
50 SUM Non - #NA errors SUMIF or AGGREGATE.flv	FLV	11.91 MB
51 Extract Dates from Cell With Dates and Words.flv	FLV	23.28 MB
52 Lookup Two Criteria SUMIFS. DGET. or Array Formula.flv	FLV	22.88 MB
53 Extract State When Text String Has Varying Number of Commas.flv	FLV	23.63 MB
54 Approximate Lookup to Return Multiple Items.flv	FLV	30.99 MB
55 Calculate Grade & Exclude Scores When Student is Absent.flv	FLV	12.06 MB
56 Copy Formula Down. Have Range Move Across.flv	FLV	13.71 MB
57 Extract Many Years from Just Two Years.flv	FLV	17.91 MB
58 Sorting Formula for Biggest Sales and Sales Rep Names with Ties.flv	FLV	23.58 MB
58.5 Sorting Formula for Biggest Sales and Sales Rep Names with Ties.flv	FLV	11.65 MB
59 Custom Lists. Defined Names. PivotTable & COUNTIF Function.flv	FLV	13.86 MB
60 Conditional Format High Blood Pressures -- 4 Methods.flv	FLV	18 MB
61 Formula to Report Cell Reference 5 Examples.flv	FLV	13.07 MB
62 Conditional Format Chart Auto Feature or Formula.flv	FLV	19.57 MB
63 2 Criteria Lookup and Multiple Table Lookup From Different Sheets.flv	FLV	22.46 MB
64 Extract Records With Not Criteria VBA or Filter.flv	FLV	11.83 MB
66 Slaying Excel Dragons E-Book Available at Mr Excel Web Site!.flv	FLV	40.55 MB
67 Extract Initials From Full Name VBA or Formula.flv	FLV	16.09 MB
68 Count Dates in Column That Match Year and Month Criteria.flv	FLV	21.52 MB
69 Count Saturdays.flv	FLV	17.55 MB
70 Lookup & Return Last 5 Numbers in a List.flv	FLV	18.39 MB

Name Tricks

01 Names in Excel 2003 & 2007.flv	FLV	30.05 MB
02 Names for Go to Quick Navigation.flv	FLV	7.04 MB
03 Names in Formulas and Functions.flv	FLV	24.35 MB
04 Names & Quick Formula Creation.flv	FLV	8.51 MB
05 Names for Pivot Tables & more.flv	FLV	22.61 MB
06 Names COUNTIF & wildcards.flv	FLV	23.42 MB
07 INDIRECT function. Names and LOOKUP.flv	FLV	17.44 MB
08 Names Relative Cell Reference for Sheet.flv	FLV	15.71 MB
09 Create Name Formulas.flv	FLV	33 MB
10 Store Lookup Tables in Memory.flv	FLV	19.95 MB
11 Global Percentage Change Formula.flv	FLV	16.85 MB
12-1 F2 Key and Apply Names.flv	FLV	24.04 MB
12-2 Names & Excel 2007 Tables.flv	FLV	10.07 MB
12-3 Paste Name List.flv	FLV	4.45 MB

Statistics

01 Intro to Excel 2007 for Statistics.flv	FLV	33.34 MB
02 Calculations. Operators. Formulas.flv	FLV	33.6 MB
03 Data Analysis Sorting & Pivot Tables.flv	FLV	33.28 MB
04 Frequency Pivot Table Chart Basics.flv	FLV	33.57 MB
05 Cell References in Formulas.flv	FLV	31.49 MB
06 Don't get tricked by Number Formatting.flv	FLV	34.04 MB
07 Calculate Proportions and Percentages.flv	FLV	15.04 MB
08 Install Excel 2007 Data Analysis Add-in.flv	FLV	8.92 MB
09 What is Statistics.flv	FLV	45.37 MB
10 Data & ScalesLevels of Measurement.flv	FLV	34.82 MB
11 Descriptive & Inferential Statistics.flv	FLV	33.52 MB
12 Categorical Frequency Distribution w Formulas.flv	FLV	35.6 MB
13 Column Chart From Frequency Distribution.flv	FLV	24.6 MB
14 Categorical Relative & Percent Freq. Dist. w Formulas.flv	FLV	27.27 MB
15 Category Frequency Distribution w Pivot Table & Pie Chart.flv	FLV	34.08 MB
16 Categorical Cross Tabulation with Pivot Table.flv	FLV	25.81 MB
17 Categorical Cross Tabulation with Formulas.flv	FLV	32.31 MB
18 Pareto Chart for Categorical Data See how to create.flv	FLV	28.24 MB
19 Grouping Categories w Formula & Pivot Table.flv	FLV	21.64 MB
20 P1 Quantitative Freq. Dist. w Formulas.flv	FLV	33.87 MB
21 P2 Quantitative Freq. Dist. w Formulas.flv	FLV	33.17 MB
22 Histogram & Ogive Charts & % Cumulative Frequency.flv	FLV	36.71 MB
23 Skew in Histograms.flv	FLV	13.15 MB
24 Quantitative Freq. Dist. w Pivot Table.flv	FLV	33.22 MB
25 % Freq. Dist.& Histogram w Pivot Table.flv	FLV	33.09 MB
26 Cumulative Freq. Dist w Pivot Table (Running Total).flv	FLV	27.98 MB
27 Dot Plot Chart w REPT & COUNTIF functions.flv	FLV	29.59 MB
28 Stem & Leaf Chart w REPT & COUNTIF functions.flv	FLV	24.62 MB
29 Quantitative Cross Tabulation W Pivot Table.flv	FLV	19.51 MB
30 Scatter Diagram for 2 Quantitative Variables.flv	FLV	23.18 MB
31 Histogram using Data Analysis Add-in.flv	FLV	19.69 MB
32 Frequency Distribution Summary (Pivot Table & Formula).flv	FLV	60.03 MB
33 Measures of Location.flv	FLV	43.65 MB
34 MEAN. MEDIAN. MODE (Averages).flv	FLV	30.17 MB
35 Weighted Mean & Geometric Mean.flv	FLV	33.94 MB
35.2 Geometric Average V Arithmetic Mean - Finance Example.flv	FLV	20.62 MB
36 Trimmed Mean.flv	FLV	12.95 MB
37 PERCENTILE & QUARTILE.flv	FLV	23.96 MB
38 Data Analysis Add-in Rank & Percentile.flv	FLV	21.77 MB
39 Variability Chart - Visual Approach (Dispersion or Spread).flv	FLV	19.21 MB
40 Range & Interquartile Range (Variability).flv	FLV	12.74 MB
41 Sample Standard Deviation (Variability).flv	FLV	48.68 MB
42 Coefficient of Variation.flv	FLV	14.06 MB
43 Data Analysis Add-in Descriptive Statistics.flv	FLV	6.21 MB
44 Skew & SKEW function.flv	FLV	24.57 MB
45 Z-Score (# Standard Deviations From Mean).flv	FLV	15.54 MB
46 Chebyshev's Theorem.flv	FLV	25.31 MB
47 Empirical Rule (Bell Shaped Curve).flv	FLV	41.33 MB
48 Empirical Rule vs Chebyshev's Theorem.flv	FLV	8.93 MB
49 Outliers & Box Plot with Median and Mean.flv	FLV	52.13 MB
50 Probability Basics (by hand notes).flv	FLV	52.75 MB
51 Probability Basics with Excel.flv	FLV	65.76 MB
52 Probability Laws (by hand notes).flv	FLV	34.29 MB
53 Probability Laws with Excel.flv	FLV	26.63 MB
54 Joint Probability Table and More!.flv	FLV	29.47 MB
55 Probability Pivot Table.flv	FLV	21.83 MB
55.5 Bayes Theorem Posterior Probabilities.flv	FLV	7.7 MB
56 Discrete Probability Distributions (Basics).flv	FLV	35.04 MB
57 Build Discrete Probability Distribution & Chart.flv	FLV	61.29 MB
58 Discrete Probability Chart with 2 Data Sets.flv	FLV	15.03 MB
59 Discrete Probability Mean & Standard Deviation SUMPRODUCT function.flv	FLV	45.33 MB
60 Budget Income Statement (Probability) SUMPRODUCT function.flv	FLV	14 MB
61 Stock Expected Return & Standard Deviation (Probability).flv	FLV	14.36 MB
62 Binomial Experiments & Probabilities.flv	FLV	54.37 MB
63 BINOMDIST & Mean & Standard Deviation for Binomial Probability Distribution.flv	FLV	25.84 MB
64 Cumulative BINOMDIST with IF Function for Cumulative Distribution Charts.flv	FLV	24.06 MB
65 POISSON function Poisson Probability Distribution.flv	FLV	25.29 MB
66 Continuous Probability Distributions (Normal. Uniform. Exponential).flv	FLV	36.06 MB
67 Uniform Probability Distributions.flv	FLV	32.53 MB
68 Normal (Bell) & Standard Normal Characteristics.flv	FLV	28.28 MB
69 #1 Normal Probability Excel Functions & Area Charts.flv	FLV	39.52 MB
70 #2 Normal Probability Excel Functions & Area Charts.flv	FLV	49.41 MB
71 #3 Normal Probability Excel Functions & Area Charts.flv	FLV	29.94 MB
72 Find X Given Normal Probabilities NORMINV & NORMSINV functions.flv	FLV	11.35 MB
73 Exponential Probability EXPONDIST function.flv	FLV	22.14 MB
74 Taking a Sample with RAND & VLOOKUP.flv	FLV	34.7 MB
75 Point Estimates & Sample Error.flv	FLV	36.4 MB
76 Sampling Distribution of Sample Mean & Central Limit Theorem.flv	FLV	55.76 MB
77 Probabilities for Sampling Distribution of Sample Mean.flv	FLV	30.56 MB
78 Relationship Standard Error & Sample Size.flv	FLV	11.92 MB
79 Proportions Sampling Distribution.flv	FLV	20.07 MB
80 Confidence Interval Sigma Known.flv	FLV	59.13 MB
81 Confidence Interval Sigma Known From Raw Data.flv	FLV	22.68 MB
82 Confidence Interval Sigma Not Known TINV function.flv	FLV	27.68 MB
83 Confidence Interval for Advertising TINV function.flv	FLV	12.43 MB
84 Confidence Interval Data Analysis Add-in Descriptive Statistics.flv	FLV	16.57 MB
85 Confidence Intervals for Proportions #1.flv	FLV	21.63 MB
86 Confidence Intervals for Proportions #2.flv	FLV	11.7 MB
87 Sample Size for Confidence Intervals.flv	FLV	18.97 MB
88 Confidence Interval & Hypothesis Tests.flv	FLV	96.32 MB
89 Hypothesis Testing With Critical Value & p-value.flv	FLV	77.42 MB
90 NORMSINV for Critical Value NORMSDIST for P-value 6 examples.flv	FLV	16.31 MB
91 TINV & TDIST functions for Critical Value and P-value 6 examples.flv	FLV	25.25 MB
92 Hypothesis Test T Distribution.flv	FLV	15.51 MB
93 Hypothesis Test Proportions.flv	FLV	16.67 MB

Description

Show full description

Related Torrents

TORRENT NAME	SIZE	FILES	AGE	SEED	LEECH	SOURCE
Udemy - Microsoft Excel Formulas and Functions - Comprehensive Guide Posted by freecoursewb in Other Posted in Other 31 1.1 GB 1 year ago freecoursewb	Size 1.1 GB	Files 27	Age 1 year ago	Seeds 31	Leechs 12	Source
Comprehensive Excel course >1400 sorted lessons [up to 2011-03, ENG] 2 half Posted by UniBreakfast in Other Posted in Other 3 16.22 GB 15 years ago UniBreakfast	Size 16.22 GB	Files 901	Age 15 years ago	Seeds 3	Leechs 0	Source

Comprehensive Excel course >1400 sorted lessons [up to 2011-03, ENG] 1 half

Torrent Contents Size: 13.4 GB

Description

Related Torrents

Location

Trackers

Latest News

Latest Searches

Sites In Our Index

Popular Tags

Tracker name
http://bt4.t-ru.org/ann?magnet
http://bt2.t-ru.org/ann
http://bt3.t-ru.org/ann
http://bt4.t-ru.org/ann
udp://tracker.opentrackr.org:1337
udp://open.stealth.si:80/announce
udp://tracker.torrent.eu.org:451/announce
udp://exodus.desync.com:6969
udp://open.demonii.com:1337/announce
udp://tracker.coppersurfer.tk:6969
udp://p4p.arenabg.com:1337
udp://tracker.internetwarriors.net:1337