Posts Tagged ‘AND’

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

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: , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , ,

Excel AND function – beginner

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: , , , , , , , , , , , , , , , , , , ,

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

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: , , , , , , , , , , , , , , , , , ,

Excel OR function – beginner

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: , , , , , , , , , , , , , , , , , , ,

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

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: , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , ,

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

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: , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , ,

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

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: , , , , , ,

How to Use the Date and Time Function In Excel 2007

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: , , , , , , , , , , , , , , , , , , ,

Excel Logic Functions – IF, AND, and OR

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: , , , , , ,

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

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: , , , , , , , , , , , , , , , , , , ,