Tag Archives: AND

Excel Magic Trick 883: OR VLOOKUP? Lookup One Thing OR Another and Get Correct Record

Download workbook: http://people.highline.edu/mgirvin/ExcelIsFun.htm Excel 2003 0r 2007: See 4 methods to allow a person to enter “ID Number” OR “Name” (Lookup value is one OR another thing from two differenet columns in the database) and lookup the correct Record: 1. … Continue reading

Posted in Learn Excel Formulas | Tagged , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , | 10 Comments

Excel AND function – beginner

Many more great Excel tutorials linked below: http://www.youtube.com/playlist?list=PL8004DC1D703D348C&feature=plcp Be sure to watch my other Excel tutorial videos on my channel, including more advanced techniques and many useful and practical ones. Be sure to Subscribe and Comment. Duration : 0:5:27 Technorati … Continue reading

Posted in Learn Excel Formulas | Tagged , , , , , , , , , , , , , , , , , , , | 2 Comments

Excel Magic Trick 870: VLOOKUP A Date and Pattern To Simplify Formula

Download workbook: http://people.highline.edu/mgirvin/ExcelIsFun.htm Learn how to: 1. : VLOOKUP A Date and Pattern To Simplify Formula Duration : 0:2:31 Technorati Tags: 2003, 2007, 2010, AND, College, Community, Date, Dragon, excel, excelisfun, formula, Girvin, Highline, Mike, Pattern, simplify, Slaying, to, vlookup

Posted in Learn Excel Formulas | Tagged , , , , , , , , , , , , , , , , , , | 4 Comments

Excel OR function – beginner

Many more great Excel tutorials linked below: http://www.youtube.com/playlist?list=PL8004DC1D703D348C&feature=plcp Be sure to watch my other Excel tutorial videos on my channel, including more advanced techniques and many useful and practical ones. Be sure to Subscribe and Comment. Duration : 0:6:31 Technorati … Continue reading

Posted in Learn Excel Formulas | Tagged , , , , , , , , , , , , , , , , , , , | Leave a comment

Excel Magic Trick 836: VLOOKUP Lookup Value Not Matching Value in 1st Column (4 Examples)

Download file: https://people.highline.edu/mgirvin/ExcelIsFun.htm Learn how to deal with the situation where you can see that the lookup value is the same as a value in the first column of the lookup table, but it is not giving you a match: … Continue reading

Posted in Learn Excel Formulas | Tagged , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , | 11 Comments

Excel 2010 Statistics 09: Proportions, Probabilities and Percentages: Formulas and Formatting

Download file: https://people.highline.edu/mgirvin/ExcelIsFun.htm 1. Learn about Proportions, Probabilities and Percentages: Formulas and Formatting. 2. See the COUNTIF function and Relative and Absolute Cell References for counting with 1 criteria 3. See how to create a Basic Frequency Table with Qualitative … Continue reading

Posted in Learn Basic Excel | Tagged , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , | 4 Comments

Excel 2010 – Macros and VBA – The Developer Ribbon – by MacroMountain.com

http://www.MacroMountain.com Excel 2010 – Macros and VBA – The Developer Ribbon In order to work with Macro and VBA in Excel you will need to use the Developer Ribbon. This section provides and overview of the ribbon, including where to … Continue reading

Posted in Learn Excel Macros | Tagged , , , , , , | 1 Comment

How to Use the Date and Time Function In Excel 2007

Watch the full course at http://SimonSezIT.com. Website: http://SimonsezIT.com Facebook: http://www.facebook.com/SimonSezIT Twitter: http://twitter.com/SimonsezIT Duration : 0:5:40 Technorati Tags: 2007, AND, Date, excel, formulas, function, functions, how, Logic, Microsoft, ms, office, online, pro, software, spreadsheet, Time, to, training, worksheeet

Posted in Learn Excel Formulas | Tagged , , , , , , , , , , , , , , , , , , , | 6 Comments

Excel Logic Functions – IF, AND, and OR

Using a combination of IF, AND, and OR functions to determine employee pay and bonuses. Duration : 0:9:59 Technorati Tags: AND, excel, function, functions, IF, Logic, OR

Posted in Learn Excel Formulas | Tagged , , , , , , | 8 Comments

Excel VBA tutorial 16 do until loops furthered and opening workbooks.flv

Please check out all my tutorials here!!!!!!! http://www.youtube.com/user/Malfunction9?feature=mhum Duration : 0:11:9 Technorati Tags: 16, AND, do, downloads, excel, Excel 2003, furthered, instruction, loops, Macro, opening, programming, programs, software, technology, tutorial, until, vba, visual basic, workbooksExcel

Posted in Learn Excel Macros | Tagged , , , , , , , , , , , , , , , , , , , | Leave a comment