Video scenes shots:
Watch the video:
Other videos by this author:
 |
Excel Basics #1: Equal Sign & Ampersand & Formulas Posted by: ExcelIsFun
Video duration: 600 seconds Systematic description of what Excel can do from beginning to end. In this video you will see: What is Excel?; Rows and Columns, The Equal Sign and calculating formulas; The Equal and Ampersand signs and Text formulas; When to use Cell References; want numbers can be typed into formulas; how to make formulas; how to use the Fill Handle and the cross hair (angry rabbit) to copy formulas quickly. Related: ampersand, basics, calculating, college, column, community, equal, excel, formulas, gel, girvin, highline, mike, row, sign, text |
 |
Excel Magic Trick #31 Part 1: IF AND OR functions, logical Posted by: ExcelIsFun
Video duration: 565 seconds See how to use the IF, AND and OR functions! See how to make logical formulas. You can check to see if a cell is blank, whether it is above a certain limit, or whether the cell contains text! Related: and, blank, colleg, community, credit, excel, false, formulas, gel, girvin, highline, if, income, istext, logical, lossmike, net, or, true |
 |
Excel Magic Trick #31 Part 2: IF AND OR functions, logical Posted by: ExcelIsFun
Video duration: 459 seconds See how to use the IF, AND and OR functions! See how to make logical formulas. You can check to see if a cell is blank, whether it is above a certain limit, or whether the cell contains text! See how to make the labels on your Income Statement change depending on whether or not there is a Net Loss or a Net Income. See how to use the IF, AND, and OR function to evaluate a customer's credit. Related: and, blank, colle, community, credit, excel, false, formulas, gel, girvin, highline, if, income, istext, logical, loss, mike, net, or, true |
 |
Excel Magic Trick #5: Data Validation & VLOOKUP Posted by: ExcelIsFun
Video duration: 256 seconds Excel! See how to name a cell range, use data validation to add a drop-down list, and how to use the VLOOKUP function to look up values. See how to do this lightening fast with keyboard short cuts! Related: college, community, data, excel, formula, function, gel, girvin, highline, keyboard, mike, named, range, shortcut, validation, vlookup |
 |
Excel Magic Trick #46: Absolute Macro Recorder Posted by: ExcelIsFun
Video duration: 623 seconds See how to create an Absolute Macro (VBA code) using the Macro Recorder. See how to add the Developer Ribbon in Excel 2007. Learn how to use Alt + F8 to see Macro list. See how to save a Macro in the hidden Personal Workbook. See how to hide and unhide the Personal Workbook. Related: absolute, college, community, developer, excel, gel, girvin, hidden, highline, macro, mike, personal, recorder, ribbon, workbook |
![Excel Basics #3: Functions, Named Ranges, \"Range functions\"](http://img.youtube.com/vi/exgvHH0NNKk/2.jpg "Excel Basics #3: Functions, Named Ranges, \\"Range functions\\"") |
Excel Basics #3: Functions, Named Ranges, "Range functions" Posted by: ExcelIsFun
Video duration: 524 seconds Systematic description of what Excel can do from beginning to end. In this video you will see: How to name a range; How to use the COUNT, MAX, MIN, AVERAGE, SUM, COUNTIF, SUMIF and STDEVP functions; and the amazing advantage of using "Range Functions". These Excel Basics in regards to Excel Functions will help you to become more efficient in all that you do with Excel! Related: basics, college, community, count, equal, excel, functions, gel, girvin, highline, max, mike, min, named, names, range, ranges |
![Excel Magic Trick #27: VLOOKUP won\](http://img.youtube.com/vi/pt3BN3dheLc/2.jpg "Excel Magic Trick #27: VLOOKUP won\") |
Excel Magic Trick #27: VLOOKUP won't work: use INDEX & MATCH Posted by: ExcelIsFun
Video duration: 311 seconds When the VLOOKUP function does not work, see how the combination of the INDEX and MATCH function could be the answer! Using Data Validation, and the INDEX and MATCH function you will see how to do a lookup with backward compatibility! Learn about boomerangs too! Related: backward, college, community, compatibility, data, excel, functions, gel, girvin, highline, index, match, mike, validation, vlookup |
 |
Excel Magic Tricks # 1: Formulas & Cell References Posted by: ExcelIsFun
Video duration: 289 seconds See Excel Magic! See how to build your spreadsheet smartly, so it updates automatically. See how to create formulas with cell references! Related: 2003, 2007, budget, cell, college, community, excel, formula, functions, gel, girvin, highline, keyboard, math, mike, reference, shortcu |
 |
Excel Magic Trick #63: Boolean Logic & Array Formulas Posted by: ExcelIsFun
Video duration: 630 seconds See how to create Boolean Logic formulas for AND and OR. See Logical Truth Tables for AND and OR. See how to create Array Formulas in three different ways: Array with SUM & IF functions (must use Ctrl + Shift + Enter) Array with SUMPRODUCT function (DON'T have to use Ctrl + Shift + Enter) Array with SUM function (must use Ctrl + Shift + Enter) Related: array, boolean, college, community, excel, formulas, function, functions, gel, girvin, highline, if, logic, mike, sum, sumproduct |
