Tag Archives: cell
HLookUp function in Excel 2010
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
Microsoft Excel Tutorial for Beginners #16 – Using The ‘IF’ Function
Learn how to use the IF Function. This is a very useful Excel function that can make your spreadsheets easier to read by giving you useful messages based on other values. More tutorials soon! Duration : 0:8:4 Technorati Tags: Absolute, … Continue reading
Excel Busn Math 06: Relative & Absolute Cell References
Learn About the importance of Cell References in Excel formulas and functions. Learn about a Relative and Absolute Cell references in Excel formulas. This is a beginning to end video series for the Business Mathematics / Excel Class, Busn 135 … Continue reading
Tour Of Excel: Formulas, Formatting, Sort, Filter, PivotTables, Charts, Keyboards
Download workbook: http://people.highline.edu/mgirvin/ExcelIsFun.htm (all the way at bottom in “Other Excel Series” section) Highline Community College Science Seminar: The Wonders Of Excel, May 20, 2011 Learn about the wonders of what excel can do with a tour of the different … Continue reading
Posted in Learn Excel Formulas
Tagged 20, 2010, 2011, Absolute, AND, cell, charts, College, Community, Copy, Date, Decimal, excel, excelisfun, filtering, Format, formulas, Gel, Girvin, Highline, keyboard, Magic, May, Mike, Number, of, paste, percentage, Pivot, pivotcharts, pivottables, References, Relative, science, Seminar, Sorting, Special, table, the, Wonders
19 Comments
Office 2010 Class #26: Excel Assumption Tables (Formula Inputs) & Cell Ranges in Functions
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. Orientating Assumption Tables for Formula Inputs for Maximum Efficiency so that you can … Continue reading
Posted in Learn Excel Formulas
Tagged 2010, 216, applications, Assumption, Busn, cell, cells, class, College, Community, computer, efficiency, excel, excelisfun, for, formula, function, Gel, Girvin, Highline, individual, Inputs, instead, Maximum, Mike, of, office, Orientating, ranges, SUM, tables
Leave a comment
Office 2010 Class #38: Excel IF Function Formula Made Easy (7 examples)
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. Use IF function to put one of two things into a cell or … Continue reading
Posted in Learn Excel Formulas
Tagged 2010, 216, applications, are, balance., bonus, Busn, cell, Checking, class, College, Community, computer, excel, excelisfun, formula, function, Gel, Girvin, Highline, IF, in, Logical, Mike, numbers, of, office, one, OR, Put, See, Test, to, Two, Words
Leave a comment
Office 2010 Class #21: Excel Formulas & Functions: Formula Inputs Numbers or Cell References?
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. Equal Sign 2. Use Cell References for formula Inputs any time a number … Continue reading
Posted in Learn Excel Formulas
Tagged 2010, 216, Ampersand, AND, applications, box, Busn, calculating, cell, class, College, Community, computer, currency, dialog, DOLLAR, EFFECT, excel, excelisfun, façade, finance, Formatting, formula, formulas, function, functions, Gel, Girvin, Highline, Inputs, Insert, Is, Join, Mike, numbers, office, OR, pmt, References, Symbol, text
Leave a comment
Excel Basics #6: Names Cell Ranges and Functions
The Excel Basics Series shows a systematic description of what Excel can do from beginning to end. #6 Video topics: 1)Name a range of cells 2)Name box 3)COUNT function 4)MAX function 5)MIN function 6)SUM function 7)COUNTIF function 8)SUMIF function 9)STDEVP … Continue reading
Excel Magic Trick 675: Double VLOOKUP Custom Formula Dynamic Data Validation
See how create a data validation using Custom Logical Formula with 2 VLOOKUP functions that will change when different products are entered. For example, if shirt product is entered, the data validation will let only values between $50 and $100 … Continue reading
