Tag Archives: cell

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

Refer to an Excel Table Field When Writing Formulas

Posted on December 12, 2011 by admin

If you are using either Excel 2007 or Excel 2010, I encourage you to “format your data range” as an Excel Table. When you do this you can take advantage of several Table Tools: 1) The range references for the … Continue reading →

Posted in Learn Excel Formulas | Tagged business, cell, data, Educational, excel, formulas, functions, in, information, management, Microsoft Excel, Microsoft Office, named, office, range, software, Software Tutorial, tables, technology, training, tutorial | 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 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

Microsoft Excel Tutorial for Beginners #3 – Calculations (Formulas)

Posted on October 31, 2011 by admin

Visit MotionTraining at http://www.motiontrainingweb.com Tutorial #3 introduces calculations and explains the basic mathematical operators in Microsoft Excel. Duration : 0:8:39 Technorati Tags: Beginners, calculations, cell, computer, data, excel, formula, function, Guide, Help, Microsoft, Microsoft Excel, ms, Reference, software, spreadsheet, technology, … Continue reading →

Posted in Learn Excel Formulas | Tagged Beginners, calculations, cell, computer, data, excel, formula, function, Guide, Help, Microsoft, Microsoft Excel, ms, Reference, software, spreadsheet, technology, tips, tricks, tutorial | 25 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

What is an Excel Function? – ExcelVBASql.com 25+ hours of FREE training!

Posted on August 24, 2011 by admin

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

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

350 Excel Function Library – – ExcelVBASql.com 25+ hours of FREE training!

Posted on August 12, 2011 by admin

www.ExcelVBASQL.com Duration : 0:5:50 Technorati Tags: Absolute, AND, auto, bar, buttons, cell, column, Copy, cut, drag, excel, Fill, formula, function, functions, Help, interface, Is, keys, Lessons, Library, logincal, Microsoft, ms, Names, OR, past, Reference, Relative, Ribbon, row, shortcut, Special, spreadsheets, … 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, Library, logincal, Microsoft, ms, Names, OR, past, Reference, Relative, Ribbon, row, shortcut, Special, spreadsheets, status, tutorial | Leave a comment

HLookUp function in Excel 2010

Posted on August 3, 2011 by admin

A brief look at Excels HLookUp function in Excel 2010 Duration : 0:1:32 Technorati Tags: 2010, Acos, business, cell, computer, data, excel, formula, function, functions, Help, HLOOKUP, howto, information, learn, Microsoft, need, office, please, software, system, Systems, technology, tips, training, … Continue reading →

Posted in Learn Excel Formulas | Tagged 2010, Acos, business, cell, computer, data, excel, formula, function, functions, Help, HLOOKUP, howto, information, learn, Microsoft, need, office, please, software, system, Systems, technology, tips, training, tricks, tutorial, video | Leave a comment