Excel - Tracking Data Easily and Efficiently (2023)

Files:

• Get Bonus Downloads Here.url (0.2 KB)
~Get Your Files Here ! 01 - Introduction
• 01 - Efficient data tracking in Excel.mp4 (4.4 MB)
• 01 - Efficient data tracking in Excel.srt (1.1 KB)
02 - 1. Planning Your Data Tracker
• 01 - Introducing tables.mp4 (12.1 MB)
• 01 - Introducing tables.srt (6.7 KB)
• 02 - Key features of an effective data tracker.mp4 (19.7 MB)
• 02 - Key features of an effective data tracker.srt (7.4 KB)
03 - 2. Helpful Data Tracking Features
• 01 - Thinking about input, storage, and output.mp4 (17.2 MB)
• 01 - Thinking about input, storage, and output.srt (7.8 KB)
• 02 - Incorporating charts into your tracker.mp4 (21.6 MB)
• 02 - Incorporating charts into your tracker.srt (8.8 KB)
• 03 - Adding helper columns.mp4 (9.7 MB)
• 03 - Adding helper columns.srt (3.6 KB)
• 04 - Using Slicers to filter for details.mp4 (10.7 MB)
• 04 - Using Slicers to filter for details.srt (4.3 KB)
• 05 - Summary pages and dashboards.mp4 (15.9 MB)
• 05 - Summary pages and dashboards.srt (5.3 KB)
• 06 - Ad hoc vs. at-a-glance needs.mp4 (13.6 MB)
• 06 - Ad hoc vs. at-a-glance needs.srt (5.2 KB)
04 - 3. Protecting Your Work and Calculations
• 01 - Protecting cells and sheets.mp4 (17.6 MB)
• 01 - Protecting cells and sheets.srt (8.1 KB)
• 02 - Hidden sheets.mp4 (8.2 MB)
• 02 - Hidden sheets.srt (4.0 KB)
• 03 - Hidden columns and rows.mp4 (12.9 MB)
• 03 - Hidden columns and rows.srt (5.9 KB)
05 - 4. Managing Inputs and Calculations
• 01 - Using dropdown lists for accuracy and consistency.mp4 (23.5 MB)
• 01 - Using dropdown lists for accuracy and consistency.srt (10.7 KB)
• 02 - Applying formula triggers to prevent inaccurate results.mp4 (10.0 MB)
• 02 - Applying formula triggers to prevent inaccurate results.srt (5.1 KB)
• 03 - Using cross-footing as a check for data quality.mp4 (16.4 MB)
• 03 - Using cross-footing as a check for data quality.srt (5.0 KB)
• 04 - Data validation for reasonable values.mp4 (14.0 MB)
• 04 - Data validation for reasonable values.srt (5.5 KB)
• 05 - Times Checking data quality.mp4 (6.2 MB)
• 05 - Times Checking data quality.srt (3.2 KB)
06 - 5. Midterm Building a Tracker
• 01 - Challenge Building a data tracker for event details.mp4 (5.3 MB)
• 01 - Challenge Building a data tracker for event details.srt (2.3 KB)
• 02 - Solution Building a data tracker for event details.mp4 (16.4 MB)
• 02 - Solution Building a data tracker for event details.srt (7.2 KB)
07 - 6. Dynamic Arrays and the New Excel Calculation Engine
• 01 - Dynamic Arrays One formula, many results.mp4 (17.6 MB)
• 01 - Dynamic Arrays One formula, many results.srt (6.8 KB)
• 02 - Dynamic Arrays FILTER, UNIQUE, SORT.mp4 (25.6 MB)
• 02 - Dynamic Arrays FILTER, UNIQUE, SORT.srt (10.6 KB)
• 03 - Dynamic Arrays TOCOL, dropdowns, and conditional formatting.mp4 (18.7 MB)
• 03 - Dynamic Arrays TOCOL, dropdowns, and conditional formatting.srt (7.2 KB)
08 - 7. VLOOKUP and XLOOKUP
• 01 - VLOOKUP.mp4 (13.0 MB)
• 01 - VLOOKUP.srt (5.0 KB)
• 02 - Categorizing bonuses with VLOOKUP.mp4 (9.6 MB)
• 02 - Categorizing bonuses with VLOOKUP.srt (3.5 KB)
• 03 - Merging data with XLOOKUP.mp4 (14.3 MB)
• 03 - Merging data with XLOOKUP.srt (5.9 KB)
• 04 - Categorizing bonuses with XLOOKUP.mp4 (9.2 MB)
• 04 - Categorizing bonuses with XLOOKUP.srt (4.7 KB)
09 - 8. PivotTable Basics
• 01 - What is a PivotTable.mp4 (28.0 MB)
• 01 - What is a PivotTable.srt (10.6 KB)
• 02 - Preparing and connecting a PivotTable to your data.mp4 (22.5 MB)
• 02 - Preparing and connecting a PivotTable to your data.srt (8.4 KB)
• 03 - Building and using a PivotTable.mp4 (21.5 MB)
• 03 - Building and using a PivotTable.srt (7.6 KB)
10 - 9. Using Power Query to Clean, Format, and Automate
• 01 - Power Query overview.mp4 (35.7 MB)
• 01 - Power Query overview.srt (12.5 KB)
• 02 - Splitting columns.mp4 (17.8 MB)
• 02 - Splitting columns.srt (8.2 KB)
• 03 - Append in Power Query.mp4 (25.7 MB)
• 03 - Append in Power Query.srt (11.3 KB)
• 04 - Unpivot and fill-down.mp4 (26.5 MB)
• 04 - Unpivot and fill-down.srt (10.8 KB)
11 - 10. Pretty It Up!
• 01 - Data bars for easy visual comparison.mp4 (5.4 MB)
• 01 - Data bars for easy visual comparison.srt (2.6 KB)
• 02 - Connecting a value to a shape.mp4 (14.8 MB)
• 02 - Connecting a value to a shape.srt (6.3 KB)
• 03 - Hiding zeroes.mp4 (7.4 MB)
• 03 - Hiding zeroes.srt (2.9 KB)
• 04 - Conditional formatting to warn of deadlines.mp4 (20.2 MB)
• 04 - Conditional formatting to warn of deadlines.srt (8.5 KB)
12 - 11. Get Hands On
• 01 - Challenge Building a tracker 1.mp4 (4.1 MB)
• 01 - Challenge Building a tracker 1.srt (1.4 KB)
• 02 - Solution Building a tracker 1.mp4 (14.4 MB)
• 02 - Solution Building a tracker 1.srt (5.0 KB)
• 03 - Challenge Building a tracker 2.mp4 (7.4 MB)
• 03 - Challenge Building a tracker 2.srt (3.1 KB)
• 04 - Solution Building a tracker 2.mp4 (34.6 MB)
• 04 - Solution Building a tracker 2.srt (10.1 KB)
13 - Conclusion
• 01 - Continue your data tracking journey in Excel.mp4 (5.2 MB)
• 01 - Continue your data tracking journey in Excel.srt (1.4 KB)
• Bonus Resources.txt (0.4 KB)
Ex_Files_Excel_Tracking_Data_Easily Exercise Files Chap 01
• Features of an effective data tracker.xlsx (28.0 KB)
• Introducing tables.xlsx (10.0 KB)
Chap 02
• Ad hoc vs at-a-glance needs.xlsx (28.0 KB)
• Input Storage Output.xlsx (632.9 KB)
• Integrating charts.xlsx (28.0 KB)
• Slicers.xlsx (157.9 KB)
• Summaries.xlsx (32.9 KB)
• Using Helper Columns.xlsx (546.5 KB)
Chap 03
• Hiding Worksheets.xlsx (28.8 KB)
• Hiding rows and columns.xlsx (20.6 KB)
• Protecting cells, sheets and formulas.xlsx (27.4 KB)
Chap 04
• Checking Times.xlsx (11.0 KB)
• Crossfooting.xlsx (20.0 KB)
• Data validation for reasonable values.xlsx (399.4 KB)
• Dropdown Lists.xlsx (13.2 KB)
• Formula Triggers.xlsx (13.3 KB)
Chap 05
• Building an event tracker - FINAL.xlsx (14.9 KB)
• Building an event tracker.xlsx (13.9 KB)
Chap 06
• Dynamic Arrays - 1 formula many results.xlsx (86.0 KB)
• Dynamic Arrays - FILTER SORT.xlsx (92.7 KB)
• Dynamic Arrays TOCOL.xlsx (129.4 KB)
Chap 07
• Categorizing bonuses with VLOOKUP.xlsx (418.9 KB)
• Categorizing data with XLOOKUP.xlsx (11.7 KB)
• VLOOKUP.xlsx (263.8 KB)
• XLOOKUP.xlsx (264.3 KB)
Chap 08
• Building and Using a Pivot Table.xlsx (14.4 KB)
• Prepping data for a Pivot Table.xlsx (14.4 KB)
• What is a Pivot Table.xlsx (14.1 KB)
Chap 09
• Append.xlsx (17.6 KB)
• Power Query Overview.xlsx (14.9 KB)
• Splitting Columns.xlsx (630.0 KB)
• Unpivot - Fill Down.xlsx (113.0 KB)
Chap 10
• CF to warn of deadlines.xlsx (13.0 KB)
• Connecting a Value to a Shape.xlsx (14.0 KB)
• Data Bars.xlsx (9.6 KB)
• Hiding Zeros.xlsx (15.5 KB)
Chap 11
• Build a Tracker - Dropdown List FINAL.xlsx (70.8 KB)
• Build a Tracker - Dropdown List.xlsx (66.8 KB)
• Tracker - Skydiving FINAL.xlsx (154.6 KB)
• Tracker - Skydiving.xlsx (152.6 KB)