 |
YouTubersLoveExcel#48: VLOOKUP for TIME Posted by: ExcelIsFun
Video duration: 458 seconds Global video hits: 407 See how to use VLOOKUP, ISTEXT, ISBLANK, OR and IF functions in one formula to lookup a Time value. Related: and, college, community, excel, formula, functions, gel, girvin, highline, if, isblank, istext, mike, or, vlookup |
 |
Excel Magic Trick #31 Part 1: IF AND OR functions, logical Posted by: ExcelIsFun
Video duration: 565 seconds Global video hits: 7068 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\](http://img.youtube.com/vi/gywvBluNjio/2.jpg "Excel\") |
Excel's Conditional Formatting Dynamically Highlights Data Posted by: DannyRocksExcels
Video duration: 330 seconds Global video hits: 346 I like to use Excel's Conditional Formatting to: 1) Dynamically highlight the cells that meet my criteria e.g. Above Average, 5 highest values, etc. 2) Apply special formatting to my spreadsheet - e.g. shade every other row to make it easier to read the data. Visit my website - http://thecompanyroc ks.com/excels to view all of my Excel video lessons. Related: 2003, alternate, analysis, cell, cells, conditional, data, excel, formatting, formula, highest, highlight, is, istext, lessons, microsoft, ms, row, shading, tutorial, value, values |
 |
Excel Magic Trick #31 Part 2: IF AND OR functions, logical Posted by: ExcelIsFun
Video duration: 459 seconds Global video hits: 7569 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 |
| Page: 1 |
![[Sitemap]](http://www.excelspreadsheettraining.com/images/sitemap.gif "XML Sitemap"){kind=small}