Posts Tagged ‘how’
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, December 15th, 2011
Watch the full course at http://SimonSezIT.com.
Website: http://SimonsezIT.com
Facebook: http://www.facebook.com/SimonSezIT
Twitter: http://twitter.com/SimonsezIT
Duration : 0:5:40
(more…)
Technorati Tags: 2007, AND, Date, excel, formulas, function, functions, how, Logic, Microsoft, ms, office, online, pro, software, spreadsheet, Time, to, training, worksheeet
Tags: 2007, AND, Date, excel, formulas, function, functions, how, Logic, Microsoft, ms, office, online, pro, software, spreadsheet, Time, to, training, worksheeet
Posted in Learn Excel Formulas | 6 Comments »
Tuesday, December 6th, 2011
chrisjterrellhttp://gdata.youtube.com/feeds/api/users/chrisjterrellBoise idHowtoExcel, VBA, Do, While, Loop, How, To, Tutorial, diy, tips & tricks, howtoVBA Excel Do While Loop Tutorial2011-04-05
Duration : 0:3:23
(more…)
Technorati Tags: diy, do, excel, how, loop, to, tutorial, vba, While
Tags: diy, do, excel, how, loop, to, tutorial, vba, While
Posted in Learn Excel Macros | No 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 »
Wednesday, November 16th, 2011
Title says all, email youtube.help@gmx.com for more info or if you need help in excel, thanks.
Sam
Duration : 0:2:16
(more…)
Technorati Tags: Add, Copy, eight8, excel, formulas, Free, geniune, Hack, how, Microsoft, pirate, publisher, seven7, to, use, windows
Tags: Add, Copy, eight8, excel, formulas, Free, geniune, Hack, how, Microsoft, pirate, publisher, seven7, to, use, windows
Posted in Learn Excel Formulas | No Comments »
Thursday, November 10th, 2011
This is an excel 2003 Tutorial on how to use the Hlookup Command
Duration : 0:6:6
(more…)
Technorati Tags: 2003, Command, excel, HLOOKUP, how, on, the, to, tutorial, use
Tags: 2003, Command, excel, HLOOKUP, how, on, the, to, tutorial, use
Posted in Learn Excel Formulas | No Comments »
Wednesday, September 28th, 2011
Download file: https://people.highline.edu/mgirvin/ExcelIsFun.htm
1. Learn about the COUNTIF function and how to use comparative operators in the Criteria argument of the COUNTIF.
2. See how to count “Greater Than 2B”
3. Learn about the hierarchy of the ASCII characters when using Greater than or Less than comparative operators
Duration : 0:5:27
(more…)
Technorati Tags: 2007, 2010, AND, argument, ASCII, characters, College, Community, Comparative, COUNTIF, criteria, Dragons, excel, excelisfun, function, Gel, Girvin, greater, hierarchy, Highline, how, in, less, Mike, of, Operators, OR, Slaying, than, the, to, use, using, when
Tags: 2007, 2010, AND, argument, ASCII, characters, College, Community, Comparative, COUNTIF, criteria, Dragons, excel, excelisfun, function, Gel, Girvin, greater, hierarchy, Highline, how, in, less, Mike, of, Operators, OR, Slaying, than, the, to, use, using, when
Posted in Learn Excel Formulas | 7 Comments »
Saturday, September 17th, 2011
Download file: https://people.highline.edu/mgirvin/ExcelIsFun.htm
Rotate Table:
1. See how to add blank formulas and a row with a zero lookup to the lookup table to help simplify the VLOOKUP function formula
2. See COLUMNS function to increment numbers in a formula to generate column index numbers for VLOOKUP function.
Duration : 0:6:27
(more…)
Technorati Tags: 2007, 2010, Add, AND, blank, College, column, COLUMNS, Community, Dragons, excel, excelisfun, formula, formulas, function, Gel, generate, Girvin, Help, Highline, how, in, increment, INDEX, Lookup, Mike, numbers, row, See, simplify, Slaying, table, the, to, vlookup, with, Zero
Tags: 2007, 2010, Add, AND, blank, College, column, COLUMNS, Community, Dragons, excel, excelisfun, formula, formulas, function, Gel, generate, Girvin, Help, Highline, how, in, increment, INDEX, Lookup, Mike, numbers, row, See, simplify, Slaying, table, the, to, vlookup, with, Zero
Posted in Learn Excel Formulas | 19 Comments »
Thursday, September 1st, 2011
Download file: https://people.highline.edu/mgirvin/ExcelIsFun.htm
1. For the Normal and Standard Normal Curves, see how to calculate an x value given a cumulative probability.
2. Test Scores Example
3. Production Line Example.
4. NORM.INV New Excel 2010 Function
5. NORM.S.INV New Excel 2010 Function
Statistics functions formulas
This is for the Highline Community College Busn 210 Statistical Analysis for Business and Economics taught by Michael Girvin
Duration : 0:7:13
(more…)
Technorati Tags: 2010, 210, an, analysis, AND, business, Busn, calculate, College, Community, cumulative, Curves, Dragons, Economics, excel, excelisfun, find, functions, Gel, Girvin, given, Highline, how, Mike, new, NORM.INV, NORM.S.INV, normal, Probabilities, Probability, See, Slaying, Standard, Statistical, Statistics, to, value
Tags: 2010, 210, an, analysis, AND, business, Busn, calculate, College, Community, cumulative, Curves, Dragons, Economics, excel, excelisfun, find, functions, Gel, Girvin, given, Highline, how, Mike, new, NORM.INV, NORM.S.INV, normal, Probabilities, Probability, See, Slaying, Standard, Statistical, Statistics, to, value
Posted in Learn Excel Formulas | No Comments »
Thursday, September 1st, 2011
Learn how to use formulas in Microsoft Excel at www.teachUcomp.com. A clip from Mastering Excel Made Easy v. 2003. Get the complete tutorial FREE at http://www.teachucomp.com/free – the most comprehensive Excel tutorial available. Visit us today!
Duration : 0:6:9
(more…)
Technorati Tags: 2000, 2002, 2003, 2007, 2010, 97, book, cd, class, classes, course, courses, Download, dvd, excel, excell, Help, how, how to, Micro, Microsoft, ms, office, online, Soft, software, training, tutorial, video, xp
Tags: 2000, 2002, 2003, 2007, 2010, 97, book, cd, class, classes, course, courses, Download, dvd, excel, excell, Help, how, how to, Micro, Microsoft, ms, office, online, Soft, software, training, tutorial, video, xp
Posted in Learn Excel Formulas | No Comments »
