From the course: Microsoft Office Specialist: Expert (Office 365 and Office 2019) Cert Prep

Unlock the full course today

Join today to access over 25,200 courses taught by industry experts.

Configure formula calculation options

Configure formula calculation options

From the course: Microsoft Office Specialist: Expert (Office 365 and Office 2019) Cert Prep

Start my 1-month free trial Buy for my team

Configure formula calculation options

“

- [Instructor] Calculation settings control how values are calculated in our workbooks. And to officially use formulas, there are two important options that we need to understand. After watching this video, you'll know and understand how worksheets and workbooks recalculate, how to work with iterative functions where we can run the same formula multiple times based on the amount that is calculated over and over again, and I want you to understand the precision of the calculations in a workbook. Let's take a look at our FormulaCalculation workbook, and we'll first go to File and Options > Formulas and take a look at our workbook calculation settings. The default is to automatically calculate any formulas in your workbook. As soon as you make a change in a cell and exit out of that cell by tabbing our pressing Enter, Excel will automatically calculate or recalculate that formula. Now, we can also change it to automatically…

Contents