Name Ultimate Microsoft Excel With Data Analysis & VBA Macros

File Type video

Size 1.17GB

UpdateDate 2024-10-25

hash *****9A2D74B522AE0368066D2FFCCAFD99C19D

Hot 1

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