Ultimate Microsoft Excel With Data Analysis & VBA Macros

1. Chapter 10-Module 10 Data Visualization and Dashboards/33. Designing Interactive Dashboards Using Excel Features.mp468.06MB
2. Chapter 1-Module 1 Introduction to Microsoft Excel/2. Understanding Worksheets, Rows, Columns, and Cells.mp417.4MB
3. Chapter 1-Module 1 Introduction to Microsoft Excel/3. Entering and Editing Data Efficiently.mp429.31MB
4. Chapter 2-Module 2 Basic Formatting and Cell Management/4. Applying Cell Styles and Themes.mp428.21MB
5. Chapter 2-Module 2 Basic Formatting and Cell Management/5. Merging and Splitting Cells.mp420.08MB
6. Chapter 2-Module 2 Basic Formatting and Cell Management/6. Managing Rows, Columns and Worksheets.mp433.46MB
7. Chapter 3-Module 3 Basic Formulas and Functions/7. Introduction to Excel functions --(SUM, AVERAGE, MAX, MIN--).mp420.96MB
8. Chapter 3-Module 3 Basic Formulas and Functions/8. Writing Basic Formulas for Calculations.mp420.71MB
9. Chapter 3-Module 3 Basic Formulas and Functions/9. Absolute and Relative Cell References.mp419.25MB
10. Chapter 3-Module 3 Basic Formulas and Functions/10. Using AutoSum and AutoFill for Efficiency.mp420.06MB
11. Chapter 4-Module 4 Intermediate Functions and Formula Techniques/11. Utilizing Logical Functions --(IF, AND, OR--).mp428.16MB
12. Chapter 4-Module 4 Intermediate Functions and Formula Techniques/13. Working with Date and Time Functions.mp422.84MB
13. Chapter 5-Module 5 Data Management and Analysis/14. Introduction to Excel Tables for Structured Data Management.mp435.67MB
14. Chapter 5-Module 5 Data Management and Analysis/15. Sorting and Filtering Data.mp432.52MB
15. Chapter 5-Module 5 Data Management and Analysis/16. Using Data Validation to Control Input.mp439.63MB
16. Chapter 5-Module 5 Data Management and Analysis/17. Removing Duplicates and Cleaning Data.mp429.18MB
17. Chapter 5-Module 5 Data Management and Analysis/18. Using Sparkline for Quick Data Visualization.mp426.55MB
18. Chapter 6-Module 6 Charts and Graphs/19. Creating and Customizing Charts --(bar, line, pie, etc.--).mp438.92MB
19. Chapter 6-Module 6 Charts and Graphs/20. Adding Titles, Labels, and Legends to Charts.mp433.53MB
20. Chapter 6-Module 6 Charts and Graphs/21. Formatting Chart Elements for Clarity and Aesthetics.mp440.08MB
21. Chapter 7-Module 7 PivotTables and Pivot Charts/22. Understanding PivotTables and Pivot Charts.mp430.7MB
22. Chapter 7-Module 7 PivotTables and Pivot Charts/23. Creating PivotTables to Analyze and Summarize Data.mp422.36MB
23. Chapter 7-Module 7 PivotTables and Pivot Charts/24. Modifying PivotTable Layout and Appearance.mp435.15MB
24. Chapter 7-Module 7 PivotTables and Pivot Charts/25. Creating Dynamic Reports with Pivot Charts.mp443.45MB
25. Chapter 8-Module 8 Advanced Data Analysis/26. Utilizing Advanced Functions --(VLOOKUP, HLOOKUP, INDEX, MATCH--).mp440.72MB
26. Chapter 8-Module 8 Advanced Data Analysis/27. Performing Statistical Analysis with Functions --(COUNTIF, SUMIF, AVERAGEIF--).mp422.5MB
27. Chapter 8-Module 8 Advanced Data Analysis/28. Working with Array Formulas for Complex Calculations.mp422.77MB
28. Chapter 9-Module 9 Advanced Charting Techniques/29. Creating Combination Charts and Dual-Axis Charts.mp430.55MB
29. Chapter 9-Module 9 Advanced Charting Techniques/30. Adding Trendlines and Error Bars to Charts.mp427.43MB
30. Chapter 9-Module 9 Advanced Charting Techniques/31. Creating Dynamic Charts with Form Controls.mp450.38MB
31. Chapter 9-Module 9 Advanced Charting Techniques/32. Using Advanced Charting Features for Data Visualization.mp449.77MB
32. Chapter 1-Module 1 Introduction to Microsoft Excel/1. Overview of Excel Interface and Navigation.mp436.95MB
33. Chapter 10-Module 10 Data Visualization and Dashboards/34. Incorporating Slicers and Timelines for Data Filtering.mp438.13MB
34. Chapter 10-Module 10 Data Visualization and Dashboards/35. Linking Data Between Multiple Sheets and Workbooks.mp426.5MB
35. Chapter 10-Module 10 Data Visualization and Dashboards/36. Best Practices for Creating Effective Dashboards.mp434.14MB
36. Chapter 11-Module 11 Macros and Automation/37. Introduction to Excel Macros and VBA --(Visual Basic for Applications--).mp427.2MB
37. Chapter 11-Module 11 Macros and Automation/38. Editing and Debugging Macros Using the Visual Basic Editor.mp420.44MB
38. Chapter 11-Module 11 Macros and Automation/39. Customizing the Ribbon and Adding Macro Buttons.mp432.42MB