Posts Tagged ‘Slaying’
Monday, April 23rd, 2012
Download workbook: http://people.highline.edu/mgirvin/ExcelIsFun.htm
See how to do a lookup for Pictures in Excel 2007 using:
Data Validation Dropdown List
INDEX and MATCH Functions
Defined Names
Excel 2007 Hint (from Joe): Insert Bitmap Image (Insert Ribbon Tab, Text group, Object) instead of a picture and then put formula in Bitmap Image
Also see this video:
Excel Magic Trick 881: Lookup Picture with INDEX & MATCH functions instead of INDIRECT Function
Mr Excel & excelisfun Trick 42: Lookup Picture In Excel Formula or VBA?:
Excel Magic Trick 637: Lookup A Chart — Defined Names, INDIRECT function and Formulas In Pictures
Duration : 0:4:30
(more…)
Technorati Tags: 2003, 2007, 2010, Bitmap, College, Community, data, Defined, Dragons, Dropdown, excel, excelisfun, functions, Girvin, group, Highline, Image, INDEX, Insert, List, Lookup, match, Mike, Names, object, Picture, Ribbon, Slaying, tab, text, validation, with
Tags: 2003, 2007, 2010, Bitmap, College, Community, data, Defined, Dragons, Dropdown, excel, excelisfun, functions, Girvin, group, Highline, Image, INDEX, Insert, List, Lookup, match, Mike, Names, object, Picture, Ribbon, Slaying, tab, text, validation, with
Posted in Learn Excel Formulas | 19 Comments »
Monday, April 23rd, 2012
Download workbook: http://people.highline.edu/mgirvin/ExcelIsFun.htm
Keyboard to jump to Active Cell is Ctrl + Backspace:
1. In A Formula
2. In The Worksheet
Shmuel Oluwa at Facebook!!!
Duration : 0:2:2
(more…)
Technorati Tags: 2003, 2007, 2010, active, At, Backspace, cell, College, Community, Ctrl, Dragons, excel, excelisfun, FaceBook, formula, Girvin, Highline, in, Jump, keyboard, Mike, Oluwa, OR, Shmuel, Slaying, to, worksheet
Tags: 2003, 2007, 2010, active, At, Backspace, cell, College, Community, Ctrl, Dragons, excel, excelisfun, FaceBook, formula, Girvin, Highline, in, Jump, keyboard, Mike, Oluwa, OR, Shmuel, Slaying, to, worksheet
Posted in Learn Excel Formulas | 12 Comments »
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 »
Monday, April 23rd, 2012
Download workbook: http://people.highline.edu/mgirvin/ExcelIsFun.htm
This video is a part of VLookup Week: http://vlookupweek.wordpress.com
Excel VLOOKUP is one of the most important functions because everyone needs to look stuff up. Not only that, but if you want to get a job, you must know VLOOKUP.
In this video learn everything you need to know about VLOOKUP in 1 video.
Here are the topics (minute marks jump you to that part of the video):
1. VLOOKUP = V = Vertical ( min)
2. Why so common? Because everyone needs to look stuff up ( 00:43 min)
3. VLOOKUP Delivers a value to a cell: Extract Match ( 2:37 min)
4. VLOOKUP #N/A and IFERROR or IF ( 5:25 min)
5. VLOOKUP and Data Validation ( 8:10 min)
6. VLOOKUP with Named Range ( 10:34 min)
7. VLOOKUP as Formula Element ( 17:24 min)
8. HLOOKUP = H = Horizontal ( 18:25 min)
9. VLOOKUP Delivers a value to a cell: Approximate Match ( 19:40 min)
10. VLOOKUP with table on different sheet ( 24:00 min)
11. VLOOKUP with table in different workbook ( 25:56 min)
12. Show Full Record: Numbers above column header ( 27:15 min)
13. Show Full Record horizontally: COLUMNS Function ( 30:20 min)
14. Show Full Record vertically: ROWS Function ( 32:28 min)
15. Show Full Record: MATCH Functions ( 33:40 min)
16. Two Lookup Values: Add join column as first column in table ( 35:40 min)
17. Two Lookup Values: Join columns in formula and use CHOOSE function ( 38:50 min)
18. Partial Text Lookup: LEFT and SEARCH Functions ( 43:22 min)
19. Partial Text Lookup: MID Function ( 45:37 min)
20. Partial Text Lookup: RIGHT Function ( 48:08 min)
21. TRIM and VLOOKUP: Space in lookup value ( 48:57 min)
22. TRIM and VLOOKUP: Space in 1st column of table ( 51:03 min)
23. VLOOKUP with 3 lookup tables: CHOOSE Function ( 53:20 min)
24. VLOOKUP: Two Way Lookup with VLOOKUP and MATCH ( 58:36 min)
25. VLOOKUP: Variable Tax Rate, 3 VLOOKUPS in one formula ( 1:00:18 min)
26. VLOOKUP and Table feature for Dynamic ranges ( 1:05:17 min)
VLOOKUP Shark WEEK
Duration : 1:8:3
(more…)
Technorati Tags: 2003, 2007, 2010, Add, As, CHOOSE, College, column, COLUMNS, Community, different, Dragons, Element, excel, excelsifun, first, formula, function, functions, Girvin, Highline, HLOOKUP, Horizontal, in, Join, left, Lookup, match, MID, Mike, named, on, Partial, range, right(), ROWS, Search, Shark, sheet, Slaying, space, table, Tax, text, TRIM, Two, values, vlookup, Way, WEEK, workbook
Tags: 2003, 2007, 2010, Add, As, CHOOSE, College, column, COLUMNS, Community, different, Dragons, Element, excel, excelsifun, first, formula, function, functions, Girvin, Highline, HLOOKUP, Horizontal, in, Join, left, Lookup, match, MID, Mike, named, on, Partial, range, right(), ROWS, Search, Shark, sheet, Slaying, space, table, Tax, text, TRIM, Two, values, vlookup, Way, WEEK, workbook
Posted in Learn Excel Formulas | 25 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 »
Friday, March 23rd, 2012
Download workbook: http://people.highline.edu/mgirvin/ExcelIsFun.htm
Learn how to:
1. See how to avoid the default VLOOKUP behavior and instead find a value in the first column of the lookup table that is closest to the lookup Value.
2. Because the increment between the values in the first column of the lookup table are the same, we can round to the nearest 0.25 using MROUND or ROUND functions and force the VLOOKUP to find the nearest value instead of the default behavior” between two values”
3. See how to use MROUND function to round the lookup value so you can find the nearest value in the first column of the lookup column
4. See how to use ROUND function to round the lookup value so you can find the nearest value in the first column of the lookup column
Lookup that rounds to the nearest number
Duration : 0:3:10
(more…)
Technorati Tags: 0.25, 2003, 2007, 2010, behavior, between, can, College, column, Community, default, Dragon, equal, excel, excelisfun, first, formula, formulas, function, functions, Girvin, Highline, in, increment, instead, Lookup, Mike, MROUND, Nearest, Number, of, Round, Rounded, rounds, same, Slaying, table, that, the, to, value, values, vlookup
Tags: 0.25, 2003, 2007, 2010, behavior, between, can, College, column, Community, default, Dragon, equal, excel, excelisfun, first, formula, formulas, function, functions, Girvin, Highline, in, increment, instead, Lookup, Mike, MROUND, Nearest, Number, of, Round, Rounded, rounds, same, Slaying, table, that, the, to, value, values, vlookup
Posted in Learn Excel Formulas | 8 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 3rd, 2011
Download file: http://people.highline.edu/mgirvin/ExcelIsFun.htm
This is a Business Mathematics Class (Busn Math 135) taught by Mike excelisfun Girvin at Highline Community College.
In this video learn how to calculate:
1. Simple Interest Amount = Principal * Simple Annual Interest Rate * Time (Fraction of Year)
Duration : 0:5:50
(more…)
Technorati Tags: 2010, Amount, Annual, business, College, Community, Dragons, excel, excelisfun, Fraction, Girvin, Highline, Interest, math, mathematics, Mike, of, Principal, RATE, simple, Slaying, Time, Year
Tags: 2010, Amount, Annual, business, College, Community, Dragons, excel, excelisfun, Fraction, Girvin, Highline, Interest, math, mathematics, Mike, of, Principal, RATE, simple, Slaying, Time, Year
Posted in Learn Basic Excel | 2 Comments »
Thursday, December 1st, 2011
Download file: https://people.highline.edu/mgirvin/ExcelIsFun.htm
1. Create Defined Names using Name Box or Name Manager
2. Edit Defined Names
3. Create Names From Selection
4. Apply Names to Formulas
5. Paste List Of Names
6. Keyboard Shortcuts
Duration : 0:12:21
(more…)
Technorati Tags: 2007, 2010, Apply Names to Formulas, box, College, Community, Create, Create Names From Selection, Defined, Dragons, edit, excel, excelisfun, Gel, Girvin, Highline, keyboard, List, manager, Mike, name, Names, of, OR, paste, shortcuts, Slaying, using
Tags: 2007, 2010, Apply Names to Formulas, box, College, Community, Create, Create Names From Selection, Defined, Dragons, edit, excel, excelisfun, Gel, Girvin, Highline, keyboard, List, manager, Mike, name, Names, of, OR, paste, shortcuts, Slaying, using
Posted in Learn Excel Formulas | 11 Comments »
