Tag Archives: College

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

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

Tag Archives: College

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

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)

Recent Posts

Blogroll

Categories