Tag Archives: for

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

Excel 2010 Business Math 07: How To Search For and Use Excel Functions

Posted on September 24, 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. Search For Excel Functions like SUM, AVEARGE, MAX 2. See how to use the Insert … Continue reading →

Posted in Learn Excel Formulas | Tagged 2010, argument, AVEARGE, box, business, calculations, College, Community, dialog, Dragons, excel, excelisfun, for, formulas, function, functions, Girvin, Highline, Insert, like, math, mathematics, Max, Mike, screen, Search, Slaying, SUM, tips | Leave a comment

Create a Custom Excel Function to Replace Nested IF Functions

Posted on August 24, 2011 by admin

Do you get frustrated writing formulas that require that IF Functions and AND Functions be nested inside each other? Most people do get frustrated – especially when they need to make changes to the formula. Let me show a faster … Continue reading →

Posted in Learn Excel Formulas | Tagged AND, Case, Construct, Custom, data, Educational, excel, for, function, functions, Help, IF, in, management, software, tips & tricks, tutorial, vba | 6 Comments

How to Use AutoFill and Excel Formulas Increment Time Intervals

Posted on July 8, 2011 by admin

This is the 2nd part of my two-part series where I demonstrate how to take advantage of AutoFill in Excel to increment a series of Time Intervals. I share a great shortcut that ensures that you always enter Time Values … Continue reading →

Posted in Learn Excel Formulas | Tagged calculate, Enter, excel, for, formulas, in, Intervals, management, software, Time, tips & tricks, training, tutorial, values | Leave a comment

Excel Magic Trick 777.5: SUMPRODUCT Function OR Criteria, 2 Tips: TRUE+FALSE & TRUE+TRUE

Posted on July 7, 2011 by admin

Download file: https://people.highline.edu/mgirvin/ExcelIsFun.htm 1. Follow up video to Excel Magic Trick 777: SUMPRODUCT Function — Basics To Advanced (14 Examples) 2. Learn how to create OR criteria for adding and counting inside the SUMPRODUCT function when there is NO possibility … Continue reading →

Posted in Learn Excel Formulas | Tagged 2007, 2010, Adding, AND, Boolean, College, Community, counting, criteria, Dragons, excel, excelisfun, for, function, Gel, Girvin, Highline, inside, Logic, Mike, OR, plus, Slaying, SUMPRODUCT, Symbol, the, uses | 12 Comments

Excel Magic Trick 348: Formula for Unit Inventory Total SUMIF function Trick

Posted on July 2, 2011 by admin

See a formula that will take invoice information for inventory quantity sold and update Inventory records to show correct amount on hand (in stock). Duration : 0:2:59 Technorati Tags: College, Community, excel, excelisfun, for, formula, function, Gel, Girvin, Highline, Inventory, … Continue reading →

Posted in Learn Excel Formulas | Tagged College, Community, excel, excelisfun, for, formula, function, Gel, Girvin, Highline, Inventory, Mike, Running, SumIF, Total, Unit | 13 Comments

VBA Excel CountIf Function in VBA Code

Posted on April 15, 2011 by admin

This is a Tutorial on how the CountIf() Function works in VBA code Duration : 0:4:38 Technorati Tags: code, Each, Exce, for, function, howto, loop, range, tutorial, Variables, vba

Posted in Learn Excel Formulas | Tagged code, Each, Exce, for, function, howto, loop, range, tutorial, Variables, vba | Leave a comment

Excel Magic Trick 768: Gradebook Average w Criteria and Conditionally Format Less Than 4 Tests Taken

Posted on March 16, 2011 by admin

Download file: https://people.highline.edu/mgirvin/ExcelIsFun.htm See how to create array formulas for Gradebook Average with Criteria and Conditionally Format less than 4 Tests Taken. See the Functions AVERAGE, IF, SUMPRODUCT. Duration : 0:6:26 Technorati Tags: 2007, 2010, AND, array, AVERAGE, College, Community, … Continue reading →

Posted in Learn Excel Formulas | Tagged 2007, 2010, AND, array, AVERAGE, College, Community, conditionally, Create, criteria, Dragons, excel, excelisfun, for, Format, formulas, function, functions, Gel, Girvin, Gradebook, Highline, IF, less, Mike, Slaying, SUMPRODUCT, Taken, Tests, than, with | 4 Comments

Excel Basic Formulas

Posted on March 15, 2011 by admin

Excel Formulas using basic funcitons and arguments. Max, Min, Average, Median, Count Duration : 0:5:9 Technorati Tags: Basic, excel, for, formulas, Stats

Posted in Learn Excel Formulas | Tagged Basic, excel, for, formulas, Stats | 1 Comment