Tag Archives: AND

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

Posted on April 23, 2012 by admin

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 2003, 2007, 2010, allow, AND, CHOOSE, College, Community, correct, display, Dragons, Enter, excel, excelisfun, functions, Girvin, Highline, id, IF, IFERROR, INDEX, Lookup, match, methods, Mike, name, Number, OR, person, Record, records, ROWS, See, Slaying, the, to, vertically, vlookup | 10 Comments

Excel AND function – beginner

Posted on March 23, 2012 by admin

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 AND, Begin, beginner, excel, excel trick, Excel Tutorial, formulas, functions, IF, Logical, Microsoft Excel, OR, teach, Test, tip, tips, Trick, tricks, tutorial, video tutorial | 2 Comments

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

Posted on March 23, 2012 by admin

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 2003, 2007, 2010, AND, College, Community, Date, Dragon, excel, excelisfun, formula, Girvin, Highline, Mike, Pattern, simplify, Slaying, to, vlookup | 4 Comments

Excel OR function – beginner

Posted on February 26, 2012 by admin

Posted in Learn Excel Formulas | Tagged AND, excel, excel trick, Excel Tutorial, formulas, functions, IF, Logic, Logical, Microsoft Excel, nested, OR, teach, Test, tip, tips, Trick, tricks, tutorial, video tutorial | Leave a comment

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

Posted on January 17, 2012 by admin

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 2007, 2010, an, AND, As, College, column, Community, Dragons, excel, excelisfun, extra, first, Gel, Girvin, has, Highline, in, Lookup, Matching, Mike, not, Number, numbers, Slaying, space, spaces, stored, table, text, Trouble, value, values, vlookup | 11 Comments

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

Posted on December 23, 2011 by admin

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 2010, 210, Absolute, analysis, AND, Basic, business, Busn, cell, College, Community, COUNTIF, counting, criteria, data, Dragons, Economics, excel, excelisfun, for, Format, Formatting, formulas, FREQUENCY, function, Gel, Girvin, Highline, Including, Mike, Number, Percentages, Probabilities, Proportions, Qualitative, References, Relative, Slaying, Statistical, Statistics, table, with | 4 Comments

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

Posted on December 17, 2011 by admin

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 2010, AND, excel, learn, macros, Microsoft, vba | 1 Comment

How to Use the Date and Time Function In Excel 2007

Posted on December 15, 2011 by admin

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 2007, AND, Date, excel, formulas, function, functions, how, Logic, Microsoft, ms, office, online, pro, software, spreadsheet, Time, to, training, worksheeet | 6 Comments

Excel Logic Functions – IF, AND, and OR

Posted on December 15, 2011 by admin

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 AND, excel, function, functions, IF, Logic, OR | 8 Comments

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

Posted on December 8, 2011 by admin

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 16, AND, do, downloads, excel, Excel 2003, furthered, instruction, loops, Macro, opening, programming, programs, software, technology, tutorial, until, vba, visual basic, workbooksExcel | Leave a comment