Tag Archives: formula

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

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 Hlookup

Posted on January 23, 2012 by admin

Be sure to also check this great video on Vlookup: This video introduces and advances a very useful and practical example for the Hlookup function. Duration : 0:14:28 Technorati Tags: best, computer software, excel, formula, function, functions, HLOOKUP, Horizontal, horizontal … Continue reading →

Posted in Learn Excel Formulas | Tagged best, computer software, excel, formula, function, functions, HLOOKUP, Horizontal, horizontal lookup, look, Lookup, Microsoft, Microsoft Excel, rdjalayer, Software Tutorial, tutorial, up, Vertical, vlookup | Leave a comment

YouTubersLoveExcel#50: Macro & Form Button

Posted on January 10, 2012 by admin

See how to create a basic Macro and then assign the Macro to a Form button. See how to fix a formula with an error with the IFERROR, IF, and ISERROR functions. Duration : 0:9:8 Technorati Tags: button, College, Community, … Continue reading →

Posted in Learn Excel Macros | Tagged button, College, Community, error, excel, Fix, form, formula, functions, Gel, Girvin, Highline, IF, IFERROR, ISERROR, Macro, Mike, with | Leave a comment

Microsoft Office Excel Formula and the Function Library

Posted on December 31, 2011 by admin

This video will show you the new look and features of Excel 2007 so you can make the decision to upgrade from Office 2003 to 2007. To purchase Excel 2007 training CD, please visit our website: http://www.computerlearningpro.com Duration : 0:1:4 … Continue reading →

Posted in Learn Excel Formulas | Tagged Educational, excel, formula, Microsoft | Leave a comment