Highline Excel Class 02: Excel Formulas & Excel Functions

Download Excel file: http://people.highline.edu/mgirvin/excelisfun.htm Learn about: 1) The different elements of formulas: equal sign, cell references, math operators, comparative operators, built-in functions, ampersand, numbers 2) See the five methods for entering formulas: Enter. Ctrl + Enter, Tab, Shift Tab, Shift Enter 3) Order Of Excel Formula Evaluation 4) Built-in functions like: SUM, AVERAGE, FV, DOLLAR, VLOOKUP, IF 5) Functions in formulas 6) Efficient formula vs. Inefficient formulas Excel Basics, Excel How To, Lessons in Excel This is a beginning to advanced Excel class taught at Highline Community College by Mike Gel excelisfun Girvin Busn 214 BTech 109