Share Description
In this course, you will learn :
- 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
Syllabus :
1. Intro to Tracking Data
- Introducing tables
2. Planning Your Data Tracker
- Key features of an effective data tracker
3. Tracker Structures
- Thinking about input, storage, and output
- Incorporating calculations and graphs
- Adding helper columns
4. Protecting Your Work, Sections, and Calculations
- Protecting cells and sheets
- Hidden sheets
5. Adjusting Inputs and Calculations
- Dropdown lists
- Formula triggers
- Setting up alerts with conditional formatting
- Data validation for reasonable values
- Time and dates
- Merging data with VLOOKUP
- Categorizing data with VLOOKUP
- XLOOKUP: The newest function in Office 365
- Bottom-up search with XLOOKUP
- Categorizing data with XLOOKUP
- A horizontal lookup with XLOOKUP
6. Pretty It Up!
- Connecting a value to a shape
- Hiding zeros
- Conditional formatting to warn of critical dates or thresholds
7. Putting It All Together
- Building a tracker: Part one
- Building a tracker: Part two
- Building a tracker: Part three (XLOOKUP)
