Tag Archives: excelisfun

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

Excel Magic Trick 822: 4-Way Lookup When There ARE Duplicates (Return Multiple Items)

Posted on October 26, 2011 by admin

Download file: https://people.highline.edu/mgirvin/ExcelIsFun.htm See how to do a four way lookup when there ARE duplicates and you need to return multiple items from one lookup value 1. See how to do a Four way lookup when there are duplicate values … Continue reading →

Posted in Learn Excel Formulas | Tagged 2003, 2007, 2010, 4-Way, AGGREGATE, are, College, Community, Dragons, duplicates, excel, excelisfun, From, function, Gel, Girvin, Highline, items, Lookup, Mike, Multiple, one, OR, Return, Slaying, SMALL, There, value, when | Leave a comment

Office 2010 Class #24: Excel Functions COUNTIF & SUMIF Count and Add with one Condition (Criteria)

Posted on October 14, 2011 by admin

The Excel 2010 Basics Series shows a systematic description of what Excel can do from beginning to end. Download files at: https://people.highline.edu/mgirvin/AllClasses/216_2003/216/busn216.htm Topics Covered In Video: 1. Learn how to use the Excel Functions COUNTIF & SUMIF Count and Add … Continue reading →

Posted in Learn Excel Formulas | Tagged 2010, 216, Add, AND, applications, Busn, class, College, Community, computer, Condition, count(), COUNTIF, Create, criteria, Defined, excel, excelisfun, formulas, From, functions, Gel, Girvin, Highline, in, manager, Mike, name, Names, office, one, Selection, SumIF, with | 4 Comments

Excel Magic Trick 810: RANKIF Function RANK IF: Ranking With Conditions

Posted on October 6, 2011 by admin

Download file: https://people.highline.edu/mgirvin/ExcelIsFun.htm 1. There is no such thing as RANKIF Function, but you can use SUMPRODUCT to RANK with Conditions or Criteria 2. See how to rank studnt’s scores by department (like Marketing, Accounting, Finance, etc.) 3. Arrays of … Continue reading →

Posted in Learn Excel Formulas | Tagged 2007, 2010, AND, arrays, College, Community, conditions, converted, criteria, Double, Dragons, excel, excelisfun, function, Gel, Girvin, Highline, IF, Mike, Negative, ones, Rank, RANKIF, Ranking, Slaying, SUMPRODUCT, to, using, with, zeroes | 6 Comments

Excel 2010 Business Math 04: Range Functions Rule!

Posted on October 5, 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: 1. See how the SUM function and Ranges of Cells are much more efficient than cell … Continue reading →

Posted in Learn Excel Formulas | Tagged 2010, Adding, AND, are, business, calculations, cell, cells, College, Community, Dragons, efficient, excel, excelisfun, for, formulas, function, functions, Girvin, Highline, math, mathematics, Mike, more, much, numbers, of, plus, ranges, References, Slaying, SUM, Symbol, than, the | 2 Comments

Mr Excel & excelisfun Trick 85: Algebra Solving For Unknown: Goal Seek Or Algebra Excel Formula?

Posted on October 2, 2011 by admin

See Mr Excel and excelisfun use two methods to solve for an unknown in an Algebra equation 1. Use Goal Seek to solve for an unknown in an algebra equation 2. Create a series of formulas to solve for an … Continue reading →

Posted in Learn Excel Formulas | Tagged 2003, 2007, 2010, Algebra, an, big, Bill, Cleveland, College, Community, Dennis, Dragons, equation, excel, excelisfun, for, Gel, Girvin, goal, High, Highline, Ho, in, Jelen, Mike, Mr, school, Seattle, Seek, Slaying, Solve, unknown, using | Leave a comment

Tag Archives: excelisfun

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

Excel Magic Trick 822: 4-Way Lookup When There ARE Duplicates (Return Multiple Items)

Office 2010 Class #24: Excel Functions COUNTIF & SUMIF Count and Add with one Condition (Criteria)

Excel Magic Trick 810: RANKIF Function RANK IF: Ranking With Conditions

Excel 2010 Business Math 04: Range Functions Rule!

Mr Excel & excelisfun Trick 85: Algebra Solving For Unknown: Goal Seek Or Algebra Excel Formula?

Recent Posts

Blogroll

Categories