Excel Advanced Performing Calculations
ADVANCED Performing Calculations
Learn to create worksheet formulas insert functions and reuse formulas and functions in Excel.
Performing Calculations Overview
Performing calculations in Excel brings together worksheet formulas, functions, and efficient reuse of calculations across a worksheet.
Build the calculation correctly first, then reuse it where the same calculation pattern is required.
Essential Terms
Review the core terms used when creating and reusing calculations.
Create Worksheet Formulas
Worksheet formulas calculate results from values and cell references entered in a worksheet.
Formula Structure
A useful formula combines the required references and calculation operators in a structure Excel can evaluate.
Direct Calculation
A formula can calculate from worksheet values or references, such as =B2*C2.
Referenced Calculation
Using cell references allows the result to respond when the referenced worksheet values change.
Insert Functions
Functions provide predefined calculations that can be inserted into worksheet formulas.
Reuse Formulas and Functions
Reuse existing calculations when the same logic is needed elsewhere instead of rebuilding each calculation from the beginning.
Interactive Calculation Explorer
Compare the three calculation tasks covered in this topic.
Key Takeaways
Keep these principles in mind when performing calculations.
Worksheet formulas create calculations, functions provide predefined calculations, and existing formulas and functions can be reused where appropriate.
After creating or reusing a calculation, confirm that it refers to the intended worksheet data and returns the expected result.
Knowledge Check
Test your understanding of worksheet formulas, functions, and calculation reuse.