Microsoft Excel 1

Microsoft Excel 1

Earn this badge to demonstrate your proficiency in working with Microsoft Excel.

Login to Earn This Badge

Challenges

  • Excel 1

    Requirements

    1. Develop proficiency and understanding in the basic functions of excel by uploading a project that demonstrates the following:

    - Formula’s and Functions

    • Sum and Average
    • Sorting and Filtering in a Table
    • COUNT/ COUNTA
    • Max/Min
    • Naming Ranges
    • IF Function 

    - Absolute References

    - Create a Chart

    - Cell References

    - Use Autofill and Flash Fill

    - Formatting Data

    Resources

    Free training courses offered BYU found at train.byu.edu

    OPTIONAL: Use the provided Excel Spread Sheet Activities found at byu.train.edu to help you demonstrate your proficiency in the excel topics specified above