• Reference cells
• Work with formulas
• Use functions
• Work with tables
• Organize data with worksheets
Excel enables you to perform powerful calculations easily using formulas and functions. Formulas are mathematical statements that follow a set of rules and use a specific syntax. In this chapter you will learn how to reference and locate cells used in formulas, and how to build and work with formulas. Functions—readymade formulas that you can use to get quick results for specific applications, such as figuring out loan payments—are also covered. Tables, though available ...