Excel
Tracking Data Easily and Efficiently
Heads up! This course may be archived and/or unavailable.
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.
Contents:
- Introduction
- 1. Intro to Tracking Data
- 2. Planning Your Data Tracker
- 3. Tracker Structures
- 4. Protecting Your Work, Sections, and Calculations
- 5. Adjusting Inputs and Calculations
- 6. Pretty It Up!
- 7. Putting It All Together
Get a Reminder
| Rating | Not enough ratings |
|---|---|
| Length | 1h 29m |
| Starts | On Demand (Start anytime) |
| Cost | $29/month (Access to entire library- free trial available) |
| From | LinkedIn Learning |
| Instructor | Oz du Soleil |
| Download Videos | Only via the LinkedIn Learning mobile app |
| Language | English |
| Subjects | Data Science Business |
| Tags | Data Analysis Business Finance Business Analytics Microsoft Excel |
Get a Reminder
Similar Courses
Careers
An overview of related careers and their average salaries in the US. Bars indicate income percentile.
Middle School English Language Development, AVID & AVID Excel Teacher $50k
English Language Development, AVID & AVID Excel Teacher $53k
Excel Reporting Developer $68k
Excel/Access DTS Developers $78k
Excel VBA Developer $82k
Excel/Access DTS Developer $83k
Tutor - Accounting/ Excel /ESL $87k
Write a review
Your opinion matters. Tell us what you think.
Please login to leave a review
| Rating | Not enough ratings |
|---|---|
| Length | 1h 29m |
| Starts | On Demand (Start anytime) |
| Cost | $29/month (Access to entire library- free trial available) |
| From | LinkedIn Learning |
| Instructor | Oz du Soleil |
| Download Videos | Only via the LinkedIn Learning mobile app |
| Language | English |
| Subjects | Data Science Business |
| Tags | Data Analysis Business Finance Business Analytics Microsoft Excel |
Similar Courses
Sorted by relevance
Like this course?
Here's what to do next:
- Save this course for later
- Get more details from the course provider
- Enroll in this course
