Microsoft Excel Formulas and Functions: Betec007

Workshop | January 22 | 1:30-4 p.m. | S300T Haas School of Business

 Keith Samsell

 Human Resources

This course details the process by which calculations are created in Microsoft Excel workbooks. Emphasis is placed on the underlying theory and syntax of formulas and functions, as well as their complimentary abilities and use cases.

Learning Objectives

* Understand the fundamental differences of values vs. formats.
* Use AutoCalculate to display summary information from multiple cells.
* Associate proper syntax characters used in calculations with their intended use including ranges, unions, and intersections. Properly reference cells, ranges, columns, and rows avoiding circular referencing.
* Use mathematic operators and order of operations guidelines to construct formula calculations. Differentiate formula syntax from function syntax.
* Utilize native functions and function forms to construct numeric, text, and date calculations. Develop function calculations manually and through the use of the function library. Differentiate function syntax from formula syntax.
* Unite dynamic cell values with static text strings through the use of both formula concatenation and function concatenation.