Excel Saga 26 (23) Eng Dub [HQ]
Going Too Far
Excel Magic Trick 167p1 IF function formula: 12 Examples!
Part 1. See 12 different examples of how to use the IF function. This video starts with IF function basics and then shows 12 different examples of how the IF function can be used in formulas. Also see these functions: AND, OR, SUM, AVEARAGE, STDEVP, and VLOOKUP. See how to use the IF function to put: 1 of 2 numbers in a cell or formula. 1 of 2 words in a cell or formula. 1 of 2 text strings in a cell or formula. 1 of 2 formulas in a cell or formula. 1 of 2 functions in a cell [...]
Categories: Excel Tags: AVEARAGE, formula 1, function, Gantt, gantt chart, Ifs, magic trick, Nested, Part, STDEVP, SUM, text strings, video, vlookup function, vlookup in excel, YouTube
The Website is Down #2: Excel Hell
The Website is Down episode number two! Chip takes us on a wild ride into the life of a master salesman. How many sales can he make in a single video? One? Maybe?
Excel Basics #11: Spreadsheet Setup & Cell References
The Excel Basics Series shows a systematic description of what Excel can do from beginning to end. #11 Video topics: 1)Mixed Cell References, Assumption Table Orientation, Range Functions and Inserting columns 2)Mixed Cell References in Formulas and the orientation of the Input Values 3)Formula Input Value setup is critical for efficient formula creation 4)The beauty of Excel is illustrated in this video: Amazing Efficiency example 5)Spreadsheet set up leads to time saved
Categories: Excel Tags: Amazing, amp, assumption, Basics, beauty, Cell, cell references, creation, description, efficiency, input value, References, spreadsheet setup, systematic description, table, table orientation, Time
Excel Basics #8: Cell References Relative & Absolute
The Excel Basics Series shows a systematic description of what Excel can do from beginning to end. #8 Video topics: 1)Cell references in formulas 2)F4 key to select the type of cell reference 3)Relative Cell Reference 4)Absolute Cell Reference 5)Mixed Cell Reference with column locked (Absolute Column) 6)Mixed Cell Reference with row locked (Absolute Row) 7)Fill handle double click trick for copying 8)Ctrl + Enter keyboard shortcut for entering many formulas at once 9)Formula for Percentage 10)Formula for periodic increase (increase each successive amount by 10%) 11)Formula function for Future Value
Categories: Excel Tags: amount, amp, Basics, Cell, cell references, click, description, double click, function, future value, keyboard shortcut, Percentage, References, relative cell reference, shortcut, systematic description, type
Normal Distribution Excel Exercise
(Long-26 minutes) Presentation on spreadsheet to show that the normal distribution approximates the binomial distribution for a large number of trials.
Categories: Excel Tags: binomial, binomial distribution, Distribution, Excel, exercise, Long, Normal, normal distribution, number, presentation, spreadsheet
Excel Basics #5: Formulas Operators and Math
The Excel Basics Series shows a systematic description of what Excel can do from beginning to end. #5 Video topics: 1)Excel operator symbols 2)Parenthesis is () 3)Exponent is ^ 4)Multiplication is * 5)Division is 6)Adding is + 7)Subtracting is 8)Order of Operations 9)Complete list of how Excel Evaluates formulas 10)Excel 2003: Formula Evaluator: Tools, Formula Auditing, Formula Auditing 11)Excel 2007: Formula Evaluator: Formula Ribbon, Formula Auditing group, Formula Auditing icon
Categories: Excel Tags: auditing, Basics, complete list, description, Evaluator, Exponent, group formula, Math, Multiplication, Operations, Operators, order, order of operations, Ribbon, Subtracting, systematic description
Excel Basics #4: Formulas and Functions
The Excel Basics Series shows a systematic description of what Excel can do from beginning to end. #4 Video topics: 1)Formulas with cell references 2)Formula efficiency rule: Numbers that can change go in cells and numbers that do not change can be typed into cells 3)Formulas with cell references operators and parenthesis 4)Formula for Effective Annual Interest Rate 5)How to find Excel functions to use in formulas 6)Search for Excel functions 7)EFFECT function 8)Formula for month interest rate 9)Formula for total number of periods 10)Formula for monthly payment on a loan using the PMT function 11)Formula for text string that [...]
Categories: Excel Tags: Basics, cell references, Cells, description, DOLLAR, efficiency, excel functions, function, interest, interest rate, periods, PMT, pmt function, quotes, rate, rule, rule numbers, search, systematic description, text string, use
(HD) Pivot Tables (PivotTable) in Excel 2007 (including compatibility mode) and basic PivotChart
This video shows how to create a PivotTable in Excel 2007. It covers the regular mode as well as compatibility mode (ie Excel 2003 .xls format). Microsoft has made it extremely intuitive to create PivotTables and PivotCharts in this version of Excel. Due to time constraints, a very basic PivotChart example was shown. A more detailed video will follow.
Categories: Excel Tags: compatibility, compatibility mode, format, hd, Microsoft, mode, Pivot, pivot tables, PivotChart, PivotCharts, PivotTable, pivottables, Time, time constraints, version, xls
Easy Way to Make a Graph on Excel FROM SCRATCH – Excel 2007
A fast and easy to follow tutorial on how to make a good looking graph on Microsoft Excel 2007. Example: Scatter plot With bullets and straight lines Line of Best Fit Graph Title Axis Titles Comment, rate, and SUBSCRIBE! ^ ^ ^ ^ ^ | | | | | | | | | | -pH-
Read more...
1,415 comments - What do you think?
Posted by zdhnsu - December 12, 2010 at 1:02 pm
Categories: Excel Tags: Axis, bullets, Comment, example, graph title, Microsoft, microsoft excel, plot, rate, scatter plot, SCRATCH, straight lines, SUBSCRIBE, title, Tutorial