Excel Session 2: Start Using Formulas the Right Way (Beginners Guide)

In this lesson, we take the next step in Excel. In Session 1, you learned how to organize information clearly. Now, we begin working with that information. Because Excel becomes powerful when numbers begin to work together. In this session, you will learn: 1. How Excel knows where information is (cell addresses) 2. How to work with groups of cells (ranges) 3. The most important symbol in Excel (=) 4. How to perform calculations ( + − × ÷ ) 5. The difference between formulas and functions 6. How to use SUM, AVERAGE, and RANK 7. How to copy formulas correctly 8. How to keep part of a formula fixed This is where Excel starts making sense.