Ep 2. Performing Calculations

Microsoft Excel 2016 - Training is a guide to help users navigate and utilize Excel 2016 for maximum productivity. The show delves into various aspects of the software and provides detailed explanations and examples to help users understand and employ the features available.

Season 1 Episode 2, titled "Performing Calculations," focuses on teaching viewers how to perform calculations using Excel. The episode begins with basic arithmetic operations, such as addition, subtraction, multiplication, and division, and then moves on to more complex calculations like using percentage (%) and exponentiation (^).

The host starts by introducing the concept of formulas and functions in Excel. Formulas in Excel begin with an equal sign (=) and can include numbers, cell references, and operators to carry out calculations. Functions, on the other hand, are predefined formulas that can perform specific tasks. The host provides examples of some basic functions available in Excel, such as SUM, AVERAGE, MIN, and MAX.

Next, the episode explains how to use cell references in formulas and the various types of cell references available. Relative cell references, absolute cell references, and mixed cell references are discussed in detail, accompanied by examples to illustrate each type.

Moving on, the episode demonstrates how to use the AutoSum function, which can quickly add up a range of cells without having to type out the formula manually. The host also teaches how to use AutoCalculate, which provides instant results for basic arithmetic operations.

The latter half of the episode covers more advanced calculations, starting with percentages. The host explains how to use the percent symbol (%) in Excel, and demonstrates how to calculate percentages by using formulas and functions. Further, viewers are shown how to use conditional formatting to highlight cells based on percentage values.

The episode also covers how to use exponents in Excel, using both standard arithmetic and functions like POWER and EXP. Other advanced topics covered in this episode include using the IF function to perform conditional calculations and using the ROUND function to round numbers to a specific number of decimal places.

Throughout the episode, viewers are provided with practical examples and tips on how to perform calculations effectively in Excel. The host highlights some common mistakes to avoid when working with formulas, such as using incorrect cell references and forgetting to close brackets in complex formulas.

Overall, "Performing Calculations" is a useful episode for those looking to improve their Excel skills, particularly in the area of calculations and formulas. The episode is presented in a clear and easy-to-follow style, making it accessible for both beginners and intermediate users.