Microsoft Excel 2010: Performing Calculations in an Excel Worksheet

After you’ve entered data in Microsoft Excel, you may need to perform some calculations with it. These calculations could range from simple addition and subtraction to more complicated functions such as averaging and rounding. Excel has functions and formulas to help you make your calculations, and this video-based training instructs you how to use them.

While you have these formulas at your disposal, you may also have to shift around the cells carrying the original data. This video training explains how to use references to keep your formulas using the correct data. These references can either be relative or absolute, depending on whether or not you want Excel to automatically shift the calculations to fit with your movement of the cells. Utilize the information presented here to aid you in your use of Microsoft Excel, creating a much simpler, and efficient, experience.

   This course is in the Video On Demand format, to read about Video On Demand features click here.

All Excel 2010 users

• Performing Calculations in Excel
• Creating Formulas in a Worksheet
• The Sum Function
• Average, Minimum and Maximum
• The Count Function
• The Round Function
• Changing and Deleting Cell Contents
• Relative References
• Absolute References

• Windows 8.1: Customizing the Windows 8.1 Environment
• Windows 8.1: Working with Desktop Applications
• Windows 8.1: Getting to Know PCs and the Windows 8.1 User Interface