|
Please note that this page does not hosts or makes available any of the listed filenames. You
cannot download any of those files from here.
|
| 01 - Challenge Building a data tracker for event details.mp4 |
5.27MB |
| 01 - Challenge Building a data tracker for event details.srt |
2.33KB |
| 01 - Challenge Building a tracker 1.mp4 |
4.08MB |
| 01 - Challenge Building a tracker 1.srt |
1.44KB |
| 01 - Continue your data tracking journey in Excel.mp4 |
5.19MB |
| 01 - Continue your data tracking journey in Excel.srt |
1.35KB |
| 01 - Data bars for easy visual comparison.mp4 |
5.37MB |
| 01 - Data bars for easy visual comparison.srt |
2.65KB |
| 01 - Dynamic Arrays One formula, many results.mp4 |
17.57MB |
| 01 - Dynamic Arrays One formula, many results.srt |
6.85KB |
| 01 - Efficient data tracking in Excel.mp4 |
4.39MB |
| 01 - Efficient data tracking in Excel.srt |
1.07KB |
| 01 - Introducing tables.mp4 |
12.14MB |
| 01 - Introducing tables.srt |
6.71KB |
| 01 - Power Query overview.mp4 |
35.73MB |
| 01 - Power Query overview.srt |
12.48KB |
| 01 - Protecting cells and sheets.mp4 |
17.57MB |
| 01 - Protecting cells and sheets.srt |
8.13KB |
| 01 - Thinking about input, storage, and output.mp4 |
17.22MB |
| 01 - Thinking about input, storage, and output.srt |
7.76KB |
| 01 - Using dropdown lists for accuracy and consistency.mp4 |
23.50MB |
| 01 - Using dropdown lists for accuracy and consistency.srt |
10.71KB |
| 01 - VLOOKUP.mp4 |
13.05MB |
| 01 - VLOOKUP.srt |
4.97KB |
| 01 - What is a PivotTable.mp4 |
28.02MB |
| 01 - What is a PivotTable.srt |
10.58KB |
| 02 - Applying formula triggers to prevent inaccurate results.mp4 |
10.04MB |
| 02 - Applying formula triggers to prevent inaccurate results.srt |
5.06KB |
| 02 - Categorizing bonuses with VLOOKUP.mp4 |
9.65MB |
| 02 - Categorizing bonuses with VLOOKUP.srt |
3.48KB |
| 02 - Connecting a value to a shape.mp4 |
14.83MB |
| 02 - Connecting a value to a shape.srt |
6.30KB |
| 02 - Dynamic Arrays FILTER, UNIQUE, SORT.mp4 |
25.60MB |
| 02 - Dynamic Arrays FILTER, UNIQUE, SORT.srt |
10.57KB |
| 02 - Hidden sheets.mp4 |
8.22MB |
| 02 - Hidden sheets.srt |
4.00KB |
| 02 - Incorporating charts into your tracker.mp4 |
21.62MB |
| 02 - Incorporating charts into your tracker.srt |
8.81KB |
| 02 - Key features of an effective data tracker.mp4 |
19.67MB |
| 02 - Key features of an effective data tracker.srt |
7.42KB |
| 02 - Preparing and connecting a PivotTable to your data.mp4 |
22.53MB |
| 02 - Preparing and connecting a PivotTable to your data.srt |
8.35KB |
| 02 - Solution Building a data tracker for event details.mp4 |
16.36MB |
| 02 - Solution Building a data tracker for event details.srt |
7.20KB |
| 02 - Solution Building a tracker 1.mp4 |
14.45MB |
| 02 - Solution Building a tracker 1.srt |
5.00KB |
| 02 - Splitting columns.mp4 |
17.76MB |
| 02 - Splitting columns.srt |
8.22KB |
| 03 - Adding helper columns.mp4 |
9.74MB |
| 03 - Adding helper columns.srt |
3.63KB |
| 03 - Append in Power Query.mp4 |
25.71MB |
| 03 - Append in Power Query.srt |
11.30KB |
| 03 - Building and using a PivotTable.mp4 |
21.47MB |
| 03 - Building and using a PivotTable.srt |
7.65KB |
| 03 - Challenge Building a tracker 2.mp4 |
7.41MB |
| 03 - Challenge Building a tracker 2.srt |
3.08KB |
| 03 - Dynamic Arrays TOCOL, dropdowns, and conditional formatting.mp4 |
18.74MB |
| 03 - Dynamic Arrays TOCOL, dropdowns, and conditional formatting.srt |
7.17KB |
| 03 - Hidden columns and rows.mp4 |
12.88MB |
| 03 - Hidden columns and rows.srt |
5.92KB |
| 03 - Hiding zeroes.mp4 |
7.41MB |
| 03 - Hiding zeroes.srt |
2.89KB |
| 03 - Merging data with XLOOKUP.mp4 |
14.34MB |
| 03 - Merging data with XLOOKUP.srt |
5.92KB |
| 03 - Using cross-footing as a check for data quality.mp4 |
16.37MB |
| 03 - Using cross-footing as a check for data quality.srt |
5.04KB |
| 04 - Categorizing bonuses with XLOOKUP.mp4 |
9.23MB |
| 04 - Categorizing bonuses with XLOOKUP.srt |
4.72KB |
| 04 - Conditional formatting to warn of deadlines.mp4 |
20.16MB |
| 04 - Conditional formatting to warn of deadlines.srt |
8.47KB |
| 04 - Data validation for reasonable values.mp4 |
14.04MB |
| 04 - Data validation for reasonable values.srt |
5.52KB |
| 04 - Solution Building a tracker 2.mp4 |
34.58MB |
| 04 - Solution Building a tracker 2.srt |
10.11KB |
| 04 - Unpivot and fill-down.mp4 |
26.49MB |
| 04 - Unpivot and fill-down.srt |
10.81KB |
| 04 - Using Slicers to filter for details.mp4 |
10.70MB |
| 04 - Using Slicers to filter for details.srt |
4.26KB |
| 05 - Summary pages and dashboards.mp4 |
15.93MB |
| 05 - Summary pages and dashboards.srt |
5.35KB |
| 05 - Times Checking data quality.mp4 |
6.17MB |
| 05 - Times Checking data quality.srt |
3.21KB |
| 06 - Ad hoc vs. at-a-glance needs.mp4 |
13.58MB |
| 06 - Ad hoc vs. at-a-glance needs.srt |
5.20KB |
| Ad hoc vs at-a-glance needs.xlsx |
27.96KB |
| Append.xlsx |
17.63KB |
| Bonus Resources.txt |
386B |
| Build a Tracker - Dropdown List.xlsx |
66.85KB |
| Build a Tracker - Dropdown List FINAL.xlsx |
70.76KB |
| Building and Using a Pivot Table.xlsx |
14.37KB |
| Building an event tracker.xlsx |
13.91KB |
| Building an event tracker - FINAL.xlsx |
14.86KB |
| Categorizing bonuses with VLOOKUP.xlsx |
418.86KB |
| Categorizing data with XLOOKUP.xlsx |
11.69KB |
| CF to warn of deadlines.xlsx |
13.03KB |
| Checking Times.xlsx |
10.97KB |
| Connecting a Value to a Shape.xlsx |
13.96KB |
| Crossfooting.xlsx |
20.03KB |
| Data Bars.xlsx |
9.56KB |
| Data validation for reasonable values.xlsx |
399.41KB |
| Dropdown Lists.xlsx |
13.25KB |
| Dynamic Arrays - 1 formula many results.xlsx |
86.03KB |
| Dynamic Arrays - FILTER SORT.xlsx |
92.73KB |
| Dynamic Arrays TOCOL.xlsx |
129.41KB |
| Features of an effective data tracker.xlsx |
27.99KB |
| Formula Triggers.xlsx |
13.28KB |
| Get Bonus Downloads Here.url |
181B |
| Hiding rows and columns.xlsx |
20.63KB |
| Hiding Worksheets.xlsx |
28.80KB |
| Hiding Zeros.xlsx |
15.45KB |
| Input Storage Output.xlsx |
632.93KB |
| Integrating charts.xlsx |
27.99KB |
| Introducing tables.xlsx |
10.00KB |
| Power Query Overview.xlsx |
14.86KB |
| Prepping data for a Pivot Table.xlsx |
14.41KB |
| Protecting cells, sheets and formulas.xlsx |
27.42KB |
| Slicers.xlsx |
157.94KB |
| Splitting Columns.xlsx |
629.96KB |
| Summaries.xlsx |
32.93KB |
| Tracker - Skydiving.xlsx |
152.57KB |
| Tracker - Skydiving FINAL.xlsx |
154.60KB |
| Unpivot - Fill Down.xlsx |
113.04KB |
| Using Helper Columns.xlsx |
546.48KB |
| VLOOKUP.xlsx |
263.76KB |
| What is a Pivot Table.xlsx |
14.11KB |
| XLOOKUP.xlsx |
264.28KB |