Posts Tagged ‘for’
Monday, April 23rd, 2012
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
ifCode = s3
End If
End Function
Duration : 0:4:24
(more…)
Technorati Tags: else, excel, for, functions, how, howto, IF, next, range, then, to, tutorial, Variable, vba
Tags: else, excel, for, functions, how, howto, IF, next, range, then, to, tutorial, Variable, vba
Posted in Learn Excel Macros | No Comments »
Thursday, February 9th, 2012
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 Function inside an IF Function and I demonstrate how this works.
I also share my “Best Practice” tips for using the Advanced Filter tool in Excel. The key to success is know how to use AND criteria and OR criteria.
I invite you to visit my website – www.thecompanyrocks.com – to view all of my videos and to sample the many resources that I offer.
Danny Rocks
The Company Rocks
Duration : 0:11:13
(more…)
Technorati Tags: Advanced, business, criteria, data, excel, filter, filtering, for, functions, in, information, lesson, Logical, management, office, software, technology, training, tutorial
Tags: Advanced, business, criteria, data, excel, filter, filtering, for, functions, in, information, lesson, Logical, management, office, software, technology, training, tutorial
Posted in Learn Excel Formulas | No Comments »
Friday, February 3rd, 2012
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. See an INDEX and MATCH functions formula that uses SUMPRODUCT, COUNTIFS, IF, ROWS, INDEX, MATCH, SMALL, IF, and ROW functions. This is a data extract with 2 criteria using a formula solution. Return Multiple Items From One Lookup Value.
Related Videos: Excel Magic Trick 359: Part 2: Return Multiple Items From One Lookup Value for Column, Excel Magic Trick 360: Part 3: Return Multiple Items From One Lookup Value for Row
List Winning Bets With Array Formula
Duration : 0:12:43
(more…)
Technorati Tags: -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
Tags: -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
Posted in Learn Excel Formulas | 25 Comments »
Friday, December 23rd, 2011
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 Data including a Relative or Percent Frequency column with Percentage Number Format.
This is for the Highline Community College Busn 210 Statistical Analysis for Business and Economics taught by Michael Girvin.
Duration : 0:10:31
(more…)
Technorati Tags: 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
Tags: 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
Posted in Learn Basic Excel | 4 Comments »
Thursday, December 22nd, 2011
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
(more…)
Technorati Tags: 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
Tags: 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
Posted in Learn Basic Excel | No Comments »
Friday, December 16th, 2011
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 add a new column, concatenate data from 3 columns, and delete unwanted columns.
Duration : 0:10:42
(more…)
Technorati Tags: Absolute, change, College, Community, excel, for, Gel, Girvin, Highline, Macro, Mike, Number, Recorded, References, Relative, ROWS
Tags: Absolute, change, College, Community, excel, for, Gel, Girvin, Highline, Macro, Mike, Number, Recorded, References, Relative, ROWS
Posted in Learn Excel Macros | 6 Comments »
Thursday, December 1st, 2011
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 Past Due
4. Formula for Loan Maturity Date
5. Formula for Length in Days for Project
Duration : 0:3:52
(more…)
Technorati Tags: (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
Tags: (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
Posted in Learn Excel Formulas | 6 Comments »
Thursday, December 1st, 2011
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. Last Day in Month: DATE, YEAR, DAY, MONTH functions
8. First Day Next Month: EOMONTH function
9. First Day Next Month: DATE, YEAR, DAY, MONTH Functions
10. Vest Date: EDATE function
11. List of First Day in Month: EOMONTH
12. WORKDAY function — find workday in future given a certain number of days.
13. WEEKDAY function
14. Last Monday: DATE, YEAR, MONTH, DAY and WEEKDAY functions
15. Formula for Days Between Two Dates
16. Formula for Days Between Two Dates, Inclusive
17. Net Working Days with NETWORKINGDAYS Function
Duration : 0:19:6
(more…)
Technorati Tags: .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
Tags: .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
Posted in Learn Excel Formulas | 2 Comments »
Thursday, December 1st, 2011
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 in the row using the MIN function and Mixed Cell References.
3. See how to format top 3 values in a row using a Logical Formula and the LARGE function
4. See how to format bottom 3 values in a row using a Logical Formula and the SMALL function
5. Learn about how to create Mixed Cell References in formulas
Duration : 0:10:7
(more…)
Technorati Tags: 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
Tags: 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
Posted in Learn Excel Formulas | 2 Comments »
Thursday, October 27th, 2011
Excel – Formulas for Percentage
Duration : 0:4:21
(more…)
Technorati Tags: attendance, excel, for, formulas, how to, percentage, software, technology, tutorial
Tags: attendance, excel, for, formulas, how to, percentage, software, technology, tutorial
Posted in Learn Excel Formulas | No Comments »
