Excel: Tracking Data Easily and Efficiently.
(Online Course)
Author
Contributors
Published
Carpenteria, CA linkedin.com, 2023.
Format
Online Course
Status
Description
Loading Description...
Also in this Series
Checking series information...
More Details
Language
English
Notes
General Note
8/02/202312:00:00AM
Participants/Performers
Presenter: Oz du Soleil
Description
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.
Description
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.
System Details
Latest version of the following browsers: Chrome, Safari, Firefox, or Internet Explorer. Adobe Flash Player Plugin. JavaScript and cookies must be enabled. A broadband Internet connection.
Citations
APA Citation, 7th Edition (style guide)
du Soleil, O. (2023). Excel: Tracking Data Easily and Efficiently . linkedin.com.
Chicago / Turabian - Author Date Citation, 17th Edition (style guide)du Soleil, Oz. 2023. Excel: Tracking Data Easily and Efficiently. linkedin.com.
Chicago / Turabian - Humanities (Notes and Bibliography) Citation, 17th Edition (style guide)du Soleil, Oz. Excel: Tracking Data Easily and Efficiently linkedin.com, 2023.
MLA Citation, 9th Edition (style guide)du Soleil, Oz. Excel: Tracking Data Easily and Efficiently linkedin.com, 2023.
Note! Citations contain only title, author, edition, publisher, and year published. Citations should be used as a guideline and should be double checked for accuracy. Citation formats are based on standards as of August 2021.