From the course: Cert Prep: Excel Expert - Microsoft Office Specialist for Office 2019 and Office 365
Unlock the full course today
Join today to access over 22,600 courses taught by industry experts or purchase this course individually.
Configure formula calculation options
From the course: Cert Prep: Excel Expert - Microsoft Office Specialist for Office 2019 and Office 365
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…
Practice while you learn with exercise files
Download the files the instructor uses to teach the course. Follow along and learn by watching, listening and practicing.
Contents
-
-
-
-
(Locked)
Enable macros3m 38s
-
(Locked)
Create simple macros and copy to another workbook7m 10s
-
(Locked)
Reference data in other workbooks7m 36s
-
(Locked)
Manage workbook versions6m 17s
-
(Locked)
Protect workbooks and worksheets7m 37s
-
(Locked)
Configure formula calculation options9m 52s
-
(Locked)
Manage comments5m 11s
-
(Locked)
Configure editing and display languages4m 58s
-
(Locked)
Challenge: Manage workbook options and settings2m 1s
-
(Locked)
Solution: Manage workbook options and setting9m 37s
-
(Locked)
-
-
-
-
-