Posts Tagged ‘AND’
Monday, April 23rd, 2012
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. INDEX, MATCH, and CHOOSE functions in one formula (2007 version IFERROR Function) to display records horizontally
2. INDEX, MATCH, and CHOOSE functions in one formula (2003 IF Function) to display records horizontally
3. CHOOSE, VLOOKUP and ROWS functions in one formula (2007 version IFERROR Function) to display records vertically
4. CHOOSE, VLOOKUP and ROWS functions in one formula (2003 version IF Function) to display records vertically
Duration : 0:9:42
(more…)
Technorati Tags: 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
Tags: 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
Posted in Learn Excel Formulas | 10 Comments »
Friday, March 23rd, 2012
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
(more…)
Technorati Tags: AND, Begin, beginner, excel, excel trick, Excel Tutorial, formulas, functions, IF, Logical, Microsoft Excel, OR, teach, Test, tip, tips, Trick, tricks, tutorial, video tutorial
Tags: AND, Begin, beginner, excel, excel trick, Excel Tutorial, formulas, functions, IF, Logical, Microsoft Excel, OR, teach, Test, tip, tips, Trick, tricks, tutorial, video tutorial
Posted in Learn Excel Formulas | 2 Comments »
Friday, March 23rd, 2012
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
(more…)
Technorati Tags: 2003, 2007, 2010, AND, College, Community, Date, Dragon, excel, excelisfun, formula, Girvin, Highline, Mike, Pattern, simplify, Slaying, to, vlookup
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 | 4 Comments »
Sunday, February 26th, 2012
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
(more…)
Technorati Tags: AND, excel, excel trick, Excel Tutorial, formulas, functions, IF, Logic, Logical, Microsoft Excel, nested, OR, teach, Test, tip, tips, Trick, tricks, tutorial, video tutorial
Tags: AND, excel, excel trick, Excel Tutorial, formulas, functions, IF, Logic, Logical, Microsoft Excel, nested, OR, teach, Test, tip, tips, Trick, tricks, tutorial, video tutorial
Posted in Learn Excel Formulas | No Comments »
Tuesday, January 17th, 2012
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:
1. Lookup Value has an extra space
2. 1st column in Lookup Table has extra spaces
3. Lookup Value is a number stored as text and 1st column in Lookup Table has numbers
4. Lookup Value is a number and 1st column in Lookup Table has numbers stored as text
Duration : 0:8:29
(more…)
Technorati Tags: 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
Tags: 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
Posted in Learn Excel Formulas | 11 Comments »
Friday, December 23rd, 2011
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 Data including a Relative or Percent Frequency column with Percentage Number Format.
This is for the Highline Community College Busn 210 Statistical Analysis for Business and Economics taught by Michael Girvin.
Duration : 0:10:31
(more…)
Technorati Tags: 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
Tags: 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
Posted in Learn Basic Excel | 4 Comments »
Saturday, December 17th, 2011
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 find it.
Overview:
-How to Show/Hide the Developer Ribbon
—The Code Group
—Visual Basic Editor
—Macros
—Record Macro
—Use Relative References
-Controls Group
—Insert Controls
—Properties
—View Code
How to Show or Hide the Developer Ribbon in Microsoft Excel:
1. Open and Excel Workbook
2. Click on the File tab
3. Click Options – The Excel Option menu will appear
4. Click Customize Ribbon
5. Check the box next to Developer
6. Click OK – The Developer tab will now be visible
Duration : 0:1:51
(more…)
Technorati Tags: 2010, AND, excel, learn, macros, Microsoft, vba
Tags: 2010, AND, excel, learn, macros, Microsoft, vba
Posted in Learn Excel Macros | 1 Comment »
Thursday, December 15th, 2011
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
(more…)
Technorati Tags: 2007, AND, Date, excel, formulas, function, functions, how, Logic, Microsoft, ms, office, online, pro, software, spreadsheet, Time, to, training, worksheeet
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 | 6 Comments »
Thursday, December 15th, 2011
Using a combination of IF, AND, and OR functions to determine employee pay and bonuses.
Duration : 0:9:59
(more…)
Technorati Tags: AND, excel, function, functions, IF, Logic, OR
Tags: AND, excel, function, functions, IF, Logic, OR
Posted in Learn Excel Formulas | 8 Comments »
Thursday, December 8th, 2011
Please check out all my tutorials here!!!!!!! http://www.youtube.com/user/Malfunction9?feature=mhum
Duration : 0:11:9
(more…)
Technorati Tags: 16, AND, do, downloads, excel, Excel 2003, furthered, instruction, loops, Macro, opening, programming, programs, software, technology, tutorial, until, vba, visual basic, workbooksExcel
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 | No Comments »
