Tutorialsplanet NET Udemy Advanced Excel Top Excel Tips Formulas | 9B1AF04B4C3EB053C54FCA98AC2F507F5978165F

Tutorialsplanet NET Udemy Advanced Excel Top Excel Tips Formulas

Name	[Tutorialsplanet.NET] Udemy - Advanced Excel Top Excel Tips & Formulas	DOWNLOAD Copy Link
Total Size	2.6 GB
Total Files	91
Hash	9B1AF04B4C3EB053C54FCA98AC2F507F5978165F

/1. Introduction, Scope & Excel Files/
1. Advanced Excel - Introduction & Scope.mp4	85.6 MB
1. Advanced Excel - Introduction & Scope.srt	7.9 KB
2. DOWNLOAD these Files First.mp4	44.2 MB
2. DOWNLOAD these Files First.srt	2.7 KB
2.1 sample_raw_data.txt	0.2 KB
2.2 Excel_Advanced_ExerciseBook.xlsx	328.7 KB
2.3 Excel_Advanced_Demo.xlsx	450.8 KB
3. Course Outline for Quick Reference.html	0.4 KB
3.1 Detailed_Course_Outline_Excel_Advanced.xlsx	15.5 KB
/2. Top 10 Excel Tips to Save You Time/
1. Overview of Top Excel Tips.mp4	41.4 MB
1. Overview of Top Excel Tips.srt	2.9 KB
10. Tip 6 - Import Text, CSV & Web Data Properly.mp4	64.9 MB
10. Tip 6 - Import Text, CSV & Web Data Properly.srt	13.9 KB
11. Tip 7 - Audit & Debug Formulas.mp4	26.1 MB
11. Tip 7 - Audit & Debug Formulas.srt	10.4 KB
12. Tip 8 - Improve Presentation with Customized Number Formatting.mp4	135.2 MB
12. Tip 8 - Improve Presentation with Customized Number Formatting.srt	18.7 KB
13. Tip 9 - Solve Problems With Goal Seek.mp4	54.7 MB
13. Tip 9 - Solve Problems With Goal Seek.srt	7.4 KB
14. Tip 10 - Use Excel PivotTables for Super Fast Analysis.mp4	62.2 MB
14. Tip 10 - Use Excel PivotTables for Super Fast Analysis.srt	18.8 KB
15. Tip 10 - PivotTables Calculated Fields, Slicers & Helpful Tricks.mp4	73.6 MB
15. Tip 10 - PivotTables Calculated Fields, Slicers & Helpful Tricks.srt	15.9 KB
16. Tip 10 - PivotTables Valuable Design Tips.mp4	96.0 MB
16. Tip 10 - PivotTables Valuable Design Tips.srt	24.6 KB
17. Test Your Knowledge - Top 10 Tips (Don't Skip).html	0.1 KB
18. Bonus Tip - Methods to Speed up Your Excel Files.mp4	19.8 MB
18. Bonus Tip - Methods to Speed up Your Excel Files.srt	6.8 KB
18.1 Infographic_steps_to_make_Slow_Excel_Files_Faster.pdf	287.6 KB
19. Bonus Tip - The Possibilities & Limitations of Excel.mp4	27.5 MB
19. Bonus Tip - The Possibilities & Limitations of Excel.srt	8.6 KB
2. Tip 1 - Become Faster with Excel's Keyboard Shortcuts.mp4	57.2 MB
2. Tip 1 - Become Faster with Excel's Keyboard Shortcuts.srt	11.1 KB
2.1 Click the link for a more detailed list of Excel Shortcuts available on the Microsoft Office website.html	0.2 KB
20. PDF to Download - Top 10 Excel TIPS to Work Smarter (in print and in detail).html	0.8 KB
20.1 Excel_Advanced_Top10TIPS_Documentation_LeilaGharani.pdf	3.4 MB
3. Tip 2 - Master the Simpler Tasks Part 1.mp4	66.8 MB
3. Tip 2 - Master the Simpler Tasks Part 1.srt	18.6 KB
4. Tip 2 - Master the Simpler Tasks Part 2.mp4	38.7 MB
4. Tip 2 - Master the Simpler Tasks Part 2.srt	9.9 KB
5. Tip 3 - Quickly Navigate Larger Files.mp4	46.4 MB
5. Tip 3 - Quickly Navigate Larger Files.srt	11.4 KB
6. Tip 4 - Inspect Workbooks for Hidden Information.mp4	31.5 MB
6. Tip 4 - Inspect Workbooks for Hidden Information.srt	11.6 KB
7. Tip 4 Extended - Unhide Hidden Names with VBA.html	3.2 KB
7.1 Unhide Hidden Names.pdf	198.5 KB
8. Tip 5 - Use Protection Appropriately.mp4	75.6 MB
8. Tip 5 - Use Protection Appropriately.srt	19.5 KB
9. Test Your Knowledge - Top 5 Tips (Don't Skip).html	0.1 KB
/3. Top 10 Excel Formulas for Quick & Dynamic Analysis/
1. Overview of Top Excel Formulas.mp4	72.7 MB
1. Overview of Top Excel Formulas.srt	4.4 KB
10. Formula 6 - Advanced TEXT functions.mp4	129.5 MB
10. Formula 6 - Advanced TEXT functions.srt	19.2 KB
11. Formula 7 - Excel's Top Date Functions.mp4	169.3 MB
11. Formula 7 - Excel's Top Date Functions.srt	21.4 KB
12. Formula 8 - OFFSET for Dynamic Calculations.mp4	41.1 MB
12. Formula 8 - OFFSET for Dynamic Calculations.srt	15.7 KB
13. Formula 9 - FREQUENCY, SMALL & LARGE to Organize and Rank.mp4	65.6 MB
13. Formula 9 - FREQUENCY, SMALL & LARGE to Organize and Rank.srt	15.9 KB
14. Formula 10 - SUMPRODUCT For the Gurus.mp4	116.3 MB
14. Formula 10 - SUMPRODUCT For the Gurus.srt	15.7 KB
15. Test Your Knowledge - Top 10 Formulas (Don't Skip).html	0.1 KB
16. PDF to Download Top 10 Excel FORMULAS to Work Smarter.html	0.8 KB
16.1 Excel_Advanced_Top10FORMULAS_Documentation_LeilaGharani.pdf	1.6 MB
2. Formula 1 - SUMIFS, COUNTIFS, AVERAGEIFS to Account for Exceptions.mp4	142.8 MB
2. Formula 1 - SUMIFS, COUNTIFS, AVERAGEIFS to Account for Exceptions.srt	14.6 KB
3. Formula 2 - IF (Nested Functions) Because Data Analysis is Often Not Simple.mp4	101.4 MB
3. Formula 2 - IF (Nested Functions) Because Data Analysis is Often Not Simple.srt	12.5 KB
4. Formula 3 - IFERROR for Credible Reports.mp4	44.2 MB
4. Formula 3 - IFERROR for Credible Reports.srt	6.1 KB
5. Formula 4 - VLOOKUP & HLOOKUP For Dynamic Lookups.mp4	122.4 MB
5. Formula 4 - VLOOKUP & HLOOKUP For Dynamic Lookups.srt	11.7 KB
6. Formula 5 - INDEX & MATCH for Flexible Lookups.mp4	76.6 MB
6. Formula 5 - INDEX & MATCH for Flexible Lookups.srt	17.0 KB
7. Formula 5 - INDEX & MATCH for Complex Real-Cases.mp4	199.6 MB
7. Formula 5 - INDEX & MATCH for Complex Real-Cases.srt	21.4 KB
8. Test Your Knowledge - Top 5 Formulas (Don't Skip).html	0.1 KB
9. Formula 6 - The Most Useful Text Functions.mp4	108.3 MB
9. Formula 6 - The Most Useful Text Functions.srt	14.3 KB
/4. Formula Combinations for Real Cases/
1. YTD Calculations - SUM, SUMPRODUCT & OFFSET.mp4	32.6 MB
1. YTD Calculations - SUM, SUMPRODUCT & OFFSET.srt	15.0 KB
2. 3 Ways to Lookup within Boundaries SUMIFS, SUMPRODUCT & INDEX.mp4	35.6 MB
2. 3 Ways to Lookup within Boundaries SUMIFS, SUMPRODUCT & INDEX.srt	14.4 KB
3. Sum Alternate Columns based on Selection - SUMIFS & INDEX.mp4	30.1 MB
3. Sum Alternate Columns based on Selection - SUMIFS & INDEX.srt	12.6 KB
4. Sum Alternate Columns - SUMPRODUCT.mp4	24.3 MB
4. Sum Alternate Columns - SUMPRODUCT.srt	12.5 KB
/5. Wrap Up/
1. Final Words.mp4	42.8 MB
1. Final Words.srt	2.6 KB
2. How to get my other courses & more useful materials.html	3.5 KB
/
[Tutorialsplanet.NET].url	0.1 KB
Total files 91