CourseWikia com Excel Tracking Data Easily and Efficiently 2023 | 07E99FB4DDCA8B15F5B590002C80E07C65A6A6DD

CourseWikia com Excel Tracking Data Easily and Efficiently 2023

Name	[ CourseWikia.com ] Excel - Tracking Data Easily and Efficiently (2023)	DOWNLOAD Copy Link
Total Size	691.6 MB
Total Files	126
Hash	07E99FB4DDCA8B15F5B590002C80E07C65A6A6DD

/
Get Bonus Downloads Here.url	0.2 KB
/01 - Introduction/
01 - Efficient data tracking in Excel.mp4	4.6 MB
01 - Efficient data tracking in Excel.srt	1.1 KB
/.../02 - 1. Planning Your Data Tracker/
01 - Introducing tables.mp4	12.7 MB
01 - Introducing tables.srt	6.9 KB
02 - Key features of an effective data tracker.mp4	20.6 MB
02 - Key features of an effective data tracker.srt	7.6 KB
/.../03 - 2. Helpful Data Tracking Features/
01 - Thinking about input, storage, and output.mp4	18.1 MB
01 - Thinking about input, storage, and output.srt	7.9 KB
02 - Incorporating charts into your tracker.mp4	22.7 MB
02 - Incorporating charts into your tracker.srt	9.0 KB
03 - Adding helper columns.mp4	10.2 MB
03 - Adding helper columns.srt	3.7 KB
04 - Using Slicers to filter for details.mp4	11.2 MB
04 - Using Slicers to filter for details.srt	4.4 KB
05 - Summary pages and dashboards.mp4	16.7 MB
05 - Summary pages and dashboards.srt	5.5 KB
06 - Ad hoc vs. at-a-glance needs.mp4	14.2 MB
06 - Ad hoc vs. at-a-glance needs.srt	5.3 KB
/.../04 - 3. Protecting Your Work and Calculations/
01 - Protecting cells and sheets.mp4	18.4 MB
01 - Protecting cells and sheets.srt	8.3 KB
02 - Hidden sheets.mp4	8.6 MB
02 - Hidden sheets.srt	4.1 KB
03 - Hidden columns and rows.mp4	13.5 MB
03 - Hidden columns and rows.srt	6.1 KB
/.../05 - 4. Managing Inputs and Calculations/
01 - Using dropdown lists for accuracy and consistency.mp4	24.6 MB
01 - Using dropdown lists for accuracy and consistency.srt	11.0 KB
02 - Applying formula triggers to prevent inaccurate results.mp4	10.5 MB
02 - Applying formula triggers to prevent inaccurate results.srt	5.2 KB
03 - Using cross-footing as a check for data quality.mp4	17.2 MB
03 - Using cross-footing as a check for data quality.srt	5.2 KB
04 - Data validation for reasonable values.mp4	14.7 MB
04 - Data validation for reasonable values.srt	5.7 KB
05 - Times Checking data quality.mp4	6.5 MB
05 - Times Checking data quality.srt	3.3 KB
/.../06 - 5. Midterm Building a Tracker/
01 - Challenge Building a data tracker for event details.mp4	5.5 MB
01 - Challenge Building a data tracker for event details.srt	2.4 KB
02 - Solution Building a data tracker for event details.mp4	17.2 MB
02 - Solution Building a data tracker for event details.srt	7.4 KB
/.../07 - 6. Dynamic Arrays and the New Excel Calculation Engine/
01 - Dynamic Arrays One formula, many results.mp4	18.4 MB
01 - Dynamic Arrays One formula, many results.srt	7.0 KB
02 - Dynamic Arrays FILTER, UNIQUE, SORT.mp4	26.8 MB
02 - Dynamic Arrays FILTER, UNIQUE, SORT.srt	10.8 KB
03 - Dynamic Arrays TOCOL, dropdowns, and conditional formatting.mp4	19.6 MB
03 - Dynamic Arrays TOCOL, dropdowns, and conditional formatting.srt	7.3 KB
/.../08 - 7. VLOOKUP and XLOOKUP/
01 - VLOOKUP.mp4	13.7 MB
01 - VLOOKUP.srt	5.1 KB
02 - Categorizing bonuses with VLOOKUP.mp4	10.1 MB
02 - Categorizing bonuses with VLOOKUP.srt	3.6 KB
03 - Merging data with XLOOKUP.mp4	15.0 MB
03 - Merging data with XLOOKUP.srt	6.1 KB
04 - Categorizing bonuses with XLOOKUP.mp4	9.7 MB
04 - Categorizing bonuses with XLOOKUP.srt	4.8 KB
/.../09 - 8. PivotTable Basics/
01 - What is a PivotTable.mp4	29.4 MB
01 - What is a PivotTable.srt	10.8 KB
02 - Preparing and connecting a PivotTable to your data.mp4	23.6 MB
02 - Preparing and connecting a PivotTable to your data.srt	8.6 KB
03 - Building and using a PivotTable.mp4	22.5 MB
03 - Building and using a PivotTable.srt	7.8 KB
/.../10 - 9. Using Power Query to Clean, Format, and Automate/
01 - Power Query overview.mp4	37.5 MB
01 - Power Query overview.srt	12.8 KB
02 - Splitting columns.mp4	18.6 MB
02 - Splitting columns.srt	8.4 KB
03 - Append in Power Query.mp4	27.0 MB
03 - Append in Power Query.srt	11.6 KB
04 - Unpivot and fill-down.mp4	27.8 MB
04 - Unpivot and fill-down.srt	11.1 KB
/.../11 - 10. Pretty It Up!/
01 - Data bars for easy visual comparison.mp4	5.6 MB
01 - Data bars for easy visual comparison.srt	2.7 KB
02 - Connecting a value to a shape.mp4	15.6 MB
02 - Connecting a value to a shape.srt	6.5 KB
03 - Hiding zeroes.mp4	7.8 MB
03 - Hiding zeroes.srt	3.0 KB
04 - Conditional formatting to warn of deadlines.mp4	21.1 MB
04 - Conditional formatting to warn of deadlines.srt	8.7 KB
/.../12 - 11. Get Hands On/
01 - Challenge Building a tracker 1.mp4	4.3 MB
01 - Challenge Building a tracker 1.srt	1.5 KB
02 - Solution Building a tracker 1.mp4	15.1 MB
02 - Solution Building a tracker 1.srt	5.1 KB
03 - Challenge Building a tracker 2.mp4	7.8 MB
03 - Challenge Building a tracker 2.srt	3.2 KB
04 - Solution Building a tracker 2.mp4	36.3 MB
04 - Solution Building a tracker 2.srt	10.4 KB
/13 - Conclusion/
01 - Continue your data tracking journey in Excel.mp4	5.4 MB
01 - Continue your data tracking journey in Excel.srt	1.4 KB
/~Get Your Files Here !/
Bonus Resources.txt	0.4 KB
/.../Ex_Files_Excel_Tracking_Data_Easily/Exercise Files/Chap 01/
Features of an effective data tracker.xlsx	28.7 KB
Introducing tables.xlsx	10.2 KB
/.../Ex_Files_Excel_Tracking_Data_Easily/Exercise Files/Chap 02/
Ad hoc vs at-a-glance needs.xlsx	28.6 KB
Input Storage Output.xlsx	648.1 KB
Integrating charts.xlsx	28.7 KB
Slicers.xlsx	161.7 KB
Summaries.xlsx	33.7 KB
Using Helper Columns.xlsx	559.6 KB
/.../Ex_Files_Excel_Tracking_Data_Easily/Exercise Files/Chap 03/
Hiding Worksheets.xlsx	29.5 KB
Hiding rows and columns.xlsx	21.1 KB
Protecting cells, sheets and formulas.xlsx	28.1 KB
/.../Ex_Files_Excel_Tracking_Data_Easily/Exercise Files/Chap 04/
Checking Times.xlsx	11.2 KB
Crossfooting.xlsx	20.5 KB
Data validation for reasonable values.xlsx	409.0 KB
Dropdown Lists.xlsx	13.6 KB
Formula Triggers.xlsx	13.6 KB
/.../Ex_Files_Excel_Tracking_Data_Easily/Exercise Files/Chap 05/
Building an event tracker - FINAL.xlsx	15.2 KB
Building an event tracker.xlsx	14.2 KB
/.../Ex_Files_Excel_Tracking_Data_Easily/Exercise Files/Chap 06/
Dynamic Arrays - 1 formula many results.xlsx	88.1 KB
Dynamic Arrays - FILTER SORT.xlsx	95.0 KB
Dynamic Arrays TOCOL.xlsx	132.5 KB
/.../Ex_Files_Excel_Tracking_Data_Easily/Exercise Files/Chap 07/
Categorizing bonuses with VLOOKUP.xlsx	428.9 KB
Categorizing data with XLOOKUP.xlsx	12.0 KB
VLOOKUP.xlsx	270.1 KB
XLOOKUP.xlsx	270.6 KB
/.../Ex_Files_Excel_Tracking_Data_Easily/Exercise Files/Chap 08/
Building and Using a Pivot Table.xlsx	14.7 KB
Prepping data for a Pivot Table.xlsx	14.8 KB
What is a Pivot Table.xlsx	14.5 KB
/.../Ex_Files_Excel_Tracking_Data_Easily/Exercise Files/Chap 09/
Append.xlsx	18.0 KB
Power Query Overview.xlsx	15.2 KB
Splitting Columns.xlsx	645.1 KB
Unpivot - Fill Down.xlsx	115.8 KB
/.../Ex_Files_Excel_Tracking_Data_Easily/Exercise Files/Chap 10/
CF to warn of deadlines.xlsx	13.3 KB
Connecting a Value to a Shape.xlsx	14.3 KB
Data Bars.xlsx	9.8 KB
Hiding Zeros.xlsx	15.8 KB
/.../Ex_Files_Excel_Tracking_Data_Easily/Exercise Files/Chap 11/
Build a Tracker - Dropdown List FINAL.xlsx	72.5 KB
Build a Tracker - Dropdown List.xlsx	68.5 KB
Tracker - Skydiving FINAL.xlsx	158.3 KB
Tracker - Skydiving.xlsx	156.2 KB
Total files 126