Ultimate Microsoft Excel With Data Analysis & VBA Macros

mp4   Hot:7   Size:1.17 GB   Created:2024-10-25 08:58:47   Update:2024-11-23 16:11:06  

File List

  • Chapter 10-Module 10 Data Visualization and Dashboards/33. Designing Interactive Dashboards Using Excel Features.mp4 68.06 MB
    Chapter 1-Module 1 Introduction to Microsoft Excel/1. Overview of Excel Interface and Navigation.srt 11.38 KB
    Chapter 1-Module 1 Introduction to Microsoft Excel/2. Understanding Worksheets, Rows, Columns, and Cells.mp4 17.4 MB
    Chapter 1-Module 1 Introduction to Microsoft Excel/2. Understanding Worksheets, Rows, Columns, and Cells.srt 6.47 KB
    Chapter 1-Module 1 Introduction to Microsoft Excel/3. Entering and Editing Data Efficiently.mp4 29.31 MB
    Chapter 1-Module 1 Introduction to Microsoft Excel/3. Entering and Editing Data Efficiently.srt 8.36 KB
    Chapter 2-Module 2 Basic Formatting and Cell Management/4. Applying Cell Styles and Themes.mp4 28.21 MB
    Chapter 2-Module 2 Basic Formatting and Cell Management/4. Applying Cell Styles and Themes.srt 7.32 KB
    Chapter 2-Module 2 Basic Formatting and Cell Management/5. Merging and Splitting Cells.mp4 20.08 MB
    Chapter 2-Module 2 Basic Formatting and Cell Management/5. Merging and Splitting Cells.srt 6.32 KB
    Chapter 2-Module 2 Basic Formatting and Cell Management/6. Managing Rows, Columns and Worksheets.mp4 33.46 MB
    Chapter 2-Module 2 Basic Formatting and Cell Management/6. Managing Rows, Columns and Worksheets.srt 8.84 KB
    Chapter 3-Module 3 Basic Formulas and Functions/7. Introduction to Excel functions --(SUM, AVERAGE, MAX, MIN--).mp4 20.96 MB
    Chapter 3-Module 3 Basic Formulas and Functions/7. Introduction to Excel functions --(SUM, AVERAGE, MAX, MIN--).srt 6.9 KB
    Chapter 3-Module 3 Basic Formulas and Functions/8. Writing Basic Formulas for Calculations.mp4 20.71 MB
    Chapter 3-Module 3 Basic Formulas and Functions/8. Writing Basic Formulas for Calculations.srt 8.18 KB
    Chapter 3-Module 3 Basic Formulas and Functions/9. Absolute and Relative Cell References.mp4 19.25 MB
    Chapter 3-Module 3 Basic Formulas and Functions/9. Absolute and Relative Cell References.srt 6.31 KB
    Chapter 3-Module 3 Basic Formulas and Functions/10. Using AutoSum and AutoFill for Efficiency.mp4 20.06 MB
    Chapter 3-Module 3 Basic Formulas and Functions/10. Using AutoSum and AutoFill for Efficiency.srt 6.64 KB
    Chapter 4-Module 4 Intermediate Functions and Formula Techniques/11. Utilizing Logical Functions --(IF, AND, OR--).mp4 28.16 MB
    Chapter 4-Module 4 Intermediate Functions and Formula Techniques/11. Utilizing Logical Functions --(IF, AND, OR--).srt 9.86 KB
    Chapter 4-Module 4 Intermediate Functions and Formula Techniques/13. Working with Date and Time Functions.mp4 22.84 MB
    Chapter 4-Module 4 Intermediate Functions and Formula Techniques/13. Working with Date and Time Functions.srt 8.16 KB
    Chapter 5-Module 5 Data Management and Analysis/14. Introduction to Excel Tables for Structured Data Management.mp4 35.67 MB
    Chapter 5-Module 5 Data Management and Analysis/14. Introduction to Excel Tables for Structured Data Management.srt 9.85 KB
    Chapter 5-Module 5 Data Management and Analysis/15. Sorting and Filtering Data.mp4 32.52 MB
    Chapter 5-Module 5 Data Management and Analysis/15. Sorting and Filtering Data.srt 9.01 KB
    Chapter 5-Module 5 Data Management and Analysis/16. Using Data Validation to Control Input.mp4 39.63 MB
    Chapter 5-Module 5 Data Management and Analysis/16. Using Data Validation to Control Input.srt 12.74 KB
    Chapter 5-Module 5 Data Management and Analysis/17. Removing Duplicates and Cleaning Data.mp4 29.18 MB
    Chapter 5-Module 5 Data Management and Analysis/17. Removing Duplicates and Cleaning Data.srt 7.14 KB
    Chapter 5-Module 5 Data Management and Analysis/18. Using Sparkline for Quick Data Visualization.mp4 26.55 MB
    Chapter 5-Module 5 Data Management and Analysis/18. Using Sparkline for Quick Data Visualization.srt 8.35 KB
    Chapter 6-Module 6 Charts and Graphs/19. Creating and Customizing Charts --(bar, line, pie, etc.--).mp4 38.92 MB
    Chapter 6-Module 6 Charts and Graphs/19. Creating and Customizing Charts --(bar, line, pie, etc.--).srt 9.42 KB
    Chapter 6-Module 6 Charts and Graphs/20. Adding Titles, Labels, and Legends to Charts.mp4 33.53 MB
    Chapter 6-Module 6 Charts and Graphs/20. Adding Titles, Labels, and Legends to Charts.srt 8.56 KB
    Chapter 6-Module 6 Charts and Graphs/21. Formatting Chart Elements for Clarity and Aesthetics.mp4 40.08 MB
    Chapter 6-Module 6 Charts and Graphs/21. Formatting Chart Elements for Clarity and Aesthetics.srt 10.22 KB
    Chapter 7-Module 7 PivotTables and Pivot Charts/22. Understanding PivotTables and Pivot Charts.mp4 30.7 MB
    Chapter 7-Module 7 PivotTables and Pivot Charts/22. Understanding PivotTables and Pivot Charts.srt 7.52 KB
    Chapter 7-Module 7 PivotTables and Pivot Charts/23. Creating PivotTables to Analyze and Summarize Data.mp4 22.36 MB
    Chapter 7-Module 7 PivotTables and Pivot Charts/23. Creating PivotTables to Analyze and Summarize Data.srt 5.26 KB
    Chapter 7-Module 7 PivotTables and Pivot Charts/24. Modifying PivotTable Layout and Appearance.mp4 35.15 MB
    Chapter 7-Module 7 PivotTables and Pivot Charts/24. Modifying PivotTable Layout and Appearance.srt 8.83 KB
    Chapter 7-Module 7 PivotTables and Pivot Charts/25. Creating Dynamic Reports with Pivot Charts.mp4 43.45 MB
    Chapter 7-Module 7 PivotTables and Pivot Charts/25. Creating Dynamic Reports with Pivot Charts.srt 10.38 KB
    Chapter 8-Module 8 Advanced Data Analysis/26. Utilizing Advanced Functions --(VLOOKUP, HLOOKUP, INDEX, MATCH--).mp4 40.72 MB
    Chapter 8-Module 8 Advanced Data Analysis/26. Utilizing Advanced Functions --(VLOOKUP, HLOOKUP, INDEX, MATCH--).srt 14.45 KB
    Chapter 8-Module 8 Advanced Data Analysis/27. Performing Statistical Analysis with Functions --(COUNTIF, SUMIF, AVERAGEIF--).mp4 22.5 MB
    Chapter 8-Module 8 Advanced Data Analysis/27. Performing Statistical Analysis with Functions --(COUNTIF, SUMIF, AVERAGEIF--).srt 6.5 KB
    Chapter 8-Module 8 Advanced Data Analysis/28. Working with Array Formulas for Complex Calculations.mp4 22.77 MB
    Chapter 8-Module 8 Advanced Data Analysis/28. Working with Array Formulas for Complex Calculations.srt 8.11 KB
    Chapter 9-Module 9 Advanced Charting Techniques/29. Creating Combination Charts and Dual-Axis Charts.mp4 30.55 MB
    Chapter 9-Module 9 Advanced Charting Techniques/29. Creating Combination Charts and Dual-Axis Charts.srt 7.26 KB
    Chapter 9-Module 9 Advanced Charting Techniques/30. Adding Trendlines and Error Bars to Charts.mp4 27.43 MB
    Chapter 9-Module 9 Advanced Charting Techniques/30. Adding Trendlines and Error Bars to Charts.srt 7.93 KB
    Chapter 9-Module 9 Advanced Charting Techniques/31. Creating Dynamic Charts with Form Controls.mp4 50.38 MB
    Chapter 9-Module 9 Advanced Charting Techniques/31. Creating Dynamic Charts with Form Controls.srt 13.96 KB
    Chapter 9-Module 9 Advanced Charting Techniques/32. Using Advanced Charting Features for Data Visualization.mp4 49.77 MB
    Chapter 9-Module 9 Advanced Charting Techniques/32. Using Advanced Charting Features for Data Visualization.srt 12.76 KB
    Chapter 1-Module 1 Introduction to Microsoft Excel/1. Overview of Excel Interface and Navigation.mp4 36.95 MB
    Chapter 10-Module 10 Data Visualization and Dashboards/33. Designing Interactive Dashboards Using Excel Features.srt 17.94 KB
    Chapter 10-Module 10 Data Visualization and Dashboards/34. Incorporating Slicers and Timelines for Data Filtering.mp4 38.13 MB
    Chapter 10-Module 10 Data Visualization and Dashboards/34. Incorporating Slicers and Timelines for Data Filtering.srt 9.2 KB
    Chapter 10-Module 10 Data Visualization and Dashboards/35. Linking Data Between Multiple Sheets and Workbooks.mp4 26.5 MB
    Chapter 10-Module 10 Data Visualization and Dashboards/35. Linking Data Between Multiple Sheets and Workbooks.srt 5.87 KB
    Chapter 10-Module 10 Data Visualization and Dashboards/36. Best Practices for Creating Effective Dashboards.mp4 34.14 MB
    Chapter 10-Module 10 Data Visualization and Dashboards/36. Best Practices for Creating Effective Dashboards.srt 7.88 KB
    Chapter 11-Module 11 Macros and Automation/37. Introduction to Excel Macros and VBA --(Visual Basic for Applications--).mp4 27.2 MB
    Chapter 11-Module 11 Macros and Automation/37. Introduction to Excel Macros and VBA --(Visual Basic for Applications--).srt 8.43 KB
    Chapter 11-Module 11 Macros and Automation/38. Editing and Debugging Macros Using the Visual Basic Editor.mp4 20.44 MB
    Chapter 11-Module 11 Macros and Automation/38. Editing and Debugging Macros Using the Visual Basic Editor.srt 5.83 KB
    Chapter 11-Module 11 Macros and Automation/39. Customizing the Ribbon and Adding Macro Buttons.mp4 32.42 MB
    Chapter 11-Module 11 Macros and Automation/39. Customizing the Ribbon and Adding Macro Buttons.srt 9 KB

Download Info

  • Tips

    “Ultimate Microsoft Excel With Data Analysis & VBA Macros” Its related downloads are collected from the DHT sharing network, the site will be 24 hours of real-time updates, to ensure that you get the latest resources.This site is not responsible for the authenticity of the resources, please pay attention to screening.If found bad resources, please send a report below the right, we will be the first time shielding.

  • DMCA Notice and Takedown Procedure

    If this resource infringes your copyright, please email([email protected]) us or leave your message here ! we will block the download link as soon as possiable.