Description

Learn how to build a super-charged Excel spreadsheet to help you and your team easily track any kind of data-sales transactions, inventory levels, project statuses, employee paid time off, student progress, household spending, and more. Follow along with Excel MVP Oz du Soleil as he shows how to create a basic spreadsheet and transform it into an effective tracking system for any kind of data that is regularly updated. Learn spreadsheet basics, as well as more advanced techniques such as writing formulas that check that information is complete, protecting and hiding sheets, and creating alerts for deadlines and bad data. Oz wraps up with a challenge that pulls together everything you've learned into a polished final project.

Topics include:
  • Planning your data tracker
  • Adding calculations and graphics
  • Protecting cells and sheets
  • Hiding sheets
  • Setting up alerts with conditional formatting
  • Merging data
  • Categorizing data
  • Formatting your tracker
  • Putting it all together

 Level

This is an Intermediate level learning activity. 

 Length

The total duration of assets in this course is 1h:29m.

 Author & Release date

This course was produced by Oz du Soleil for Lynda.com on 12/16/2019.

 Contact details

For course-related issues please contact LinkedIn Learning. 

For technical issues, please Report an IT Problem in Service Gateway to reach the Agora Team.