[ WebToolTip.com ] Udemy - Excel Data Analysis and Pivot Table - Build Smart Dashboards

File Name

Size

Get Bonus Downloads Here.url

180 B

~Get Your Files Here !/1 - Introduction/1. What is a PivotTable.mp4

54 MB

~Get Your Files Here !/1 - Introduction/2. When and Why to Use PivotTables.mp4

60 MB

~Get Your Files Here !/1 - Introduction/3. Navigating the Excel Interface for PivotTable Use.mp4

60 MB

~Get Your Files Here !/2 - Preparing Your Data/4. Data Structure for PivotTables.mp4

67 MB

~Get Your Files Here !/2 - Preparing Your Data/5. Cleaning and Formatting Data.mp4

61 MB

~Get Your Files Here !/2 - Preparing Your Data/6. Using Excel Tables for Dynamic Data Analysis.mp4

65 MB

~Get Your Files Here !/2 - Preparing Your Data/7. Importing Data from External Sources (CSV, Excel, etc.).mp4

44 MB

~Get Your Files Here !/3 - Creating Your First PivotTable/10. Rows, Columns, Values, and Filters – The Four Components.mp4

50 MB

~Get Your Files Here !/3 - Creating Your First PivotTable/11. Basic Data Summarization Techniques (Sum, Count, Average).mp4

42 MB

~Get Your Files Here !/3 - Creating Your First PivotTable/8. Inserting a PivotTable from a Table or Range.mp4

37 MB

~Get Your Files Here !/3 - Creating Your First PivotTable/9. Understanding the PivotTable Field List.mp4

36 MB

~Get Your Files Here !/4 - Customizing and Formatting PivotTables/12. Changing Summary Functions.mp4

56 MB

~Get Your Files Here !/4 - Customizing and Formatting PivotTables/13. Formatting Numbers in PivotTables.mp4

70 MB

~Get Your Files Here !/4 - Customizing and Formatting PivotTables/14. Sorting and Filtering Data within a PivotTable.mp4

72 MB

~Get Your Files Here !/4 - Customizing and Formatting PivotTables/15. Grouping Data by Dates, Numbers, or Text.mp4

50 MB

~Get Your Files Here !/4 - Customizing and Formatting PivotTables/16. Using Slicers for Interactive Filtering.mp4

49 MB

~Get Your Files Here !/5 - Advanced PivotTable Features/17. Creating Calculated Fields and Items.mp4

62 MB

~Get Your Files Here !/5 - Advanced PivotTable Features/18. Using Multiple Data Fields.mp4

33 MB

~Get Your Files Here !/5 - Advanced PivotTable Features/19. Analyzing Data with % of Total, Running Totals, and Difference From.mp4

46 MB

~Get Your Files Here !/5 - Advanced PivotTable Features/20. Connecting PivotTables to Dynamic Named Ranges.mp4

56 MB

~Get Your Files Here !/6 - PivotCharts and Data Visualization/21. Creating PivotCharts.mp4

49 MB

~Get Your Files Here !/6 - PivotCharts and Data Visualization/22. Choosing the Right Chart Type for Your Data.mp4

80 MB

~Get Your Files Here !/6 - PivotCharts and Data Visualization/23. Using Slicers and Timelines with Charts.mp4

66 MB

~Get Your Files Here !/6 - PivotCharts and Data Visualization/24. Creating Interactive Dashboards in Excel.mp4

55 MB

~Get Your Files Here !/7 - Tips, Tricks, and Troubleshooting/25. Common PivotTable Mistakes and How to Avoid Them.mp4

64 MB

~Get Your Files Here !/7 - Tips, Tricks, and Troubleshooting/26. Performance Tips for Large Data Sets.mp4

28 MB

~Get Your Files Here !/7 - Tips, Tricks, and Troubleshooting/27. Best Practices for Reporting and Presentation.mp4

36 MB

~Get Your Files Here !/8 - Real-World Case Studies/28. Sales Data Analysis.mp4

55 MB

~Get Your Files Here !/8 - Real-World Case Studies/29. HR Data Analysis.mp4

74 MB

~Get Your Files Here !/Bonus Resources.txt

70 B