Excel Exam MO 201 Microsoft Excel Expert 2019 Office 365 | E99D936D4B9AC6893EC0E97BB5AB618BBB1AB21C

Excel Exam MO 201 Microsoft Excel Expert 2019 Office 365

Name	Excel Exam MO-201 Microsoft Excel Expert (2019 - Office 365)	DOWNLOAD Copy Link
Total Size	4.3 GB
Total Files	204
Last Seen	2025-02-19 23:29
Hash	E99D936D4B9AC6893EC0E97BB5AB618BBB1AB21C

/.../4. Advanced Formulas & Macros/
22. The VLOOKUP & HLOOKUP Functions.mp4	140.6 MB
1. Objective Domain Intro.mp4	8.5 MB
1. Objective Domain Intro.srt	2.5 KB
2. Fixed vs. Relative References.mp4	52.8 MB
2. Fixed vs. Relative References.srt	13.7 KB
3. Explicit vs. Structured References.mp4	64.6 MB
3. Explicit vs. Structured References.srt	12.5 KB
4. Logical Operations.mp4	13.5 MB
4. Logical Operations.srt	4.1 KB
5. The IF Function.mp4	55.1 MB
5. The IF Function.srt	8.0 KB
6. Nested IF Functions vs. The IFS Function.mp4	75.2 MB
6. Nested IF Functions vs. The IFS Function.srt	11.0 KB
7. The NOT & “” Operators.mp4	51.4 MB
7. The NOT & “” Operators.srt	6.5 KB
8. The ANDOR Operators.mp4	79.7 MB
8. The ANDOR Operators.srt	11.1 KB
9. The SWITCH Function.mp4	81.7 MB
9. The SWITCH Function.srt	12.3 KB
10. The COUNTIFSUMIFAVERAGEIF Functions.mp4	76.0 MB
10. The COUNTIFSUMIFAVERAGEIF Functions.srt	10.2 KB
11. COUNTIFSSUMIFSAVERAGEIFS for Multiple Criteria.mp4	72.6 MB
11. COUNTIFSSUMIFSAVERAGEIFS for Multiple Criteria.srt	11.6 KB
12. The MINIFS & MAXIFS Functions.mp4	32.3 MB
12. The MINIFS & MAXIFS Functions.srt	5.9 KB
13. Excel Date Values & Formatting.mp4	40.9 MB
13. Excel Date Values & Formatting.srt	9.3 KB
14. PRO TIP Converting Text to Dates.mp4	63.9 MB
14. PRO TIP Converting Text to Dates.srt	9.0 KB
15. The TODAY & NOW Functions.mp4	24.4 MB
15. The TODAY & NOW Functions.srt	6.0 KB
16. YEARMONTHDAY & HOURMINUTESECOND.mp4	32.4 MB
16. YEARMONTHDAY & HOURMINUTESECOND.srt	3.6 KB
17. WEEKDAY, WORKDAY & NETWORKDAYS.mp4	41.2 MB
17. WEEKDAY, WORKDAY & NETWORKDAYS.srt	8.5 KB
18. Recording a Macro.mp4	88.8 MB
18. Recording a Macro.srt	9.8 KB
19. Modifying & Deleting Macros.mp4	37.5 MB
19. Modifying & Deleting Macros.srt	3.5 KB
20. PRO TIP Adding Form Controls.mp4	29.7 MB
20. PRO TIP Adding Form Controls.srt	5.3 KB
21. Lookup Functions.mp4	5.7 MB
21. Lookup Functions.srt	1.8 KB
22. The VLOOKUP & HLOOKUP Functions.srt	18.1 KB
23. The INDEX Function.mp4	19.8 MB
23. The INDEX Function.srt	4.5 KB
24. The MATCH Function.mp4	21.8 MB
24. The MATCH Function.srt	5.4 KB
25. Combining INDEX & MATCH.mp4	108.8 MB
25. Combining INDEX & MATCH.srt	13.6 KB
26. Approximate Match Lookups.mp4	43.5 MB
26. Approximate Match Lookups.srt	7.4 KB
27. The PMT & NPER Functions.mp4	68.6 MB
27. The PMT & NPER Functions.srt	15.5 KB
28. Scenario Manager.mp4	51.9 MB
28. Scenario Manager.srt	8.5 KB
29. Consolidate Data.mp4	46.5 MB
29. Consolidate Data.srt	9.0 KB
30. Goal Seek.mp4	41.9 MB
30. Goal Seek.srt	7.3 KB
31. Formula Auditing.mp4	103.3 MB
31. Formula Auditing.srt	16.9 KB
32. QUIZ Advanced Formulas & Macros.html	0.1 KB
/
TutsNode.com.txt	0.1 KB
[TGx]Downloaded from torrentgalaxy.to .txt	0.6 KB
/1. Getting Started/
1. Course Structure & Outline.mp4	26.1 MB
1. Course Structure & Outline.srt	2.5 KB
2. READ ME Important Notes for New Students.html	4.5 KB
3. DOWNLOAD Course Resources.html	1.4 KB
3.1 Excel Expert Course Files.zip	48.2 MB
3.2 MO-201 Exam Study Guide.pdf	6.0 MB
4. Setting Expectations.mp4	10.9 MB
4. Setting Expectations.srt	2.7 KB
/.../2. About the MO-201 Exam/
1. Exam Structure.mp4	5.5 MB
1. Exam Structure.srt	2.1 KB
2. Objective Domains & Skills Measured.mp4	9.0 MB
2. Objective Domains & Skills Measured.srt	2.7 KB
3. Exam Interface & Scheduling.mp4	11.9 MB
3. Exam Interface & Scheduling.srt	3.7 KB
4. Helpful Resources.mp4	11.1 MB
4. Helpful Resources.srt	3.0 KB
4.1 Certiport_Tutorial.pdf	262.6 KB
4.2 Skills_Measured.pdf	212.1 KB
/.../3. The Course Project/
1. Course Project Intro.mp4	6.0 MB
1. Course Project Intro.srt	1.7 KB
2. The Airbnb Dataset.mp4	79.8 MB
2. The Airbnb Dataset.srt	11.3 KB
/.../5. Managing & Formatting Data/
1. Objective Domain Intro.mp4	6.0 MB
1. Objective Domain Intro.srt	1.8 KB
2. Custom Number Formats.mp4	50.1 MB
2. Custom Number Formats.srt	10.0 KB
3. Data Validation.mp4	66.7 MB
3. Data Validation.srt	11.4 KB
4. Group & Ungroup Data.mp4	45.6 MB
4. Group & Ungroup Data.srt	7.1 KB
5. Subtotals & Totals.mp4	47.9 MB
5. Subtotals & Totals.srt	7.8 KB
6. Removing Duplicates.mp4	92.0 MB
6. Removing Duplicates.srt	12.6 KB
7. Auto Fill & Flash Fill.mp4	106.0 MB
7. Auto Fill & Flash Fill.srt	12.5 KB
8. Advanced Fill Series Options.mp4	56.4 MB
8. Advanced Fill Series Options.srt	7.7 KB
9. Conditional Formatting.mp4	88.6 MB
9. Conditional Formatting.srt	11.6 KB
10. Formula-based Conditional Formatting.mp4	104.8 MB
10. Formula-based Conditional Formatting.srt	18.4 KB
11. Managing Conditional Formatting Rules.mp4	71.4 MB
11. Managing Conditional Formatting Rules.srt	7.7 KB
12. PRO TIP Hiding Values to Create Heatmaps.mp4	32.9 MB
12. PRO TIP Hiding Values to Create Heatmaps.srt	4.9 KB
13. QUIZ Managing & Formatting Data.html	0.1 KB
/.../6. Advanced Charts & Pivot Tables/
1. Objective Domain Intro.mp4	6.6 MB
1. Objective Domain Intro.srt	2.1 KB
2. Box & Whisker Chart.mp4	49.9 MB
2. Box & Whisker Chart.srt	10.2 KB
3. Histogram.mp4	39.0 MB
3. Histogram.srt	7.9 KB
4. Filled Map.mp4	46.8 MB
4. Filled Map.srt	8.9 KB
5. Combo Chart.mp4	66.3 MB
5. Combo Chart.srt	10.1 KB
6. Tree Map & Sunburst Chart.mp4	62.8 MB
6. Tree Map & Sunburst Chart.srt	10.6 KB
7. Waterfall Chart.mp4	31.2 MB
7. Waterfall Chart.srt	6.0 KB
8. Funnel Chart.mp4	29.1 MB
8. Funnel Chart.srt	5.6 KB
9. Creating a Pivot Table.mp4	54.8 MB
9. Creating a Pivot Table.srt	11.6 KB
10. Modifying Pivot Table Views.mp4	26.8 MB
10. Modifying Pivot Table Views.srt	6.8 KB
11. Summarize Values By Options.mp4	34.7 MB
11. Summarize Values By Options.srt	8.0 KB
12. Show Values As Calculations.mp4	69.3 MB
12. Show Values As Calculations.srt	13.3 KB
13. Analyze & Design Tabs.mp4	6.5 MB
13. Analyze & Design Tabs.srt	2.0 KB
14. Report Layouts & Options.mp4	38.2 MB
14. Report Layouts & Options.srt	6.0 KB
15. Number Formatting.mp4	39.6 MB
15. Number Formatting.srt	6.1 KB
16. Sorting & Filtering.mp4	44.6 MB
16. Sorting & Filtering.srt	9.4 KB
17. Slicers & Timelines.mp4	30.9 MB
17. Slicers & Timelines.srt	6.9 KB
18. Grouping Text Fields.mp4	23.3 MB
18. Grouping Text Fields.srt	4.7 KB
19. Grouping Numerical Fields.mp4	40.4 MB
19. Grouping Numerical Fields.srt	8.4 KB
20. Grouping Date Fields.mp4	35.2 MB
20. Grouping Date Fields.srt	6.4 KB
21. Calculated Fields.mp4	62.6 MB
21. Calculated Fields.srt	9.2 KB
22. Calculated Items.mp4	35.1 MB
22. Calculated Items.srt	7.6 KB
23. Pivot Charts.mp4	37.0 MB
23. Pivot Charts.srt	7.1 KB
24. Pivot Chart Formatting.mp4	15.8 MB
24. Pivot Chart Formatting.srt	2.5 KB
25. Expanding & Collapsing Pivot Charts.mp4	22.8 MB
25. Expanding & Collapsing Pivot Charts.srt	4.3 KB
26. QUIZ Advanced Charts & Pivot Tables.html	0.1 KB
/.../7. Workbook Options & Settings/
1. Objective Domain Intro.mp4	5.9 MB
1. Objective Domain Intro.srt	2.1 KB
2. Enabling Macros.mp4	14.9 MB
2. Enabling Macros.srt	4.2 KB
3. Copying Macros to Other Files.mp4	23.2 MB
3. Copying Macros to Other Files.srt	6.3 KB
4. Linking Data Across Workbooks.mp4	48.6 MB
4. Linking Data Across Workbooks.srt	10.1 KB
5. Protecting Worksheets & Cell Ranges.mp4	48.8 MB
5. Protecting Worksheets & Cell Ranges.srt	9.2 KB
6. Protecting & Encrypting Workbooks.mp4	30.6 MB
6. Protecting & Encrypting Workbooks.srt	5.2 KB
7. Recovering Workbooks.mp4	23.5 MB
7. Recovering Workbooks.srt	5.0 KB
8. Managing Comments.mp4	38.1 MB
8. Managing Comments.srt	7.9 KB
9. Formula Calculation Modes.mp4	28.9 MB
9. Formula Calculation Modes.srt	6.0 KB
10. Language Options.mp4	38.3 MB
10. Language Options.srt	5.3 KB
11. QUIZ Workbook Options & Settings.html	0.1 KB
/8. Practice Test/
1. Practice Test Intro.mp4	8.1 MB
1. Practice Test Intro.srt	2.4 KB
2. DOWNLOAD Practice Test Resources.html	1.1 KB
2.1 MO-201 Practice Test.pdf	383.7 KB
2.2 Excel Expert Practice Test Files.zip	2.4 MB
3. Practice Test Structure.mp4	23.0 MB
3. Practice Test Structure.srt	3.7 KB
4. SOLUTION Project 1.mp4	70.1 MB
4. SOLUTION Project 1.srt	10.5 KB
5. SOLUTION Project 2.mp4	51.8 MB
5. SOLUTION Project 2.srt	7.1 KB
6. SOLUTION Project 3.mp4	37.8 MB
6. SOLUTION Project 3.srt	5.2 KB
7. SOLUTION Project 4.mp4	70.0 MB
7. SOLUTION Project 4.srt	9.0 KB
8. SOLUTION Project 5.mp4	68.5 MB
8. SOLUTION Project 5.srt	10.7 KB
9. SOLUTION Project 6.mp4	30.5 MB
9. SOLUTION Project 6.srt	4.2 KB
/9. Wrapping Up/
1. BONUS LECTURE.html	5.5 KB
Total files 204