Copy the link of the video page and paste it here:
Example: http://www.youtube.com/watch?v=a7FQPMiph9M
NEW!. You can download videos from Vimeo!. :-)
Utils:
 |
Excel Magic Trick # 254: Data Table Creates 100 Formulas By ExcelIsFun See how to create a Contribution Margin Income Statement Analysis across various units using a 1 Variable Data Table (What if analysis). See how to create 5 columns of different formulas quickly using the Data Table feature in Excel. See how to create a break even analysis X Y Scatter diagram Chart in Excel based on Contribution Margin Analysis with Sales, Variable Costs and Fixed Costs. See how to create Conditional Formatting For A Row. See how to set up a spreadsheet efficiently with an assumption table for input values. Other What If Analysis videos: Excel Magic Trick 253: Data Table 1 Variable What If Analysis Excel Magic Trick # 254: Data Table Creates 100 Formulas Excel Magic Trick 255: Data Table 2 Variable What If Analysis YTLE#103: Excel Goal Seek Highline Excel Class 22: Scenarios & Scenarios Report This is a beginning to advanced Excel class taught at Highline Community College by Mike Gel excelisfun Girvin Busn 214 BTech 109 Tags: analysis, chart, college, community, contribution, data, excel, gel, girvin, highline, if, margin, mike, one, table, variable, what 1 Downloads - Last from: http://downthisvideo.com/tag/video (Your Blog here!) |
 |
Excel Statistics 66: Continuous Probability Distributions (Normal, Uniform, Exponential) By ExcelIsFun Topics for Continuous Probability Distributions:: 1.Compare Discrete and Continuous Probability Distributions 2.See charts for Continuous Probability Distributions: Uniform, Normal (Bell), Standard Normal, Exponential 3.Learn that you cannot calculate a probability for exactly x with a Continuous Random Variable (exactly x = 0) 4.Learn that we will be calculating the probability that an event occurs between 2 x values 5.Learn the Probability = Area for Continuous Probability Distributions 6.Lines have no area Busn 210 Business Statistical Using Excel Highline Community College taught by Mike Gel excelisfun Girvin Tags: 2007, bell, college, community, continuous, distributions, excel, excelisfun, exponential, gel, girvin, highline, mike, normal, probability, statistics, uniform 1 Downloads - Last from: http://downthisvideo.com/ (Your Blog here!) |
 |
Excel Dynamic Chart #11: Dynamic Area Chart with IF Function - Normal Distribution Chart Statistics By ExcelIsFun See how to use the IF function in a column to create a dynamic range for an area chart. Statistics Normal Distribution Area Chart with X values. Standard Normal Distribution Area Chart Probability Theory Statistics. Tags: area, chart, college, community, distribution, dynamic, excel, excelisfun, function, gel, girvin, highline, if, mike, normal, pro..., standard, statistics, with 1 Downloads - Last from: http://downthisvideo.com/ (Your Blog here!) |
 |
Excel Magic Trick #22: NORMDIST function for Probability By ExcelIsFun See how to use the NORMDIST function to calculate probabilities for a population with a normal (bell) distribution! You even get to see the four types of situations that you most commonly encounter -- plus visual pictures of each situation to help with the concept! Tags: bell, college, community, distribution, excel, function, gel, girvin, highline, mike, normal, normdist, probability, spreadsheets, statistics 1 Downloads - Last from: http://downthisvideo.com/ (Your Blog here!) |
 |
Excel Statistics 91: TINV & TDIST functions for Critical Value and P-value 6 examples By ExcelIsFun How to use TINV and TDIST functions. See 6 examples of T functions for Critical Value and P-value for Hypothesis Testing for Mean with population standard deviation NOT known. Busn 210 Business Statistical Using Excel Highline Community College taught by Mike Gel excelisfun Girvin Tags: 2007, and, college, community, excel, excelisfun, functions, gel, girvin, highline, how, hypothesis, mike, statistics, tdist, testing, tests, tinv, to, use 1 Downloads - Last from: http://downthisvideo.com/ (Your Blog here!) |
 |
Excel Magic Trick 376: Stem & Leaf Chart for Big Numbers By ExcelIsFun See how to to create an array formula for a Stem and Leaf Chart for numbers that have more than two digits. See the functions: IF, COLUMNS, SUMPRODUCT, LEFT, RIGHT, FIXED, INDEX, SMALL, ROW and the ampersand with two doule quotes (blank) to convert a number to a number as text. Also see: Excel Statistics 28: Stem & Leaf Chart w REPT & COUNTIF functions Tags: and, array, basic, chart, college, community, excel, excelisfun, formula, gel, girvin, highline, leaf, mike, statistics, stem 1 Downloads - Last from: http://downthisvideo.com/ (Your Blog here!) |
 |
Excel Statistics 76: Sampling Distribution Of Sample Mean & Central Limit Theorem By ExcelIsFun Topics for: 1.Learn how to construct a Sampling Distribution Of Sample Mean 2.See that Population Mean = Mean of all Sample Means 3.See how to calculate the Standard Error = Standard Deviation for the Sampling Distribution Of Sample Mean 4.See that the Sampling Distribution Of Sample Mean has a normal Bell Curve 5.Learn about the Central Limit Theorem 6.See the relationship between n and the Standard Error and the shape of the Sampling Distribution Of Sample Mean Busn 210 Business Statistical Using Excel Highline Community College taught by Mike Gel excelisfun Girvin Tags: 2007, central, college, community, distribution, excel, excelisfun, gel, girvin, highline, limit, mean, mike, sample, sampling, statistics, theorem 1 Downloads - Last from: http://downthisvideo.com/ (Your Blog here!) |
 |
Excel Statistics 62: Binomial Experiments & Probabilities By ExcelIsFun Learn all about the BINOMDIST Excel function for calculating a Binomial probability. Learn about the 4 requirements for a Binomial Experiment. See how to use the COMBIN function to calculate the number of successes, x, in n, number of trials. See how to calculate probabilities using multiplying and adding rules then see the binomial formulas to calculate probabilities for a binomial experiment. Tags: 2007, binomdist, binomial, chart, college, column, community, excel, excelisfun, experiments, function, gel, girvin, highline, mike, probabilities, statistics 1 Downloads - Last from: http://downthisvideo.com/ (Your Blog here!) |
 |
Excel Statistics 74: Taking a Sample with RAND & VLOOKUP By ExcelIsFun See how to take a Simple Random Sample using the RAND and VLOOKUP functions Busn 210 Business Statistical Using Excel Highline Community College taught by Mike Gel excelisfun Girvin Tags: 2007, college, community, excel, excelisfun, gel, girvin, highline, mike, rand, random, sample, simple, statistics, taking, vlookup, with 1 Downloads - Last from: http://downthisvideo.com/ (Your Blog here!) |
 |
Excel Statistics 52: Probability Laws (by hand notes) By ExcelIsFun Learn these Probability Laws: 1.Venn Diagram 2.Complement Rule 3.Mutually Exclusive 4.Union 5.Intersection 6.Addition Law for Probability & Addition Law for Probability for Mutually Exclusive 7.Conditional Probability 8.Joint Probability 9.Joint Probability Table 10.Independence & Dependence 11.Multiplication Law for Probability 12.Multiplication Law for Probability for Independence 13.Calculating Conditional Probability Tags: 2007, adding, college, community, excel, excelisfun, gel, girvin, highline, laws, mike, multiplication, probability, statistics 1 Downloads - Last from: http://downthisvideo.com/ (Your Blog here!) |
 |
Excel Statistics 50: Probability Basics (by hand notes) By ExcelIsFun Learn the basics of probability: 1.Probability 2.Experiment & Experimental Outcomes 3.Sample Point (Experimental Outcome) 4.Sample Space 5.Multi-step Experiment 6.Tree Diagram 7.Counting Rule for Multi-step Experiment 8.Combinations 9.Permutations 10.Methods of Assigning Probabilities 11.Classical Method 12.Relative Frequency Method & Law of Large Numbers 13.Subjective Method 14.Requirements for Assigning Probabilities 15.Event 16.Probability of an Event 17.P(S) =1 18.Calculating Probability for Classical Method Tags: 2007, basics, college, combinations, community, diagram, excel, excelisfun, gel, girvin, highline, mike, probability, statistics, tree 1 Downloads - Last from: http://downthisvideo.com/ (Your Blog here!) |
 |
Excel Statistics 51: Probability Basics with Excel By ExcelIsFun Learn the basics of probability: 1.Probability 2.Experiment & Experimental Outcomes 3.Sample Point (Experimental Outcome) 4.Sample Space 5.Multi-step Experiment 6.Tree Diagram 7.Counting Rule for Multi-step Experiment 8.Combinations 9.Permutations 10.Methods of Assigning Probabilities 11.Classical Method 12.Relative Frequency Method & Law of Large Numbers 13.Subjective Method 14.Requirements for Assigning Probabilities 15.Event 16.Probability of an Event 17.P(S) =1 18.Calculating Probability for Classical Method Tags: 2007, basics, college, combinations, community, excel, excelisfun, gel, girvin, highline, mike, permutations, probability, statistics 2 Downloads - Last from: (Your Blog here!) |
 |
Excel Statistics 53: Probability Laws with Excel By ExcelIsFun Learn these Probability Laws: 1.Venn Diagram 2.Complement Rule 3.Mutually Exclusive 4.Union 5.Intersection 6.Addition Law for Probability & Addition Law for Probability for Mutually Exclusive 7.Conditional Probability 8.Joint Probability 9.Joint Probability Table 10.Independence & Dependence 11.Multiplication Law for Probability 12.Multiplication Law for Probability for Independence 13.Calculating Conditional Probability Tags: 2007, adding, college, community, excel, excelisfun, gel, girvin, highline, laws, mike, multiplication, probability, statistics 1 Downloads - Last from: http://downthisvideo.com/ (Your Blog here!) |
 |
Excel Statistics 57: Build Discrete Probability Distribution & Chart By ExcelIsFun Topics for Discrete Probability Distributions: 1.Define Random Variable 2.Build Frequency Distribution 3.Calculate Relative Frequency -P(x) f(x) 4.Check Requirement #1: Probability Greater Than Or Equal To Zero 5.Check Requirement #2: Sum of Probabilities Equal to One 6.Create a Column Chart for a Discrete Variable (Columns do not touch) 7.Link chart elements to cells 8.SUMIF function for adding probabilities 9.Make predictions Calculate Probabilities Tags: 2007, build, college, community, discrete, distributions, excel, excelisfun, gel, girvin, highline, mike, probability, statistics 1 Downloads - Last from: http://downthisvideo.com/ (Your Blog here!) |
 |
Excel Statistics 56: Discrete Probability Distributions (Basics) By ExcelIsFun Topics for Discrete Probability Distributions:: 1.Discrete Random Variables vs. Continuous Radom Variables 2.Discrete Probability Distributions 3.Discrete Probability Functions 4.Requirements for Discrete Probability Distributions 5.Adding Probabilities from a Discrete Probability Distributions Tags: 2007, college, community, discrete, distributions, excel, excelisfun, gel, girvin, highline, mike, probability, statistics 1 Downloads - Last from: http://downthisvideo.com/ (Your Blog here!) |
 |
YTLE#106: Alternatives To Pivot Tables - Excel By ExcelIsFun In Excel, see two alternatives to the Pivot Table: 1) Advanced Filter & SUMIF function and 2) Consolidation. Conditional Formatting Does Not Work With Pivot Tables if you Pivot! Tags: advanced, college, community, consolidation, excel, filter, function, gel, girvin, highline, mike, pivot, sumif, table 1 Downloads - Last from: http://downthisvideo.com/ (Your Blog here!) |
 |
Excel Magic Tricks # 1: Formulas & Cell References By ExcelIsFun See Excel Magic! See how to build your spreadsheet smartly, so it updates automatically. See how to create formulas with cell references! Tags: 2003, 2007, budget, cell, college, community, excel, formula, functions, gel, girvin, highline, keyboard, math, mike, reference, shortcu 1 Downloads - Last from: (Your Blog here!) |
 |
Excel Basics #23: VLOOKUP function formula By ExcelIsFun The Excel Basics Series shows a systematic description of what Excel can do from beginning to end. #23 Video topics: 1)VLOOKUP function formula 2)Data Validation List 3)VLOOKUP for Exact Match 4)VLOOKUP for Approximate Match 5)Lookup Product Price: Exact Match 6)Lookup Tax Amount: Approximate Match Also see these videos: Excel Lookup Series #1: VLOOKUP Function 1st Example Excel Lookup Series #2: VLOOKUP Function 2nd Example Tags: college, community, data, excel, formula, function, gel, girvin, highline, list, mike, or, price, product, tax, validation, vlookup 1 Downloads - Last from: (Your Blog here!) |
 |
Excel Magic Trick #31.5 IF, Data Validation, SUMIF By ExcelIsFun Checkbook Register Magic: See how to use the IF function, Data Validation and SUMIF to make an amazing Checkbook Register that automatically reconciles your Bank Account! IF function to turn formulas on and off by checking to see whether or not a cell is blank. Data Validation to allow only negative numbers in 1 column and only the reconciling symbol "y" in another column SUMIF to automatically reconcile the bank account to see what the Bank balance should be! Tags: bank, checkbook, college, community, data, excel, function, gel, girvin, highline, if, mike, reconciling, register, sumif, validation 1 Downloads - Last from: (Your Blog here!) |
 |
Excel Magic Trick #60: Charts: Line & X Y Scatter By ExcelIsFun Learn when to use the Line chart and when to use an X-Y Scatter diagram. See the difference between the Line and the X-Y Scatter diagram Charts. Line is for 1 number and a label. X-Y Scatter diagram is for 2 numbers. X-Y Scatter diagram Chart Line Chart Tags: chart, charts, college, community, diagram, excel, gel, girvin, highline, line, mike, scatter, type 2 Downloads - Last from: (Your Blog here!) |
| 