Excel Forum
Similar Content
Best Lookup Formula in Excel - Index and Match
Tutorial: A lookup using INDEX and MATCH is like a VLOOKUP without the restrictions.  Index and Ma...
Create a Custom Function in Excel - UDF
Tutorial: How to create a custom worksheet function in Excel. These are called User Defined Function...
Understanding Formulas and Functions in Excel
Tutorial: In this tutorial I will cover the basic concepts of Formulas and Functions in Excel. A for...



Highline Excel Class 02: Excel Formulas & Excel Functions


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





Got a Question? Ask it Here in the Forum.