Building Amazing Organizations
Got Questions?
800‑258‑3837
Back to Course List

Microsoft Excel 2010: Performing Calculations in an Excel Worksheet

Preview video
Preview Video
Course Format
Video on Demand  Video On Demand
Product ID
soniepce_vod
Training Time ?
87 to 92 minutes
Language(s)
English
Video Format
High Definition
Required Plugins
None
Number of Lessons
9
Quiz Questions
5
Question Feedback
Wrong Answer Remediation
Lesson Bookmarking
Interactive Producer
Mastery Training Content Network
Original Content Producer
Sonic Performance Support GmbH
Course screen Course screen Course screen
Overview

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.

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

  • Install on any SCORM LMS
  • Full-screen video presentation
  • Print certificate and wallet card
  • You have 60 days to complete the course
Audience

All Excel 2010 users

Topics
The course presents the following topical areas:
  • 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

© Mastery Technologies, Inc.