Udemy - Excel Data Analysis and Pivot Table - Build Smart Dashboa...

Files:

• Get Bonus Downloads Here.url (0.2 KB)
~Get Your Files Here ! 1 - Introduction
• 1. What is a PivotTable.mp4 (53.6 MB)
• 2. When and Why to Use PivotTables.mp4 (60.4 MB)
• 3. Navigating the Excel Interface for PivotTable Use.mp4 (60.5 MB)
2 - Preparing Your Data
• 4. Data Structure for PivotTables.mp4 (66.6 MB)
• 5. Cleaning and Formatting Data.mp4 (61.0 MB)
• 6. Using Excel Tables for Dynamic Data Analysis.mp4 (65.0 MB)
• 7. Importing Data from External Sources (CSV, Excel, etc.).mp4 (44.0 MB)
3 - Creating Your First PivotTable
• 10. Rows, Columns, Values, and Filters – The Four Components.mp4 (49.9 MB)
• 11. Basic Data Summarization Techniques (Sum, Count, Average).mp4 (41.9 MB)
• 8. Inserting a PivotTable from a Table or Range.mp4 (37.4 MB)
• 9. Understanding the PivotTable Field List.mp4 (35.7 MB)
4 - Customizing and Formatting PivotTables
• 12. Changing Summary Functions.mp4 (55.8 MB)
• 13. Formatting Numbers in PivotTables.mp4 (70.4 MB)
• 14. Sorting and Filtering Data within a PivotTable.mp4 (71.5 MB)
• 15. Grouping Data by Dates, Numbers, or Text.mp4 (49.8 MB)
• 16. Using Slicers for Interactive Filtering.mp4 (49.0 MB)
5 - Advanced PivotTable Features
• 17. Creating Calculated Fields and Items.mp4 (62.5 MB)
• 18. Using Multiple Data Fields.mp4 (32.6 MB)
• 19. Analyzing Data with % of Total, Running Totals, and Difference From.mp4 (46.4 MB)
• 20. Connecting PivotTables to Dynamic Named Ranges.mp4 (56.0 MB)
6 - PivotCharts and Data Visualization
• 21. Creating PivotCharts.mp4 (49.3 MB)
• 22. Choosing the Right Chart Type for Your Data.mp4 (80.0 MB)
• 23. Using Slicers and Timelines with Charts.mp4 (66.1 MB)
• 24. Creating Interactive Dashboards in Excel.mp4 (54.9 MB)
7 - Tips, Tricks, and Troubleshooting
• 25. Common PivotTable Mistakes and How to Avoid Them.mp4 (64.1 MB)
• 26. Performance Tips for Large Data Sets.mp4 (28.2 MB)
• 27. Best Practices for Reporting and Presentation.mp4 (36.3 MB)
8 - Real-World Case Studies
• 28. Sales Data Analysis.mp4 (55.2 MB)
• 29. HR Data Analysis.mp4 (73.8 MB)
• Bonus Resources.txt (0.1 KB)