Ultimate Microsoft Excel With Data Analysis & VBA Macros

文件列表

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