Chapter 5

Understanding formulas

Getting the most from this chapter

Introduction to formulas

Entering your first formula

Three methods of entering formulas

Entering the same formula in many cells

Use the Table tool to copy a formula

Entering one formula and spilling many results

Excel’s forté is performing calculations. When you use Excel, you typically use a combination of cells with numbers and cells with formulas. After you design a spreadsheet to calculate something, you can change the numbers used in the assumption cells and then watch Excel instantly calculate new results.

Getting the most from this chapter

Even if you think you know about formulas, you should review these points:

  • Everyone should read the “Double-Click the Fill Handle ...

Get Microsoft Excel Inside Out (Office 2021 and Microsoft 365) now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.