Posts Tagged ‘Gel’
Sunday, February 26th, 2012
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 in cell if two lotto numbers are the same.
Duration : 0:2:28
(more…)
Technorati Tags: array, College, Community, excel, formula, functions, Gel, Girvin, Highline, IF, Lotto, Matching, Mike, numbers, OR, WINNER
Tags: array, College, Community, excel, formula, functions, Gel, Girvin, Highline, IF, Lotto, Matching, Mike, numbers, OR, WINNER
Posted in Learn Excel Formulas | 6 Comments »
Tuesday, February 7th, 2012
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, SMALL. Return Multiple Items From One Lookup Value (One Lookup value is a number).
Related Videos: Excel Magic Trick 358: Part 1: Return Multiple Items From One Lookup Value for Table, Excel Magic Trick 360: Part 3: Return Multiple Items From One Lookup Value for Row
Duration : 0:8:19
(more…)
Technorati Tags: 2, All, College, Community, data, excel, excelisfun, Extract, formula, functions, Gel, Girvin, Highline, INDEX, item, items, Lookup, Many, match, Mike, numbers, one, Return, to
Tags: 2, All, College, Community, data, excel, excelisfun, Extract, formula, functions, Gel, Girvin, Highline, INDEX, item, items, Lookup, Many, match, Mike, numbers, one, Return, to
Posted in Learn Excel Formulas | 15 Comments »
Friday, February 3rd, 2012
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. See an INDEX and MATCH functions formula that uses SUMPRODUCT, COUNTIFS, IF, ROWS, INDEX, MATCH, SMALL, IF, and ROW functions. This is a data extract with 2 criteria using a formula solution. Return Multiple Items From One Lookup Value.
Related Videos: Excel Magic Trick 359: Part 2: Return Multiple Items From One Lookup Value for Column, Excel Magic Trick 360: Part 3: Return Multiple Items From One Lookup Value for Row
List Winning Bets With Array Formula
Duration : 0:12:43
(more…)
Technorati Tags: -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
Tags: -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
Posted in Learn Excel Formulas | 25 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 »
Tuesday, January 10th, 2012
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
(more…)
Technorati Tags: button, College, Community, error, excel, Fix, form, formula, functions, Gel, Girvin, Highline, IF, IFERROR, ISERROR, Macro, Mike, with
Tags: button, College, Community, error, excel, Fix, form, formula, functions, Gel, Girvin, Highline, IF, IFERROR, ISERROR, Macro, Mike, with
Posted in Learn Excel Macros | No 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 »
Friday, December 16th, 2011
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 add a new column, concatenate data from 3 columns, and delete unwanted columns.
Duration : 0:10:42
(more…)
Technorati Tags: Absolute, change, College, Community, excel, for, Gel, Girvin, Highline, Macro, Mike, Number, Recorded, References, Relative, ROWS
Tags: Absolute, change, College, Community, excel, for, Gel, Girvin, Highline, Macro, Mike, Number, Recorded, References, Relative, ROWS
Posted in Learn Excel Macros | 6 Comments »
Friday, December 16th, 2011
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 a Form Command button.
Duration : 0:8:51
(more…)
Technorati Tags: Advanced, button, College, Community, excel, Extract, FALSE, filter, formula, Gel, Girvin, Highline, Macro, Mike, text, TRUE
Tags: Advanced, button, College, Community, excel, Extract, FALSE, filter, formula, Gel, Girvin, Highline, Macro, Mike, text, TRUE
Posted in Learn Excel Macros | 21 Comments »
Friday, December 16th, 2011
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 various formulas.
Incrementing Numbers in Formulas. ROWS COLUMNS functions.
Duration : 0:6:11
(more…)
Technorati Tags: College, Community, excel, formulas, function, Gel, Girvin, Highline, in, numbers, ROWS, Sequential, the, using
Tags: College, Community, excel, formulas, function, Gel, Girvin, Highline, in, numbers, ROWS, Sequential, the, using
Posted in Learn Excel Formulas | 18 Comments »
Thursday, December 8th, 2011
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 Excel. Learn that Excel 2007 has 100 Undo, whereas Excel 2003 only had 16.
In This Series learn 17 amazing Finance Tricks. Learn about the PMT, PV, FV, NPER, RATE, SLN, DB, EFFECT, NOMINAL, NPV, XNPV, and the CUMIPMT functions that can make your financing tasks much easier in Excel. See how to use the PMT function in the standard way, but also see how to use it while incorporating a Balloon payment or a delayed payment. Lean how to translate a Nominal interest rate into an Effective Interest rate. Learn how to calculate how long it takes to pay off a credit card balance. Lean how to calculate the Effect Rate on a Payday loan. And many more financing Tricks!!
The Excel Finance Tricks 1-17 will show an assortment of Excel Financing Tricks!
Formula
Duration : 0:10:36
(more…)
Technorati Tags: College, Community, compound, excel, finance, function, FV, Gel, Girvin, Highline, Interest, Mike, simple
Tags: College, Community, compound, excel, finance, function, FV, Gel, Girvin, Highline, Interest, Mike, simple
Posted in Learn Basic Excel | 6 Comments »
