Lesson 3-1 from: Microsoft Excel 2013 Expert Skills (167 Video Lessons)

Quality

LOW

Captions

OFF
Transcript

OFF

Speed

1x

Understand Excel order of precedence rules and Excel Formula Evaluate

Play The Video

ExcelCentral.com

Play

Back 10 Seconds

Slower

Faster

Full Screen View

Online Video Course: | Microsoft Excel 2013 Expert Skills | |
---|---|---|

Session: | Session 3: Advanced Functions | |

Lesson: | Lesson 3-1 Understand Excel order of precedence rules and Excel Formula Evaluate | |

Description: |
The order of precedence in Excel formulas (which mathematical operators are evaluated first) is simply explained in this video lesson that explains how rules work when evaluating formulas and how brackets can be used to control precedence and make formulas more readable in Microsoft Excel. This lesson also demonstrates how to use the Excel Evaluate Formula feature to see exactly how a formula is processed by Excel and the order in which each part of the formula is calculated. |