filmov
tv
Highline Excel 2013 Class Video 03: How Formulas Calculate: Order of Precedence in Excel
Показать описание
This is the Highline Community College Class, Spreadsheet Construction taught by Michael Girvin: Basic To Advanced Excel.
How Formulas Calculate: Order of Precedence in Excel. Topics in this video:
Parenthesis ( )
Reference Operators: colon, space, comma
Example of colon in range of cells
Example of intersection operator
Example of comma (union
Negation
Converts %
Exponents
Multiplication (*) and Division (/), left to right
Adding (+) and Subtracting (-), left to right
Ampersand (&) (Join operator)
Comparative operators
How Formulas Calculate: Order of Precedence in Excel. Topics in this video:
Parenthesis ( )
Reference Operators: colon, space, comma
Example of colon in range of cells
Example of intersection operator
Example of comma (union
Negation
Converts %
Exponents
Multiplication (*) and Division (/), left to right
Adding (+) and Subtracting (-), left to right
Ampersand (&) (Join operator)
Comparative operators
Комментарии