[ CourseWikia.com ] Excel - Tracking Data Easily and Efficiently (2023)

File Name

Size

Get Bonus Downloads Here.url

181 B

~Get Your Files Here !/01 - Introduction/01 - Efficient data tracking in Excel.mp4

4.4 MB

~Get Your Files Here !/01 - Introduction/01 - Efficient data tracking in Excel.srt

1.1 kB

~Get Your Files Here !/02 - 1. Planning Your Data Tracker/01 - Introducing tables.mp4

12 MB

~Get Your Files Here !/02 - 1. Planning Your Data Tracker/01 - Introducing tables.srt

6.7 kB

~Get Your Files Here !/02 - 1. Planning Your Data Tracker/02 - Key features of an effective data tracker.mp4

20 MB

~Get Your Files Here !/02 - 1. Planning Your Data Tracker/02 - Key features of an effective data tracker.srt

7.4 kB

~Get Your Files Here !/03 - 2. Helpful Data Tracking Features/01 - Thinking about input, storage, and output.mp4

17 MB

~Get Your Files Here !/03 - 2. Helpful Data Tracking Features/01 - Thinking about input, storage, and output.srt

7.8 kB

~Get Your Files Here !/03 - 2. Helpful Data Tracking Features/02 - Incorporating charts into your tracker.mp4

22 MB

~Get Your Files Here !/03 - 2. Helpful Data Tracking Features/02 - Incorporating charts into your tracker.srt

8.8 kB

~Get Your Files Here !/03 - 2. Helpful Data Tracking Features/03 - Adding helper columns.mp4

9.7 MB

~Get Your Files Here !/03 - 2. Helpful Data Tracking Features/03 - Adding helper columns.srt

3.6 kB

~Get Your Files Here !/03 - 2. Helpful Data Tracking Features/04 - Using Slicers to filter for details.mp4

11 MB

~Get Your Files Here !/03 - 2. Helpful Data Tracking Features/04 - Using Slicers to filter for details.srt

4.3 kB

~Get Your Files Here !/03 - 2. Helpful Data Tracking Features/05 - Summary pages and dashboards.mp4

16 MB

~Get Your Files Here !/03 - 2. Helpful Data Tracking Features/05 - Summary pages and dashboards.srt

5.3 kB

~Get Your Files Here !/03 - 2. Helpful Data Tracking Features/06 - Ad hoc vs. at-a-glance needs.mp4

14 MB

~Get Your Files Here !/03 - 2. Helpful Data Tracking Features/06 - Ad hoc vs. at-a-glance needs.srt

5.2 kB

~Get Your Files Here !/04 - 3. Protecting Your Work and Calculations/01 - Protecting cells and sheets.mp4

18 MB

~Get Your Files Here !/04 - 3. Protecting Your Work and Calculations/01 - Protecting cells and sheets.srt

8.1 kB

~Get Your Files Here !/04 - 3. Protecting Your Work and Calculations/02 - Hidden sheets.mp4

8.2 MB

~Get Your Files Here !/04 - 3. Protecting Your Work and Calculations/02 - Hidden sheets.srt

4.0 kB

~Get Your Files Here !/04 - 3. Protecting Your Work and Calculations/03 - Hidden columns and rows.mp4

13 MB

~Get Your Files Here !/04 - 3. Protecting Your Work and Calculations/03 - Hidden columns and rows.srt

5.9 kB

~Get Your Files Here !/05 - 4. Managing Inputs and Calculations/01 - Using dropdown lists for accuracy and consistency.mp4

24 MB

~Get Your Files Here !/05 - 4. Managing Inputs and Calculations/01 - Using dropdown lists for accuracy and consistency.srt

11 kB

~Get Your Files Here !/05 - 4. Managing Inputs and Calculations/02 - Applying formula triggers to prevent inaccurate results.mp4

10 MB

~Get Your Files Here !/05 - 4. Managing Inputs and Calculations/02 - Applying formula triggers to prevent inaccurate results.srt

5.1 kB

~Get Your Files Here !/05 - 4. Managing Inputs and Calculations/03 - Using cross-footing as a check for data quality.mp4

16 MB

~Get Your Files Here !/05 - 4. Managing Inputs and Calculations/03 - Using cross-footing as a check for data quality.srt

5.0 kB

~Get Your Files Here !/05 - 4. Managing Inputs and Calculations/04 - Data validation for reasonable values.mp4

14 MB

~Get Your Files Here !/05 - 4. Managing Inputs and Calculations/04 - Data validation for reasonable values.srt

5.5 kB

~Get Your Files Here !/05 - 4. Managing Inputs and Calculations/05 - Times Checking data quality.mp4

6.2 MB

~Get Your Files Here !/05 - 4. Managing Inputs and Calculations/05 - Times Checking data quality.srt

3.2 kB

~Get Your Files Here !/06 - 5. Midterm Building a Tracker/01 - Challenge Building a data tracker for event details.mp4

5.3 MB

~Get Your Files Here !/06 - 5. Midterm Building a Tracker/01 - Challenge Building a data tracker for event details.srt

2.3 kB

~Get Your Files Here !/06 - 5. Midterm Building a Tracker/02 - Solution Building a data tracker for event details.mp4

16 MB

~Get Your Files Here !/06 - 5. Midterm Building a Tracker/02 - Solution Building a data tracker for event details.srt

7.2 kB

~Get Your Files Here !/07 - 6. Dynamic Arrays and the New Excel Calculation Engine/01 - Dynamic Arrays One formula, many results.mp4

18 MB

~Get Your Files Here !/07 - 6. Dynamic Arrays and the New Excel Calculation Engine/01 - Dynamic Arrays One formula, many results.srt

6.8 kB

~Get Your Files Here !/07 - 6. Dynamic Arrays and the New Excel Calculation Engine/02 - Dynamic Arrays FILTER, UNIQUE, SORT.mp4

26 MB

~Get Your Files Here !/07 - 6. Dynamic Arrays and the New Excel Calculation Engine/02 - Dynamic Arrays FILTER, UNIQUE, SORT.srt

11 kB

~Get Your Files Here !/07 - 6. Dynamic Arrays and the New Excel Calculation Engine/03 - Dynamic Arrays TOCOL, dropdowns, and conditional formatting.mp4

19 MB

~Get Your Files Here !/07 - 6. Dynamic Arrays and the New Excel Calculation Engine/03 - Dynamic Arrays TOCOL, dropdowns, and conditional formatting.srt

7.2 kB

~Get Your Files Here !/08 - 7. VLOOKUP and XLOOKUP/01 - VLOOKUP.mp4

13 MB

~Get Your Files Here !/08 - 7. VLOOKUP and XLOOKUP/01 - VLOOKUP.srt

5.0 kB

~Get Your Files Here !/08 - 7. VLOOKUP and XLOOKUP/02 - Categorizing bonuses with VLOOKUP.mp4

9.6 MB

~Get Your Files Here !/08 - 7. VLOOKUP and XLOOKUP/02 - Categorizing bonuses with VLOOKUP.srt

3.5 kB

~Get Your Files Here !/08 - 7. VLOOKUP and XLOOKUP/03 - Merging data with XLOOKUP.mp4

14 MB

~Get Your Files Here !/08 - 7. VLOOKUP and XLOOKUP/03 - Merging data with XLOOKUP.srt

5.9 kB

~Get Your Files Here !/08 - 7. VLOOKUP and XLOOKUP/04 - Categorizing bonuses with XLOOKUP.mp4

9.2 MB

~Get Your Files Here !/08 - 7. VLOOKUP and XLOOKUP/04 - Categorizing bonuses with XLOOKUP.srt

4.7 kB

~Get Your Files Here !/09 - 8. PivotTable Basics/01 - What is a PivotTable.mp4

28 MB

~Get Your Files Here !/09 - 8. PivotTable Basics/01 - What is a PivotTable.srt

11 kB

~Get Your Files Here !/09 - 8. PivotTable Basics/02 - Preparing and connecting a PivotTable to your data.mp4

22 MB

~Get Your Files Here !/09 - 8. PivotTable Basics/02 - Preparing and connecting a PivotTable to your data.srt

8.4 kB

~Get Your Files Here !/09 - 8. PivotTable Basics/03 - Building and using a PivotTable.mp4

22 MB

~Get Your Files Here !/09 - 8. PivotTable Basics/03 - Building and using a PivotTable.srt

7.6 kB

~Get Your Files Here !/10 - 9. Using Power Query to Clean, Format, and Automate/01 - Power Query overview.mp4

36 MB

~Get Your Files Here !/10 - 9. Using Power Query to Clean, Format, and Automate/01 - Power Query overview.srt

12 kB

~Get Your Files Here !/10 - 9. Using Power Query to Clean, Format, and Automate/02 - Splitting columns.mp4

18 MB

~Get Your Files Here !/10 - 9. Using Power Query to Clean, Format, and Automate/02 - Splitting columns.srt

8.2 kB

~Get Your Files Here !/10 - 9. Using Power Query to Clean, Format, and Automate/03 - Append in Power Query.mp4

26 MB

~Get Your Files Here !/10 - 9. Using Power Query to Clean, Format, and Automate/03 - Append in Power Query.srt

11 kB

~Get Your Files Here !/10 - 9. Using Power Query to Clean, Format, and Automate/04 - Unpivot and fill-down.mp4

26 MB

~Get Your Files Here !/10 - 9. Using Power Query to Clean, Format, and Automate/04 - Unpivot and fill-down.srt

11 kB

~Get Your Files Here !/11 - 10. Pretty It Up!/01 - Data bars for easy visual comparison.mp4

5.4 MB

~Get Your Files Here !/11 - 10. Pretty It Up!/01 - Data bars for easy visual comparison.srt

2.6 kB

~Get Your Files Here !/11 - 10. Pretty It Up!/02 - Connecting a value to a shape.mp4

15 MB

~Get Your Files Here !/11 - 10. Pretty It Up!/02 - Connecting a value to a shape.srt

6.3 kB

~Get Your Files Here !/11 - 10. Pretty It Up!/03 - Hiding zeroes.mp4

7.4 MB

~Get Your Files Here !/11 - 10. Pretty It Up!/03 - Hiding zeroes.srt

2.9 kB

~Get Your Files Here !/11 - 10. Pretty It Up!/04 - Conditional formatting to warn of deadlines.mp4

20 MB

~Get Your Files Here !/11 - 10. Pretty It Up!/04 - Conditional formatting to warn of deadlines.srt

8.5 kB

~Get Your Files Here !/12 - 11. Get Hands On/01 - Challenge Building a tracker 1.mp4

4.1 MB

~Get Your Files Here !/12 - 11. Get Hands On/01 - Challenge Building a tracker 1.srt

1.4 kB

~Get Your Files Here !/12 - 11. Get Hands On/02 - Solution Building a tracker 1.mp4

14 MB

~Get Your Files Here !/12 - 11. Get Hands On/02 - Solution Building a tracker 1.srt

5.0 kB

~Get Your Files Here !/12 - 11. Get Hands On/03 - Challenge Building a tracker 2.mp4

7.4 MB

~Get Your Files Here !/12 - 11. Get Hands On/03 - Challenge Building a tracker 2.srt

3.1 kB

~Get Your Files Here !/12 - 11. Get Hands On/04 - Solution Building a tracker 2.mp4

35 MB

~Get Your Files Here !/12 - 11. Get Hands On/04 - Solution Building a tracker 2.srt

10 kB

~Get Your Files Here !/13 - Conclusion/01 - Continue your data tracking journey in Excel.mp4

5.2 MB

~Get Your Files Here !/13 - Conclusion/01 - Continue your data tracking journey in Excel.srt

1.4 kB

~Get Your Files Here !/Bonus Resources.txt

386 B

~Get Your Files Here !/Ex_Files_Excel_Tracking_Data_Easily/Exercise Files/Chap 01/Features of an effective data tracker.xlsx

28 kB

~Get Your Files Here !/Ex_Files_Excel_Tracking_Data_Easily/Exercise Files/Chap 01/Introducing tables.xlsx

10 kB

~Get Your Files Here !/Ex_Files_Excel_Tracking_Data_Easily/Exercise Files/Chap 02/Ad hoc vs at-a-glance needs.xlsx

28 kB

~Get Your Files Here !/Ex_Files_Excel_Tracking_Data_Easily/Exercise Files/Chap 02/Input Storage Output.xlsx

633 kB

~Get Your Files Here !/Ex_Files_Excel_Tracking_Data_Easily/Exercise Files/Chap 02/Integrating charts.xlsx

28 kB

~Get Your Files Here !/Ex_Files_Excel_Tracking_Data_Easily/Exercise Files/Chap 02/Slicers.xlsx

158 kB

~Get Your Files Here !/Ex_Files_Excel_Tracking_Data_Easily/Exercise Files/Chap 02/Summaries.xlsx

33 kB

~Get Your Files Here !/Ex_Files_Excel_Tracking_Data_Easily/Exercise Files/Chap 02/Using Helper Columns.xlsx

546 kB

~Get Your Files Here !/Ex_Files_Excel_Tracking_Data_Easily/Exercise Files/Chap 03/Hiding Worksheets.xlsx

29 kB

~Get Your Files Here !/Ex_Files_Excel_Tracking_Data_Easily/Exercise Files/Chap 03/Hiding rows and columns.xlsx

21 kB

~Get Your Files Here !/Ex_Files_Excel_Tracking_Data_Easily/Exercise Files/Chap 03/Protecting cells, sheets and formulas.xlsx

27 kB

~Get Your Files Here !/Ex_Files_Excel_Tracking_Data_Easily/Exercise Files/Chap 04/Checking Times.xlsx

11 kB

~Get Your Files Here !/Ex_Files_Excel_Tracking_Data_Easily/Exercise Files/Chap 04/Crossfooting.xlsx

20 kB

~Get Your Files Here !/Ex_Files_Excel_Tracking_Data_Easily/Exercise Files/Chap 04/Data validation for reasonable values.xlsx

399 kB

~Get Your Files Here !/Ex_Files_Excel_Tracking_Data_Easily/Exercise Files/Chap 04/Dropdown Lists.xlsx

13 kB

~Get Your Files Here !/Ex_Files_Excel_Tracking_Data_Easily/Exercise Files/Chap 04/Formula Triggers.xlsx

13 kB

~Get Your Files Here !/Ex_Files_Excel_Tracking_Data_Easily/Exercise Files/Chap 05/Building an event tracker - FINAL.xlsx

15 kB

~Get Your Files Here !/Ex_Files_Excel_Tracking_Data_Easily/Exercise Files/Chap 05/Building an event tracker.xlsx

14 kB

~Get Your Files Here !/Ex_Files_Excel_Tracking_Data_Easily/Exercise Files/Chap 06/Dynamic Arrays - 1 formula many results.xlsx

86 kB

~Get Your Files Here !/Ex_Files_Excel_Tracking_Data_Easily/Exercise Files/Chap 06/Dynamic Arrays - FILTER SORT.xlsx

93 kB

~Get Your Files Here !/Ex_Files_Excel_Tracking_Data_Easily/Exercise Files/Chap 06/Dynamic Arrays TOCOL.xlsx

129 kB

~Get Your Files Here !/Ex_Files_Excel_Tracking_Data_Easily/Exercise Files/Chap 07/Categorizing bonuses with VLOOKUP.xlsx

419 kB

~Get Your Files Here !/Ex_Files_Excel_Tracking_Data_Easily/Exercise Files/Chap 07/Categorizing data with XLOOKUP.xlsx

12 kB

~Get Your Files Here !/Ex_Files_Excel_Tracking_Data_Easily/Exercise Files/Chap 07/VLOOKUP.xlsx

264 kB

~Get Your Files Here !/Ex_Files_Excel_Tracking_Data_Easily/Exercise Files/Chap 07/XLOOKUP.xlsx

264 kB

~Get Your Files Here !/Ex_Files_Excel_Tracking_Data_Easily/Exercise Files/Chap 08/Building and Using a Pivot Table.xlsx

14 kB

~Get Your Files Here !/Ex_Files_Excel_Tracking_Data_Easily/Exercise Files/Chap 08/Prepping data for a Pivot Table.xlsx

14 kB

~Get Your Files Here !/Ex_Files_Excel_Tracking_Data_Easily/Exercise Files/Chap 08/What is a Pivot Table.xlsx

14 kB

~Get Your Files Here !/Ex_Files_Excel_Tracking_Data_Easily/Exercise Files/Chap 09/Append.xlsx

18 kB

~Get Your Files Here !/Ex_Files_Excel_Tracking_Data_Easily/Exercise Files/Chap 09/Power Query Overview.xlsx

15 kB

~Get Your Files Here !/Ex_Files_Excel_Tracking_Data_Easily/Exercise Files/Chap 09/Splitting Columns.xlsx

630 kB

~Get Your Files Here !/Ex_Files_Excel_Tracking_Data_Easily/Exercise Files/Chap 09/Unpivot - Fill Down.xlsx

113 kB

~Get Your Files Here !/Ex_Files_Excel_Tracking_Data_Easily/Exercise Files/Chap 10/CF to warn of deadlines.xlsx

13 kB

~Get Your Files Here !/Ex_Files_Excel_Tracking_Data_Easily/Exercise Files/Chap 10/Connecting a Value to a Shape.xlsx

14 kB

~Get Your Files Here !/Ex_Files_Excel_Tracking_Data_Easily/Exercise Files/Chap 10/Data Bars.xlsx

9.6 kB

~Get Your Files Here !/Ex_Files_Excel_Tracking_Data_Easily/Exercise Files/Chap 10/Hiding Zeros.xlsx

16 kB

~Get Your Files Here !/Ex_Files_Excel_Tracking_Data_Easily/Exercise Files/Chap 11/Build a Tracker - Dropdown List FINAL.xlsx

71 kB

~Get Your Files Here !/Ex_Files_Excel_Tracking_Data_Easily/Exercise Files/Chap 11/Build a Tracker - Dropdown List.xlsx

67 kB

~Get Your Files Here !/Ex_Files_Excel_Tracking_Data_Easily/Exercise Files/Chap 11/Tracker - Skydiving FINAL.xlsx

155 kB

~Get Your Files Here !/Ex_Files_Excel_Tracking_Data_Easily/Exercise Files/Chap 11/Tracker - Skydiving.xlsx

153 kB