Author
Updated
12/16/2019Released
4/3/2018- 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
Skill Level Intermediate
Duration
Views
- [Oz] You've got data you need to track, students in a curriculum, websites visits, expenses, sports data. That means you have a data set that you regularly need to add to, remove from, or update. The data set is living. It's dynamic. So what's the best way to set up your data to get the most from Excel and make your life easier? This course looks at the fundamentals of setting your data up so that it can be tracked effectively. In this course, we cover a lot.
That includes dynamic spreadsheet layout, writing formulas that check for complete information, protecting your calculations against mistakes and nosy people, creating alerts for upcoming deadlines and strange entries, and the course wraps up with two opportunities to apply what you've learned. Let's get at it.
Related Courses
-
Monday Productivity Pointers
with Jess Stratton8h 1m Intermediate -
Excel: Creating a Basic Dashboard
with Curt Frye1h 31m Intermediate
-
Introduction
-
Welcome56s
-
-
1. Intro to Tracking Data
-
Introducing tables3m 7s
-
2. Planning Your Data Tracker
-
3. Tracker Structures
-
Adding helper columns2m 14s
-
4. Protecting Your Work, Sections, and Calculations
-
Hidden sheets2m 19s
-
5. Adjusting Inputs and Calculations
-
Dropdown lists3m 28s
-
Formula triggers3m 1s
-
Time and dates1m 34s
-
Merging data with VLOOKUP2m 17s
-
-
6. Pretty It Up!
-
Hiding zeros1m 33s
-
7. Putting It All Together
-
Building a tracker: Part one7m 32s
-
Building a tracker: Part two7m 28s
-
- Mark as unwatched
- Mark all as unwatched
Are you sure you want to mark all the videos in this course as unwatched?
This will not affect your course history, your reports, or your certificates of completion for this course.
CancelTake notes with your new membership!
Type in the entry box, then click Enter to save your note.
1:30Press on any video thumbnail to jump immediately to the timecode shown.
Notes are saved with you account but can also be exported as plain text, MS Word, PDF, Google Doc, or Evernote.
Share this video
Embed this video
Video: Welcome