Live stream preview

Watch this video and more on SkillSprints

Watch this video and more on SkillSprints

Start your free trial

Already subscribed? Sign in

Absolute and Relative References

Excel: Minutes to Mastery • 2m 32s

Up Next in Excel: Minutes to Mastery

  • Common Functions

    Learn a variety of basic functions available in Excel, including SUM, AVERAGE, MIN, and MAX, and how to apply them to a range of cells, thereby enabling the student to perform basic statistical analyses on data.

  • Sorting and Filtering Data

    This video will introduce tools to sort and filter data, teaching how to organize data in alphabetical order, reverse sort, and create custom sorts using multiple criteria. It also demonstrates how to filter records based on specific requirements, such as only displaying products from certain yea...

  • Freezing Panels

    In the second video, the concept of 'Freezing Panes' will be discussed, a feature that assists in maintaining the visibility of column or row labels when navigating through large spreadsheets.