﻿ Excel is Fun WEB-DL » GFXHome | Best CG / VFX Resources for Artists!

» » Excel is Fun WEB-DL

Information of news
• Author: avelin
• Date: 8-03-2015, 01:07
8-03-2015, 01:07

### Excel is Fun WEB-DL

Category: Tutorials

Excel is Fun WEB-DL | 13.395 GB
Genre: E-Learning

Excel is Fun! Why? Because your efficient use of Excel can turn a three hour payroll calculating chore or a five hour reporting task into a five minute breeze. Efficient use of Excel will save a lot of time. That time adds up to extra time for your more enjoyable endeavors in life such as vacations! In addition, your bosses and employees will notice that you are efficient and can produce professional looking reports that impress. This of course leads to promotion more quickly. Still, further, your knowledgeable and efficient use of Excel can land you a job during an interview. Employers are like dry sponges ready to soak up any job candidate that can make their entity more efficient with Excel skills! Save time?, get promoted?, get the job?, and have more time for vacation? ï¿½ That sounds like a great skill to have!
1 Basics

01 What is Excel.flv 19 MB
02 Keyboard Shortcuts.flv 30 MB
03 Formulas w Cell References.flv 15 MB
04 Formulas and Functions.flv 15 MB
05 Formulas Operators and Math.flv 17 MB
06 Names Cell Ranges and Functions.flv 18 MB
07 Range Functions.flv 9 MB
08 Cell References Relative & Absolute.flv 18 MB
09 Mixed Cell References in Formulas.flv 17 MB
10 Formulas Copy vs Cut.flv 10 MB
11 Spreadsheet Setup & Cell References.flv 20 MB
12 Stylistic & Number Formatting.flv 17 MB
13 Percentage Number Format.flv 13 MB
14 ROUND function & Number Formatting.flv 16 MB
15 Date & Time Format & Calculations.flv 20 MB
16 Chart Basics - Excel Charts.flv 19 MB
17 Page Setup.flv 21 MB
18 Data Analysis Sort.flv 19 MB
19 Data Analysis Subtotals.flv 19 MB
20 Data Analysis Pivot Tables PivotTables.flv 25 MB
21 Data Analysis Filter &Dynamic Ranges.flv 21 MB
22 IF function formula made easy!.flv 23 MB
23 VLOOKUP function formula.flv 17 MB

2 Highline Excel Class

01 Back to Basics.flv 26 MB
02 Excel Formulas & Excel Functions.flv 50 MB
03 Names. Cell References. Formula Inputs.flv 64 MB
04 style & Number Format & ROUND.flv 31 MB
05 Charts. Page Setup. Data Analysis.flv 58 MB
06 Worksheet & Workbook References.flv 24 MB
07 VLOOKUP function formula 7 Examples.flv 52 MB
08 3-D Cell References Add Across Sheets.flv 14 MB
09 SUMIF Function Formula 3 Examples.flv 25 MB
10 VLOOKUP SUMIF & Percentage Increase.flv 30 MB
11 Logical formulas. IS & IF functions.flv 73 MB
12 DATE functions & Formulas.flv 22 MB
13 Text functions & AMPERSAND.flv 55 MB
14 How to Setup Data in Excel.flv 17 MB
15 Excel 2007 Tables 7 Examples.flv 29 MB
16 Sort. Sorting 10 Examples.flv 31 MB
17 Filter. Filtering 8 Examples.flv 27 MB
18 Subtotals.flv 30 MB
19 Advanced Filter Extract Data 9 Examples.flv 75 MB
20 Pivot Tables 20 Examples.flv 79 MB
21 Conditional Formatting 12 Examples.flv 57 MB
22 Budgets. Scenarios & Scenarios Report.flv 34 MB
23 Import Different Types of Data.flv 52 MB
24 Order of Precedents.flv 31 MB
25 Fix Problems & Errors in Spreadsheet.flv 30 MB
26 Fixing Other Peoples Spreadsheets.flv 34 MB
27 Custom Number Format & TEXT function.flv 65 MB
28 More Excel Basics Review.flv 68 MB
29 Basic Statistics Numerical Measures.flv 48 MB
30 SUMIF. RANK & Bonuses.flv 38 MB
31 Histogram & LARGE SMALL functions.flv 46 MB
32 More Charts & SUMIFS & AVERAGEIFS.flv 51 MB
33 IF AND OR Customer Credit Analysis.flv 61 MB
34 IF function Formula Payroll Formula.flv 26 MB
35 IF Function vs VLOOKUP Function.flv 20 MB
36 Array Formulas Basics.flv 77 MB
37 SUMPRODUCT function.flv 54 MB
38 Array Functions TRANSPOSE FREQUENCY.flv 16 MB
39 Forcing Functions to Become Arrays.flv 55 MB
40 VLOOKUP 11 Unusual Examples.flv 85 MB
41 HLOOKUP ROWS Horizontal Lookup.flv 5 MB
42 Versatile LOOKUP function 10 Examples.flv 65 MB
43 MATCH function.flv 17 MB
44 Basics of INDEX & MATCH functions.flv 52 MB
45 INDEX function & MATCH function 12 Unusual Examples.flv 100 MB
46 CHOOSE function 4 Examples.flv 26 MB
47 PMT function 5 Examples.flv 38 MB
48 Interest Rates 6 Examples.flv 44 MB
49 Spreadsheet to Compare Loans.flv 34 MB
50 Value Asset PV NPV & XNPV function.flv 31 MB
51 Life Time Savings Plan.flv 26 MB
52-1 Recorded Macro Basics.flv 58 MB
52-2 Macro Security.flv 7 MB
53 Relative & Absolute Macro Recorder.flv 60 MB
54 Excel VBA code From Internet.flv 33 MB

Array Formula series

01 Basics of Array Formulas.flv 27 MB
02 TRANSPOSE function.flv 7 MB
03 Expected Return for Stocks.flv 12 MB
04 Find Largest Improvement.flv 10 MB
05 SUM 3 Largest Values.flv 9 MB
06 Statistics Bayes' Theorem.flv 13 MB
07 Boolean Logic & Criteria.flv 33 MB
08 FREQUENCY function.flv 18 MB
09 Count Characters in Range.flv 6 MB
10 Amazing Syntax Array Trick.flv 17 MB
11 ROW & COLUMN functions.flv 16 MB
12 MMULT function Matrix Algebra.flv 8 MB
13 LINEST function.flv 34 MB
14-1 Stock Returns.flv 23 MB
14-2 Beginning Stock Analysis.flv 34 MB
14-3 Portfolio Standard Deviation.flv 34 MB
14-4 Stock Portfolio Analysis.flv 16 MB

01 What is Excel.flv 21 MB
02 Formulas and Math Operators.flv 26 MB
03 Math Order of Operations.flv 18 MB
04 the Importance of Formatting in Math.flv 22 MB
05 Functions & Formulas.flv 26 MB
06 Relative & Absolute Cell References.flv 8 MB
07 When ROUND function is Required.flv 11 MB
08 Whole. Decimal Numbers & Formatting.flv 27 MB
09 ROUNDING Numbers in Excel.flv 27 MB
10 Adding and Subtracting.flv 27 MB
11 Order of Operations for Math.flv 14 MB
12 Multiplying & Dividing in Excel.flv 35 MB
13 Math Word Problems #1.flv 32 MB
14 Math Word Problems #2.flv 17 MB
15 Large Math Word Problem.flv 26 MB
16 Fractions & Fraction Formatting.flv 38 MB
17 Primes & Reducing Fractions.flv 14 MB
18 Decimal into Fraction.flv 19 MB
19 Multiplying & Dividing Fractions.flv 14 MB
20 Adding & Subtracting Fractions.flv 36 MB
21 Fraction Word Problem.flv 21 MB
22 Convert Decimals & Fractions to Percent.flv 26 MB
23 Rules for Percents in Excel - Percentage.flv 12 MB
24 Fraction and Percent Equivalents.flv 16 MB
25 Part = Rate Base = Percent Formula.flv 22 MB
26 Solve for Part in Percent Formula.flv 18 MB
27 Solve for Base in Percent Formula.flv 17 MB
28 Solve for Rate in Percent Formula.flv 23 MB
29 Rate of Change Formulas.flv 26 MB
30 Rate of Change Business Problems.flv 25 MB
31 Increase & Decrease Math Problems.flv 35 MB
32 Markup & Markdown Math Problems.flv 16 MB
33 Stock Values Web Query & Rate of Change.flv 20 MB
34 Bank Checks.flv 35 MB
35 Check Accounts Service Charge & Balance.flv 47 MB
36 Bank Service Terms & Credit Card Calculations.flv 43 MB
37 Bank Reconciliation.flv 35 MB
38 Gross Pay and Overtime 5 Examples.flv 87 MB
39 Incentive Rate Formulas 8 Examples.flv 95 MB
40 Equivalent Earning Formulas 12 Examples.flv 19 MB
41 Payroll Deductions With Ceilings (FICA).flv 49 MB
42 Federal Income Tax Payroll Deduction.flv 69 MB
43 Invoices & Trade Discounts.flv 55 MB
44 Series Trade Discounts.flv 61 MB
45 Trade Discount Word Problem.flv 9 MB
46 Cash Discounts.flv 73 MB
47 Partial Invoice Payment w Discount.flv 9 MB
48 Basics of Markup (Cost & Selling).flv 36 MB
49 Markup On Cost.flv 30 MB
50 Markup On Selling Price.flv 27 MB
51 Convert Markups & Perishable Sell Price.flv 24 MB
52 Markup & Markdown.flv 15 MB
53 Simple Interest & Loans Notes.flv 77 MB
54 Simple Interest Part & Base & Rate.flv 15 MB
55 Simple Interest Discount Note.flv 27 MB
56 Compound Interest & Future Value.flv 78 MB
57 Future Value Calculations.flv 44 MB
58 Present Value Calculations.flv 25 MB
59 Annuities Math & Excel.flv 47 MB
60 Future Value Annuities FV & PMT function.flv 45 MB
61 Present Value Annuities PV & PMT function.flv 72 MB
62 Sinking Funds.flv 39 MB

Dynamic Charts

01 Hide-Unhide Rows.flv 8 MB
02 Filter & Sort Feature.flv 9 MB
03 Table Feature (Excel 2010, 2007) List Feature (Excel 2003).flv 9 MB
05 Dynamic Chart Labels using TEXT function and Ampersand &.flv 12 MB
06 PivotTable PivotChart.flv 11 MB
07 SUMIFS function.flv 20 MB
08 SUMPRODUCT function (Excel 2003 substitute for SUMIFS).flv 6 MB
09 4 Week Chart Dynamic Formula & Dynamic Data Validation Formula.flv 28 MB
10 OFFSET Function Dynamic Range.flv 35 MB
11 Dynamic Area Chart with IF Function - Normal Distribution Chart Statistics.flv 21 MB
12 INDEX function as Alternative to OFFSET function for Dynamic Ranges.flv 19 MB
13 Web Query Stock Percent of Target Chart.flv 11 MB
14 Progress Chart Linked to Stock Market (Stock Prices vs Target Sell Price).flv 12 MB
15 Array Formula & Table Nomenclature for Top 10 Wrestling Score Chart.flv 18 MB
16 Dynamic Average Hurdle Line for Bar Chart. Scatter and Bar Chart Together.flv 18 MB

Excel 2010 Preview

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

Finance Class

001 Intro to Excel 2007 & 2010.flv 32 MB
002 Getting Started with Formulas. Functions. Formula Inputs and Cell References.flv 50 MB
003 Math Operators and Order of Operations.flv 52 MB
004 the Importance of Number Formatting in Financial Calculations.flv 32 MB
005 Percent. Percent Change Increase Decrease Percentage Number Formatting.flv 26 MB
006 Relative and Absolute Cell References in Copied Formulas.flv 20 MB
007 Stylistic Formatting.flv 8 MB
008 Intro to Corporate Financial Management.flv 93 MB
009 Balance Sheet. Working Capital. Liquidity. Debt. Equity. Market Value.flv 68 MB
010 Income Statement. Non Cash Depreciation Expense. Matching Principal.flv 47 MB
011 Finance Cash Flow From Accounting Information.flv 85 MB
012 Cash Flow Advantage to Debt & Average and Marginal Tax Rates.flv 31 MB
013 Banks. Fundamental Problem With Banks. & the Big Short.flv 13 MB
014 Financial Statement Ratio Analysis - #1 Trick for Ratio Analysis.flv 69 MB
015 Common Sized Financial Statements.flv 31 MB
016 Liquidity. Current Ratio and How Current Ratio Can Be Manipulated.flv 34 MB
017 Leverage & Solvency Ratios Debt to Equity. Equity Multiplier. more.flv 46 MB
018-1 Asset Efficiency Ratio and Cash Cycle in Days.flv 41 MB
018-2 Ratios for Cash Cycle in Days.flv 19 MB
019 Profitablility Rations Return On Equity & Return On Assets & DuPont Analysis.flv 35 MB
020 Growth Ratios and Market Value Ratios.flv 30 MB
021 Future Value Lump Sum Calculations. Simple & Compound Interest.flv 63 MB
022 Present Value Lump Sum Calculations and PV Function.flv 36 MB
023 Solve for Total Number of Periods When You Know PV. FV and Period Rate.flv 11 MB
024 Solve for Period Rate & Annual Rate When You Know PV. FV and # of Periods.flv 26 MB
025 Future Value for Lender or Borrower.flv 9 MB
026 Multiple Cash Flow Valuation Future Value and Present Value FV PV Functions.flv 42 MB
027 Asset Valuation Using Discounted Cash Flow Analysis and PV Function.flv 16 MB
028 Relationship Between APR. Period Rate and Effective Annual Rate.flv 40 MB
029 Calculate Future Value of An Annuity (FV Function).flv 36 MB
030 Future Value for Interest Paid Daily. But Deposits Made Monthly.flv 13 MB
031 Calculate PMT for Future Value of Annuity (PMT Function).flv 15 MB
032 Calculate Present Value of Annuity (PV Function).flv 22 MB
033 Full Life Retirement Plan PV Annuity & FV Annuity PV & PMT Functions.flv 21 MB
034 Present Value of Annuity for Asset Valuation.flv 7 MB
035 Calculate PMT for Present Value of Annuity PMT Function for Loan Payment.flv 5 MB
036 PMT Function 7 Examples & Adjusted APR with Points and RATE function.flv 39 MB
037 How Much Do I Get Each Month During Retirement.flv 7 MB
038 Calculate APR and EAR Given Cash Flows From Annuity.flv 5 MB
039 How Long to Pay Off Credit Card With Minimum Payment.flv 6 MB
040 Perpetuity (consol) Preferred Stock Valuation Formula.flv 6 MB
041 Interest Only Loan Schedule.flv 3 MB
042 Consumer Amortized Loans.flv 18 MB
043 Business 0Amortized Loans.flv 7 MB
044 Deep Discount Loans.flv 12 MB
045 Interest Rates Real. Nominal. Inflation and the Fisher Effect.flv 37 MB
046 Bonds Just A Set of Cash Flows Discounted at Market Rate - Coupon or Zero.flv 63 MB
047 Selling Bond When Coupon Rate is Different Than Discount Rate (YTM Rate).flv 17 MB
048 Calculate YTM and Effective Annual Yield From Bond Cash Flows RATE & EFFECT.flv 7 MB
049 Bond Quoted Price & Yield to Market.flv 11 MB
050 Bond Rates are Inversely Related to Bond Price (Scatter Diagram Excel Chart).flv 16 MB
051 Par - Discount - Premium Bonds.flv 20 MB
052 Bond Discount or Premium Amortization Table.flv 14 MB
053 Bond Discount or Premium Journal Entries.flv 19 MB
054 Bonds & Interest Rate Risk.flv 23 MB
055 Tax Advantage of Muni Bond.flv 7 MB
056 Tax Implications for Zero Coupon Bonds.flv 18 MB
057 Compare Cash Flows for a Coupon & A Zero Coupon Bond.flv 27 MB
058 After Tax Cash Flows & After Tax Interest Rates.flv 14 MB
059 Common & Preferred Stock.flv 39 MB
060 Basics of Financial Markets.flv 37 MB
061 Stock Value Based on Present Value of Future Dividend Cash Flows.flv 18 MB
062 Preferred Stock Valuation as A Perpetuity.flv 7 MB
063 Stock Valuation with Dividend Growth Model.flv 10 MB
064 Chart How Stock Value Changes for Dividend Growth Model as Inputs Change.flv 18 MB
065 Calculate Stock Price at Time t using Dividend Growth Model.flv 13 MB
066 Calculate Implied Return using Dividend Growth Model.flv 8 MB
067 Irregular Dividend Payments. Followed by Constant Growth -- Stock Valuation.flv 29 MB
068 Net Present Value. NPV Excel Function & Capital Budgeting.flv 38 MB
069 Net Present Value Profile -- Build Table and Chart in Excel NPV Function.flv 44 MB
070 Investment Criteria Net Present Value.flv 7 MB
071 Investment Criteria Payback Rule.flv 23 MB
072 Investment Criteria Average Accounting Return.flv 21 MB
073 Investment Criteria Internal Rate of Return IRR Function Plot Chart.flv 50 MB
074 IRR and Non-conventional Cash Flows. Plot Chart to See Multiple IRR.flv 16 MB
075 IRR and Mutually Exclusive Projects - Plot Chart to See Cross 0Over Rate.flv 23 MB
076 Investment Criteria MIRR - Modified Internal Rate of Return.flv 19 MB
077 Investment Criteria Profitability Index.flv 5 MB
078 NPV for Irregular Cash Flows and Time Periods XNPV. NPV and PV functions.flv 15 MB
079 Investment Criteria NPV. IRR. Payback. AAR. Profitability Index.flv 18 MB
080 Recognizing Patterns of Cash Flows for Discounted Cash Flow Analysis.flv 16 MB
081 XNPV Function XIRR Function - See Algorithm That XNPV uses.flv 33 MB
082 Relevant Costs for Discounted Cash Flow Analysis = Incremental Cash Flows.flv 40 MB
083 Estimating Cash Flows for NPV calculation.flv 34 MB
084 Undoing Accrual Accounting to Discover Cash Flows for Estimating NPV.flv 17 MB
085 MACRS Depreciation & Asset Sale Impacts on NPV Cash Flows.flv 24 MB
086 Estimating Cash Flows for NPV calculation Comprehensive Example.flv 53 MB
087 Cost Savings Example Estimating Cash Flows for NPV calculation.flv 17 MB
088 Scenario Analysis for Cash Flow & NPV Calculations.flv 35 MB
089 Sensitivity Analysis for Cash Flow & NPV Calculations.flv 27 MB
090 Period (Holding) Returns for Stock.flv 13 MB
091 Period (Holding) Nominal. Real & Dollar Returns for Coupon Bond.flv 9 MB
092 Period (Holding) Returns for Zero Bond.flv 8 MB
093 Period (Holding) Returns for Preferred Stock.flv 5 MB
094 Period (Holding) Returns for Less 0Than 1 Year. APR and EAR.flv 9 MB
095 Using Past Period Holding Returns to Estimate Future Returns Arithmetic Mean.flv 8 MB
096 Comparing Geometric Mean with Arithmetic Mean for Average Stock Returns.flv 34 MB
097 Using Geometric Mean & Arithmetic Mean to Estimate Future Returns.flv 8 MB
098 Stock Return Variation Measured with Standard Deviation (Risk of Stock).flv 25 MB
099 US Capital Market History 5 Types Investments (2 Good Lessons).flv 50 MB
100 Real Rate and Inflation or Deflation for T-bills.flv 8 MB
101 Average Real Return for A Stock Based On Historical Data.flv 7 MB
102 in the Short Run Financial Markets Can Be Inefficient Mispriced Assets.flv 12 MB
103 2 Ways to Calculate Geometric Mean.flv 12 MB
104 Expected Return & Standard Deviation for 1 Stock -- Estimating Future.flv 25 MB
105 Expected Return & Standard Deviation for Portfolio -- Estimating Future.flv 23 MB
106 Unexpected Information. Market & Asset Specific Risk. Diversification. Beta.flv 30 MB
107 Calculating Beta (2 Methods) & Chart Beta. SLOPE CORREL & STDEV functions.flv 27 MB
108 Reward to Risk Ratio - Treynor Index.flv 13 MB
109 Beta for Portfolio.flv 8 MB
110 Security Market Line (SML) & Capital Asset Pricing Model (CAPM).flv 18 MB
111 Treynor Index & CAPM.flv 6 MB

Finance Tricks

01 FV PV & Time Value of Money.flv 16 MB
02 Simple & Compound Interest.flv 36 MB
03 PMT function Lender or Borrower.flv 31 MB
04 PMT function & Balloon payment.flv 11 MB
05 PMT & FV function & Delayed Payments.flv 22 MB
06 RATE function and Loan Points.flv 14 MB
07 EFFECT function (EAR Rate).flv 8 MB
08 Complete Loan Analysis.flv 35 MB
09 Daily Interest But Monthly Deposits!.flv 14 MB
10 Interest Rate for Pay Day Loans.flv 20 MB
11 How Long Pay Off Credit Card Balance.flv 11 MB
12 SLN & DDB Depreciation functions.flv 12 MB
13 PV function Capital Invest Decision.flv 12 MB
14 NPV function Capital Invest Decision.flv 11 MB
15 PV & NPV don't work XNPV function.flv 19 MB
16 Work Life & Retirement Finance.flv 28 MB
17 Amortization Table w x Column.flv 35 MB
18 CUMIPMT function for Interest.flv 28 MB

Formula Efficiency

01 SUMPRODUCT function 12 Examples.flv 26 MB
02 Time Your Formulas for Speed.flv 19 MB
03 Database D Functions are Fast.flv 30 MB
04 SUMIFS & COUNTIFS are Fast.flv 22 MB
05 Helper Cell Speed Up Calculation.flv 11 MB
06 Concatenated Field Speeds Up Formula.flv 19 MB
07 Helper Column Speeds Calculation.flv 18 MB
08 Custom VBA Function Can Be Fast.flv 9 MB
09 Faster Running Total Formula.flv 6 MB
10 Automatic & Manual Calculation.flv 9 MB
11 Pivot Table Faster Than Formula.flv 20 MB
12 Fastest Formula in Excel.flv 17 MB

Law Class

1 Create Comparative Budget - Jessica's Law Class.flv 95 MB
2 Child Support Payments Template - Jessica's Law Class.flv 20 MB
3 Statistics for Age Discrimination Case - Jessica's Law Class.flv 33 MB

Lookup series

01 VLOOKUP Function 1st Example.flv 26 MB
02 VLOOKUP Function 2nd Example.flv 19 MB
03 VLOOKUP Function 3rd Example.flv 12 MB
04 PART 1 VLOOKUP Function 4th Example.flv 31 MB
04 PART 2 VLOOKUP Function 4th Example.flv 17 MB
05 VLOOKUP Function 5th Example.flv 29 MB
06 HLOOKUP Function.flv 13 MB
07 LOOKUP Function.flv 24 MB
08 MATCH Function.flv 14 MB
09 INDEX function 1st Example.flv 11 MB
10 INDEX function 2nd Example.flv 13 MB
11 INDEX & MATCH functions Two 2 Way Lookup.flv 16 MB
12 INDEX & MATCH functions Example 2!.flv 16 MB
13 INDEX & MATCH functions Example 3!.flv 37 MB
14 CHOOSE function.flv 13 MB

MrExcel & ExcelIsFun friendly challenge

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

Name Tricks

01 Names in Excel 2003 & 2007.flv 30 MB
02 Names for Go to Quick Navigation.flv 7 MB
03 Names in Formulas and Functions.flv 24 MB
04 Names & Quick Formula Creation.flv 9 MB
05 Names for Pivot Tables & more.flv 23 MB
06 Names COUNTIF & wildcards.flv 23 MB
07 INDIRECT function. Names and LOOKUP.flv 17 MB
08 Names Relative Cell Reference for Sheet.flv 16 MB
09 Create Name Formulas.flv 33 MB
10 Store Lookup Tables in Memory.flv 20 MB
11 Global Percentage Change Formula.flv 17 MB
12-1 F2 Key and Apply Names.flv 24 MB
12-2 Names & Excel 2007 Tables.flv 10 MB
12-3 Paste Name List.flv 4 MB

Statistics

01 Intro to Excel 2007 for Statistics.flv 33 MB
02 Calculations. Operators. Formulas.flv 34 MB
03 Data Analysis Sorting & Pivot Tables.flv 33 MB
04 Frequency Pivot Table Chart Basics.flv 34 MB
05 Cell References in Formulas.flv 31 MB
06 Don't get tricked by Number Formatting.flv 34 MB
07 Calculate Proportions and Percentages.flv 15 MB
08 Install Excel 2007 Data Analysis Add-in.flv 9 MB
09 What is Statistics.flv 45 MB
10 Data & ScalesLevels of Measurement.flv 35 MB
11 Descriptive & Inferential Statistics.flv 34 MB
12 Categorical Frequency Distribution w Formulas.flv 36 MB
13 Column Chart From Frequency Distribution.flv 25 MB
14 Categorical Relative & Percent Freq. Dist. w Formulas.flv 27 MB
15 Category Frequency Distribution w Pivot Table & Pie Chart.flv 34 MB
16 Categorical Cross Tabulation with Pivot Table.flv 26 MB
17 Categorical Cross Tabulation with Formulas.flv 32 MB
18 Pareto Chart for Categorical Data See how to create.flv 28 MB
19 Grouping Categories w Formula & Pivot Table.flv 22 MB
20 P1 Quantitative Freq. Dist. w Formulas.flv 34 MB
21 P2 Quantitative Freq. Dist. w Formulas.flv 33 MB
22 Histogram & Ogive Charts & % Cumulative Frequency.flv 37 MB
23 Skew in Histograms.flv 13 MB
24 Quantitative Freq. Dist. w Pivot Table.flv 33 MB
25 % Freq. Dist.& Histogram w Pivot Table.flv 33 MB
26 Cumulative Freq. Dist w Pivot Table (Running Total).flv 28 MB
27 Dot Plot Chart w REPT & COUNTIF functions.flv 30 MB
28 Stem & Leaf Chart w REPT & COUNTIF functions.flv 25 MB
29 Quantitative Cross Tabulation W Pivot Table.flv 20 MB
30 Scatter Diagram for 2 Quantitative Variables.flv 23 MB
31 Histogram using Data Analysis Add-in.flv 20 MB
32 Frequency Distribution Summary (Pivot Table & Formula).flv 60 MB
33 Measures of Location.flv 44 MB
34 MEAN. MEDIAN. MODE (Averages).flv 30 MB
35 Weighted Mean & Geometric Mean.flv 34 MB
35.2 Geometric Average V Arithmetic Mean - Finance Example.flv 21 MB
36 Trimmed Mean.flv 13 MB
37 PERCENTILE & QUARTILE.flv 24 MB
38 Data Analysis Add-in Rank & Percentile.flv 22 MB
39 Variability Chart - Visual Approach (Dispersion or Spread).flv 19 MB
40 Range & Interquartile Range (Variability).flv 13 MB
41 Sample Standard Deviation (Variability).flv 49 MB
42 Coefficient of Variation.flv 14 MB
43 Data Analysis Add-in Descriptive Statistics.flv 6 MB
44 Skew & SKEW function.flv 25 MB
45 Z-Score (# Standard Deviations From Mean).flv 16 MB
46 Chebyshev's Theorem.flv 25 MB
47 Empirical Rule (Bell Shaped Curve).flv 41 MB
48 Empirical Rule vs Chebyshev's Theorem.flv 9 MB
49 Outliers & Box Plot with Median and Mean.flv 52 MB
50 Probability Basics (by hand notes).flv 53 MB
51 Probability Basics with Excel.flv 66 MB
52 Probability Laws (by hand notes).flv 34 MB
53 Probability Laws with Excel.flv 27 MB
54 Joint Probability Table and More!.flv 29 MB
55 Probability Pivot Table.flv 22 MB
55.5 Bayes Theorem Posterior Probabilities.flv 8 MB
56 Discrete Probability Distributions (Basics).flv 35 MB
57 Build Discrete Probability Distribution & Chart.flv 61 MB
58 Discrete Probability Chart with 2 Data Sets.flv 15 MB
59 Discrete Probability Mean & Standard Deviation SUMPRODUCT function.flv 45 MB
60 Budget Income Statement (Probability) SUMPRODUCT function.flv 14 MB
61 Stock Expected Return & Standard Deviation (Probability).flv 14 MB
62 Binomial Experiments & Probabilities.flv 54 MB
63 BINOMDIST & Mean & Standard Deviation for Binomial Probability Distribution.flv 26 MB
64 Cumulative BINOMDIST with IF Function for Cumulative Distribution Charts.flv 24 MB
65 POISSON function Poisson Probability Distribution.flv 25 MB
66 Continuous Probability Distributions (Normal. Uniform. Exponential).flv 36 MB
67 Uniform Probability Distributions.flv 33 MB
68 Normal (Bell) & Standard Normal Characteristics.flv 28 MB
69 #1 Normal Probability Excel Functions & Area Charts.flv 40 MB
70 #2 Normal Probability Excel Functions & Area Charts.flv 49 MB
71 #3 Normal Probability Excel Functions & Area Charts.flv 30 MB
72 Find X Given Normal Probabilities NORMINV & NORMSINV functions.flv 11 MB
73 Exponential Probability EXPONDIST function.flv 22 MB
74 Taking a Sample with RAND & VLOOKUP.flv 35 MB
75 Point Estimates & Sample Error.flv 36 MB
76 Sampling Distribution of Sample Mean & Central Limit Theorem.flv 56 MB
77 Probabilities for Sampling Distribution of Sample Mean.flv 31 MB
78 Relationship Standard Error & Sample Size.flv 12 MB
79 Proportions Sampling Distribution.flv 20 MB
80 Confidence Interval Sigma Known.flv 59 MB
81 Confidence Interval Sigma Known From Raw Data.flv 23 MB
82 Confidence Interval Sigma Not Known TINV function.flv 28 MB
83 Confidence Interval for Advertising TINV function.flv 12 MB
84 Confidence Interval Data Analysis Add-in Descriptive Statistics.flv 17 MB
85 Confidence Intervals for Proportions #1.flv 22 MB
86 Confidence Intervals for Proportions #2.flv 12 MB
87 Sample Size for Confidence Intervals.flv 19 MB
88 Confidence Interval & Hypothesis Tests.flv 96 MB
89 Hypothesis Testing With Critical Value & p-value.flv 77 MB
90 NORMSINV for Critical Value NORMSDIST for P-value 6 examples.flv 16 MB
91 TINV & TDIST functions for Critical Value and P-value 6 examples.flv 25 MB
92 Hypothesis Test T Distribution.flv 16 MB
93 Hypothesis Test Proportions.flv 17 MB

Buy Premium To Support Me & Get Resumable Support & Max Speed

Site BBcode/HTML Code:
Dear visitor, you went to the site as unregistered user.