Tag Archives: for

VBA – Excel If Function in VBA code

Posted on April 23, 2012 by admin

Excel If Function in VBA code. This VBA Function does exactly what the Excel If Function does. Code: Function ifCode(s1 As String, s2 As Variant, s3 As Variant) tst = Evaluate(s1) If tst = True Then ifCode = s2 Else … Continue reading →

Posted in Learn Excel Macros | Tagged else, excel, for, functions, how, howto, IF, next, range, then, to, tutorial, Variable, vba | Leave a comment

How to Use Criteria in Excel Filters and Functions

Posted on February 9, 2012 by admin

In this tutorial, I demonstrate how to use the “Logical Functions” of IF, AND, and OR in Excel. In order to return the answer TRUE with the AND Function, each logical test must answer TRUE. I frequently “Nest” the AND … Continue reading →

Posted in Learn Excel Formulas | Tagged Advanced, business, criteria, data, excel, filter, filtering, for, functions, in, information, lesson, Logical, management, office, software, technology, training, tutorial | Leave a comment

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

subtraction for children kindergarten Minus Basic first grade 1 2 3 4 5 6 7 8 9 10 flash card 0 12

Posted on December 22, 2011 by admin

Subtract formula in excel facts preschoolers math colors stoners song toddlers learn teach takeaway Babies adding rocks home school time table Duration : 0:1:21 Technorati Tags: Adding, addition, animation, babies, cards, children, Early, education, flash, for, indians, kids, kindergarteners, learn, … Continue reading →

Posted in Learn Basic Excel | Tagged Adding, addition, animation, babies, cards, children, Early, education, flash, for, indians, kids, kindergarteners, learn, lesson, little, mathematics, minus, Parents, preschoolers, school, Student, Subtraction, Takeaway, teach, teacher, ten, toddlers | Leave a comment

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

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 – Formulas for Percentage

Posted on October 27, 2011 by admin

Excel – Formulas for Percentage Duration : 0:4:21 Technorati Tags: attendance, excel, for, formulas, how to, percentage, software, technology, tutorial

Posted in Learn Excel Formulas | Tagged attendance, excel, for, formulas, how to, percentage, software, technology, tutorial | Leave a comment

Tag Archives: for

VBA – Excel If Function in VBA code

How to Use Criteria in Excel Filters and Functions

Excel Magic Trick 358: Part 1: Return Multiple Items From One Lookup Value for Table w Formula

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

subtraction for children kindergarten Minus Basic first grade 1 2 3 4 5 6 7 8 9 10 flash card 0 12

Excel Magic Trick # 264: Absolute & Relative Macro Fix Data

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 – Formulas for Percentage

Recent Posts

Blogroll

Categories