Microsoft Excel 2: References and Calculations - Hands-on
Microsoft Excel 2: References and Calculations
Description
Calculations in Excel are critical to ‘get right.’ From using appropriate operators and formulas, to controlling the order of operations, to understanding reference types, there are several major concepts to thoroughly understand in this area.
Topics include:
- Using and adjusting relative, absolute, and mixed references in calculations
- Using named ranges and table ranges as references
- Understanding order of operations and using operators effectively
- Adding simple Excel functions to summarize spreadsheet data