Tag Archives: College

Excel Magic Trick 882: Excel 2007 Bitmap Image Lookup Picture INDEX & MATCH functions

Posted on April 23, 2012 by admin

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 … Continue reading →

Posted in Learn Excel Formulas | Tagged 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 | 19 Comments

Excel Magic Trick 906: Ctrl + Backspace: Keyboard To Jump To Active Cell In Worksheet or Formula

Posted on April 23, 2012 by admin

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 Technorati Tags: 2003, 2007, 2010, active, At, Backspace, cell, College, Community, Ctrl, … Continue reading →

Posted in Learn Excel Formulas | Tagged 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 | 12 Comments

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

VLOOKUP function Beginner to Advanced 26 Examples (Excel VLOOKUP WEEK Video #1)

Posted on April 23, 2012 by admin

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 … Continue reading →

Posted in Learn Excel Formulas | Tagged 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 | 25 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 Magic Trick 873: VLOOKUP – Lookup that rounds to the nearest number (Increment Equal)

Posted on March 23, 2012 by admin

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 … Continue reading →

Posted in Learn Excel Formulas | Tagged 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 | 8 Comments

Excel Magic Trick #245: Matching 2 Lists w IF & OR functions

Posted on February 26, 2012 by admin

Check to see if values in one list are in another list with the IF and OR functions in a simple array formula. See how to use the IF and OR functions in a simple array formula that shows WINNER … Continue reading →

Posted in Learn Excel Formulas | Tagged array, College, Community, excel, formula, functions, Gel, Girvin, Highline, IF, Lotto, Matching, Mike, numbers, OR, WINNER | 6 Comments

Excel Magic Trick 359: Part 2: Return Multiple Items From One Lookup Value for Column w Formula

Posted on February 7, 2012 by admin

Duplicate Lookup or Lookup 1 value, return many for a column Part 2. Formula to return all the numbers from a column that contains text and numbers. See an array formula that uses the functions: COUNT, IF, ROWS, INDEX, ISNUMBER, … Continue reading →

Posted in Learn Excel Formulas | Tagged 2, All, College, Community, data, excel, excelisfun, Extract, formula, functions, Gel, Girvin, Highline, INDEX, item, items, Lookup, Many, match, Mike, numbers, one, Return, to | 15 Comments

Excel Magic Trick 358: Part 1: Return Multiple Items From One Lookup Value for Table w Formula

Posted on February 3, 2012 by admin

Duplicate Lookup or Lookup 1 value, return many for a table Part 1. Return winning bets for week from a football betting database. See a formula that will return multiple items when there are two criteria for the data extraction. … Continue reading →

Posted in Learn Excel Formulas | Tagged -1, College, Community, criteria, data, excel, excelisfun, Extract, extraction, for, formula, functions, Gel, Girvin, Highline, INDEX, item, items, Lookup, Many, match, Mike, one, Return, the, Two | 25 Comments

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

Tag Archives: College

Excel Magic Trick 906: Ctrl + Backspace: Keyboard To Jump To Active Cell In Worksheet or Formula

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

VLOOKUP function Beginner to Advanced 26 Examples (Excel VLOOKUP WEEK Video #1)

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

Excel Magic Trick 873: VLOOKUP – Lookup that rounds to the nearest number (Increment Equal)

Excel Magic Trick #245: Matching 2 Lists w IF & OR functions

Excel Magic Trick 359: Part 2: Return Multiple Items From One Lookup Value for Column w Formula

Excel Magic Trick 358: Part 1: Return Multiple Items From One Lookup Value for Table w Formula

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

Recent Posts

Blogroll

Categories