Office 2010 Class #22: Excel Formulas: Math Operators and Order Of Operations

Download files at: https://people.highline.edu/mgirvin/AllClasses/216_2003/216/busn216.htm
The Excel 2010 Basics Series shows a systematic description of what Excel can do from beginning to end.
Topics Covered In Video:
1) Excel operator symbols
2) Parenthesis is ()
3) Exponent is ^
4) Multiplication is *
5) Division is /
6) Adding is +
7) Subtracting is --
8) Order of Operations
9) Complete list of how Excel Evaluates formulas
10) Excel 2003: Formula Evaluator: Tools, Formula Auditing, Formula Auditing
11) Excel 2007: Formula Evaluator: Formula Ribbon, Formula Auditing group, Formula Auditing icon

Category:

Education

Tags:

• Office
• 2010
• Mike
• Gel
• Girvin
• excelisfun
• Highline
• Community
• College
• Busn
• 216
• Computer
• Applications
• Class
• Excel
• Math
• Operators
• and
• Order
• Of
• Operations
• Formulas:
• Formula
• Evaluator

[ExcelIsFun]

@sricharanmuppidi , thank you very much for pointing that out!! I added an annotation at that point in the video to let people know it should be 2^4, not 2^2.

[sricharanmuppidi]

Shouldnt the exponential function at minute 8.30 be 2^4 not 2^2?

[ExcelIsFun]

You are welcome!

[ginaezone]

Than you so much for clarifying the Excel mystery, you rock!

[ExcelIsFun]

You are welcome!

[nightworld0092003]

thanks you very much. its very kind of you to go through all these work. this is an excellent video.