Tag Archives: Community

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

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

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

Posted on December 23, 2011 by admin

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

Posted in Learn Basic Excel | Tagged 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 | 4 Comments

Excel Magic Trick # 264: Absolute & Relative Macro Fix Data

Posted on December 16, 2011 by admin

Learn How To Use A Macro With Relative and Absolute References to Deal With Data With Variable Row Size! A MUST TRICK IF YOU USE RECORDED MACROS. See how to use a recorded Macro to take a data set and … Continue reading →

Posted in Learn Excel Macros | Tagged Absolute, change, College, Community, excel, for, Gel, Girvin, Highline, Macro, Mike, Number, Recorded, References, Relative, ROWS | 6 Comments

Excel Magic Trick #126: Macro: Advanced Filter Extract Text

Posted on December 16, 2011 by admin

See how to create a macro that will do an Advanced Filter Movie Title Extract for a Movie Database. See how to create the TRUE FALSE formula for advanced filter before creating a Macro and then adding the Macro to … Continue reading →

Posted in Learn Excel Macros | Tagged Advanced, button, College, Community, excel, Extract, FALSE, filter, formula, Gel, Girvin, Highline, Macro, Mike, text, TRUE | 21 Comments

Excel Magic Trick #203: Sequential Numbers in Formulas ROWS function

Posted on December 16, 2011 by admin

See how to create sequential numbers in formulas using the ROWS function. See the advantages of using this ROWS function method over other methods. See 4 different formula examples of this trick. See the ROWS, ROW, and IF functions in … Continue reading →

Posted in Learn Excel Formulas | Tagged College, Community, excel, formulas, function, Gel, Girvin, Highline, in, numbers, ROWS, Sequential, the, using | 18 Comments

Excel Finance Trick #2: Simple & Compound Interest

Posted on December 8, 2011 by admin

See how to use the FV function. See the math formula for calculating Future Value and for calculating the effective interest rate. Also see long hand how compound interest is calculated. See that Excel only sees 15 significant digits in … Continue reading →

Posted in Learn Basic Excel | Tagged College, Community, compound, excel, finance, function, FV, Gel, Girvin, Highline, Interest, Mike, simple | 6 Comments

Excel 2010 Business Math 73: Basic Simple Interest Calculations

Posted on December 3, 2011 by admin

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

Posted in Learn Basic Excel | Tagged 2010, Amount, Annual, business, College, Community, Dragons, excel, excelisfun, Fraction, Girvin, Highline, Interest, math, mathematics, Mike, of, Principal, RATE, simple, Slaying, Time, Year | 2 Comments

Tag Archives: Community

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)

YouTubersLoveExcel#50: Macro & Form Button

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

Excel Magic Trick # 264: Absolute & Relative Macro Fix Data

Excel Magic Trick #126: Macro: Advanced Filter Extract Text

Excel Magic Trick #203: Sequential Numbers in Formulas ROWS function

Excel Finance Trick #2: Simple & Compound Interest

Excel 2010 Business Math 73: Basic Simple Interest Calculations

Recent Posts

Blogroll

Categories