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
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. 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.