Tag Archives: 2010

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

How To… Draw a Basic Scatter Diagram in Excel 2010

Posted on December 22, 2011 by admin

A Scatter Diagram helps show if there is a relationship between two variables. In this video you will learn how to draw a basic scatter diagram using two sets of data. Duration : 0:3:34 Technorati Tags: 2010, diagram, excel, Scatter

Posted in Learn Basic Excel | Tagged 2010, diagram, excel, Scatter | Leave a comment

Excel 2010 – Macros and VBA – The Developer Ribbon – by MacroMountain.com

Posted on December 17, 2011 by admin

http://www.MacroMountain.com Excel 2010 – Macros and VBA – The Developer Ribbon In order to work with Macro and VBA in Excel you will need to use the Developer Ribbon. This section provides and overview of the ribbon, including where to … Continue reading →

Posted in Learn Excel Macros | Tagged 2010, AND, excel, learn, macros, Microsoft, vba | 1 Comment

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

Microsoft Excel 2010 Tutorial 30 – Using the Hlookup

Posted on November 25, 2011 by admin

Hlookup is basically the same as Vlookup except that the entire thing works through a horizontal data check….just watch the video! Duration : 0:4:29 Technorati Tags: 2010, 30, computer, Desktop, excel, Free, HLOOKUP, management, Microsoft, office, software, system, Systems, technology, … Continue reading →

Posted in Learn Excel Formulas | Tagged 2010, 30, computer, Desktop, excel, Free, HLOOKUP, management, Microsoft, office, software, system, Systems, technology, the, tutorial, tutorials, using, vista, windows, xp | Leave a comment

Tag Archives: 2010

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

How To… Draw a Basic Scatter Diagram in Excel 2010

Excel 2010 – Macros and VBA – The Developer Ribbon – by MacroMountain.com

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

Microsoft Excel 2010 Tutorial 30 – Using the Hlookup

Recent Posts

Blogroll

Categories