View All Courses

Microsoft Excel 2010: Performing Calculations in an Excel Worksheet

9 Lessons
87-92 Minutes
5 Quiz Questions

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

Microsoft Excel 2010: Performing Calculations in an Excel Worksheet thumbnails on a slider
Microsoft Excel 2010: Performing Calculations in an Excel Worksheet thumbnails on a slider
Microsoft Excel 2010: Performing Calculations in an Excel Worksheet thumbnails on a slider
Microsoft Excel 2010: Performing Calculations in an Excel Worksheet thumbnails on a slider

    Key Audience


    All Excel 2010 users

    Course Topics


    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

    Workplaces


    Not Specified

    Course Detail


    Course ID
    soniepce_vod

    Time

    87-92 Min
    Questions
    5

    Languages

    en

    video format

    HD

    captions

    No

    Resources

    No

    Lessons

    9

    Remediation

    Yes

    Bookmarking

    Yes

    Feedback

    Yes

    Microlearning

    no