1 option
Excel : Tracking Data Easily and Efficiently / with Oz du Soleil
- Format:
- Video
- Author/Creator:
- Du Soleil, Oz, speaker.
- Language:
- English
- Genre:
- Instructional films.
- Educational films.
- Physical Description:
- 1 online resource
- Place of Publication:
- Carpenteria, CA : linkedin.com, 2023.
- System Details:
- digital
- Summary:
- Learn how to create data trackers in Excel to track any kind of data-from sales activity and inventory levels to vacation budgets using basic Excel and its newest features.
- Too often, Excel users struggle to effectively track data in Excel because they start with the final report in mind. While this seems intuitive, setting up a spreadsheet in this way limits what a person can get from their data. In this course, follow along with Excel MVP Oz du Soleil as he shows how to use Excel features and functions-including Power Query and dynamic arrays-to build and organize basic spreadsheets and transform them into robust tracking systems for any kind of data that is regularly updated. Learn how to create a tracker in Excel that you and your team can use to easily track any kind of data: sales, donations, inventory levels, project statuses, student progress, household spending, and more. Oz wraps up with challenges that invite you to pull together everything you've learned.
- Participant:
- Presenter: Oz du Soleil
- Notes:
- 8/02/2023
- Access Restriction:
- Restricted for use by site license.
The Penn Libraries is committed to describing library materials using current, accurate, and responsible language. If you discover outdated or inaccurate language, please fill out this feedback form to report it and suggest alternative language.