Tag Archives: excelisfun

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

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 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

Excel Magic Trick 792: Defined Names In Formulas

Posted on December 1, 2011 by admin

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

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

Office 2010 Class #30: Excel Date Formulas: Days Invoice Past Due, Loan Maturity Date, Project Days

Posted on December 1, 2011 by admin

Download files at: https://people.highline.edu/mgirvin/AllClasses/216_2003/216/busn216.htm The Excel 2010 Basics Series shows a systematic description of what Excel can do from beginning to end. Topics Covered In Video: 1. Date Number Format (Serial Numbers) 2. Date Math 3. Formula for Days Invoice … Continue reading →

Posted in Learn Excel Formulas | Tagged (Serial, 2010, 216, applications, Busn, class, College, Community, computer, Date, Days, Due, excel, excelisfun, for, Format, Gel, Girvin, Highline, in, Invoice, Length, loan, math, Maturity, Mike, Number, numbers, office, past, Project | 6 Comments

Excel Magic Trick 783: Date Functions & Formulas (17 Examples)

Posted on December 1, 2011 by admin

Download file: https://people.highline.edu/mgirvin/ExcelIsFun.htm 1. DAY function 2. TEXT Function to get Day spelled out, like “Monday” 3. TEXT Function to get Month spelled out, like “January” 4. MONTH Function 5. YEAR function 6. Last Day in Month: EOMONTH function 7. … Continue reading →

Posted in Learn Excel Formulas | Tagged .net, 2007, 2010, between, College, Community, Date, Dates, DAY, Days, Dragons, EDATE, excel, excelisfun, first, for, formula, functions, Gel, Girvin, Highline, in, Inclusive, last, Mike, Month, NETWORKINGDAYS, next, Slaying, text, Two, Vest, WEEKDAY, with, Working, Year | 2 Comments

Excel Magic Trick 794: Conditional Formatting MAX or MIN or Top 3 Value/s In Row

Posted on December 1, 2011 by admin

Download file: https://people.highline.edu/mgirvin/ExcelIsFun.htm 1. Create Logical Formula for Conditional Formatting to highlight the lowest smallest value in the row using the MIN function and Mixed Cell References. 2. Create Logical Formula for Conditional Formatting to highlight the largest biggest value … Continue reading →

Posted in Learn Excel Formulas | Tagged 2007, 2010, AND, biggest, cell, College, Community, conditional, Create, Dragons, excel, excelisfun, for, Format, Formatting, formula, function, functions, Gel, Girvin, Highlight, Highline, how, in, large, Largest, Logical, lowest, Max, Mike, Min, mixed, OR, References, row, See, Slaying, SMALL, smallest, the, to, Top, using, value, values | 2 Comments

Excel 2010 Business Math 67: Basic Markup Formula

Posted on November 21, 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. Basic Markup Formula 2. Introduction to Markup On Cost 3. Introduction … Continue reading →

Posted in Learn Basic Excel | Tagged 2010, Basic, business, College, Community, Cost, Dragons, excel, excelisfun, formula, Girvin, Highline, introduction, Markup, math, mathematics, Mike, on, Price, Sell, Slaying, to | Leave a comment

Tag Archives: excelisfun

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)

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

Excel 2010 Business Math 73: Basic Simple Interest Calculations

Office 2010 Class #30: Excel Date Formulas: Days Invoice Past Due, Loan Maturity Date, Project Days

Excel Magic Trick 783: Date Functions & Formulas (17 Examples)

Excel Magic Trick 794: Conditional Formatting MAX or MIN or Top 3 Value/s In Row

Excel 2010 Business Math 67: Basic Markup Formula

Recent Posts

Blogroll

Categories