Tag Archives: AND

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

A K Singh Begusarai (Excel Formulas and Functions).wmv

Posted on November 30, 2011 by admin

this video using the some important formula and function. By A K Singh Shekhpura, Nawkothi, Begusarai Duration : 0:7:50 Technorati Tags: AND, Begusarai, excel, formulas, functions, Singh

Posted in Learn Excel Formulas | Tagged AND, Begusarai, excel, formulas, functions, Singh | Leave a comment

Excel OR() Function – ExcelVBASql.com 25+ hours of FREE training!

Posted on November 11, 2011 by admin

www.ExcelVBASql.com Duration : 0:23:42 Technorati Tags: Absolute, AND, auto, bar, buttons, cell, column, Copy, cut, drag, excel, Fill, formula, function, functions, Help, interface, Is, keys, Lessons, logincal, Microsoft, ms, Names, OR, past, Reference, Relative, Ribbon, row, shortcut, Special, spreadsheets, status, … Continue reading →

Posted in Learn Excel Formulas | Tagged Absolute, AND, auto, bar, buttons, cell, column, Copy, cut, drag, excel, Fill, formula, function, functions, Help, interface, Is, keys, Lessons, logincal, Microsoft, ms, Names, OR, past, Reference, Relative, Ribbon, row, shortcut, Special, spreadsheets, status, tutorial | Leave a comment

Excel AND() Function – ExcelVBASql.com 25+ hours of FREE training!

Posted on November 10, 2011 by admin

www.ExcelVBASql.com Duration : 0:27:9 Technorati Tags: Absolute, AND, auto, bar, buttons, cell, column, Copy, cut, drag, excel, Fill, formula, function, functions, Help, interface, Is, keys, Lessons, logincal, Microsoft, ms, Names, past, Reference, Relative, Ribbon, row, shortcut, Special, spreadsheets, status, tutorial

Posted in Learn Excel Formulas | Tagged Absolute, AND, auto, bar, buttons, cell, column, Copy, cut, drag, excel, Fill, formula, function, functions, Help, interface, Is, keys, Lessons, logincal, Microsoft, ms, Names, past, Reference, Relative, Ribbon, row, shortcut, Special, spreadsheets, status, tutorial | Leave a comment

Office 2010 Class #24: Excel Functions COUNTIF & SUMIF Count and Add with one Condition (Criteria)

Posted on October 14, 2011 by admin

The Excel 2010 Basics Series shows a systematic description of what Excel can do from beginning to end. Download files at: https://people.highline.edu/mgirvin/AllClasses/216_2003/216/busn216.htm Topics Covered In Video: 1. Learn how to use the Excel Functions COUNTIF & SUMIF Count and Add … Continue reading →

Posted in Learn Excel Formulas | Tagged 2010, 216, Add, AND, applications, Busn, class, College, Community, computer, Condition, count(), COUNTIF, Create, criteria, Defined, excel, excelisfun, formulas, From, functions, Gel, Girvin, Highline, in, manager, Mike, name, Names, office, one, Selection, SumIF, with | 4 Comments

Excel Magic Trick 810: RANKIF Function RANK IF: Ranking With Conditions

Posted on October 6, 2011 by admin

Download file: https://people.highline.edu/mgirvin/ExcelIsFun.htm 1. There is no such thing as RANKIF Function, but you can use SUMPRODUCT to RANK with Conditions or Criteria 2. See how to rank studnt’s scores by department (like Marketing, Accounting, Finance, etc.) 3. Arrays of … Continue reading →

Posted in Learn Excel Formulas | Tagged 2007, 2010, AND, arrays, College, Community, conditions, converted, criteria, Double, Dragons, excel, excelisfun, function, Gel, Girvin, Highline, IF, Mike, Negative, ones, Rank, RANKIF, Ranking, Slaying, SUMPRODUCT, to, using, with, zeroes | 6 Comments

Excel 2010 Business Math 04: Range Functions Rule!

Posted on October 5, 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: 1. See how the SUM function and Ranges of Cells are much more efficient than cell … Continue reading →

Posted in Learn Excel Formulas | Tagged 2010, Adding, AND, are, business, calculations, cell, cells, College, Community, Dragons, efficient, excel, excelisfun, for, formulas, function, functions, Girvin, Highline, math, mathematics, Mike, more, much, numbers, of, plus, ranges, References, Slaying, SUM, Symbol, than, the | 2 Comments

YTL Excel #120: Formula To Wrap Text

Posted on October 5, 2011 by admin

See how to create a formula that will join the content of six cells and create Word Wrap using the TEXT and CHAR functions Duration : 0:5:55 Technorati Tags: AND, cells, CHAR, College, Community, content, Create, excel, functions, Gel, Girvin, … Continue reading →

Posted in Learn Excel Formulas | Tagged AND, cells, CHAR, College, Community, content, Create, excel, functions, Gel, Girvin, Highline, Join, Mike, six, text, Word, Wrap | 5 Comments

Excel 2010 Business Math 14: Exponents in Excel Formulas and Formatting

Posted on October 1, 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: 1. Exponents in Excel Formulas 2. Exponents in Cells as Text — see how to convert … Continue reading →

Posted in Learn Excel Formulas | Tagged 2010, AND, apostrophe, applying, before, business, College, Community, convert, Dragons, excel, excelisfun, Exponents, Font, Formatting, formulas, Girvin, Highline, in, lead, math, mathematics, Mike, Number, Slaying, Superscript, text, to | Leave a comment

Excel Magic Trick 803: COUNTIF Function Criteria & Comparative Operator Trouble & ASCII Characters

Posted on September 28, 2011 by admin

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 … Continue reading →

Posted in Learn Excel Formulas | Tagged 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 | 7 Comments