Video scenes shots:
Watch the video:
Other videos by this author:
 |
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! Excel Magic Trick 167p1 IF function formula: 12 Examples! Excel Magic Trick 167p2 IF function formula: 12 Examples! Related: and, blank, colleg, community, credit, excel, false, formulas, gel, girvin, highline, if, income, istext, logical, lossmike, 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! Excel Magic Trick 167p1 IF function formula: 12 Examples! Excel Magic Trick 167p2 IF function formula: 12 Examples! Related: college, community, data, excel, formula, function, gel, girvin, highline, keyboard, mike, named, range, shortcut, validation, vlookup |
![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 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 |
 |
You Tubers Love Excel#5: IF formula too long use: VLOOKUP Posted by: ExcelIsFun
Video duration: 635 seconds See how to use the IF, AND and VLOOKUP functions. See when too many If functions in your formula gets difficult to manage; Instead we will use VLOOKP to make our formula creation much easier. Related: and, college, community, excel, formula, function, functions, gel, girvin, highline, if, many, mike, too, vlookup |
 |
Excel Basics #7: Style & Number Formatting Posted by: ExcelIsFun
Video duration: 660 seconds See how to not get tricked by Formatting! See how to apply and use to your advantage Stylistic and Number Formatting in Excel. See how to use the Format Cells Dialog Box to apply formatting! See how to use Number Formatting to your advantage when make formulas that calculate. Related: basics, cells, college, community, date, dialog, excel, format, formatting, formula, gel, girvin, highline, mike, number, style, time |
 |
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 |
![[Sitemap]](http://www.excelspreadsheettraining.com/images/sitemap.gif "XML Sitemap"){kind=small}