Module #1 Introduction to Advanced Data Analysis Overview of advanced data analysis tools in Excel, importance of data analysis, and course objectives
Module #2 Working with Large Datasets Techniques for managing and analyzing large datasets in Excel, including data filtering and grouping
Module #3 Power Query Fundamentals Introduction to Power Query, including data importing, shaping, and loading
Module #4 Power Query Advanced Techniques Advanced Power Query techniques, including data merging, grouping, and aggregating
Module #5 Data Modeling and DAX Fundamentals Introduction to data modeling and DAX (Data Analysis Expressions) in Power Pivot
Module #6 DAX Advanced Techniques Advanced DAX techniques, including measures, calculated columns, and data relationships
Module #7 Power Pivot and Power BI Integration Integration of Power Pivot with Power BI, including publishing and sharing reports
Module #8 Power BI Dashboards and Reports Creating interactive dashboards and reports in Power BI, including visualization and design best practices
Module #9 Data Visualization with Power BI Advanced data visualization techniques in Power BI, including custom visualizations and R integration
Module #10 What-If Analysis and Scenario Planning Using Excel to perform what-if analysis and scenario planning, including sensitivity analysis and data tables
Module #11 Optimization Techniques with Solver Using Solver to optimize problems, including linear and nonlinear programming
Module #12 Forecasting and Time Series Analysis Using Excel to perform forecasting and time series analysis, including exponential smoothing and ARIMA models
Module #13 Data Mining and Machine Learning Introduction to data mining and machine learning in Excel, including clustering, decision trees, and regression
Module #14 Machine Learning with Azure Machine Learning Integration of Excel with Azure Machine Learning, including data preparation and model deployment
Module #15 Geospatial Analysis and Mapping Using Excel to perform geospatial analysis and mapping, including 3D maps and Power BI integration
Module #16 Advanced Charting and Visualization Creating advanced charts and visualizations in Excel, including combination charts and waterfall charts
Module #17 Data Validation and Error Handling Techniques for data validation and error handling in Excel, including data validation rules and error trapping
Module #18 Working with External Data Sources Connecting to external data sources in Excel, including databases, APIs, and web scraping
Module #19 Automation with VBA and Macros Introduction to VBA and macros in Excel, including automation and worksheet manipulation
Module #20 Advanced VBA and Macro Techniques Advanced VBA and macro techniques, including user forms, add-ins, and error handling
Module #21 Collaboration and Sharing in Excel Techniques for collaboration and sharing in Excel, including co-authoring, OneDrive, and SharePoint
Module #22 Excel Add-ins and Third-Party Tools Using Excel add-ins and third-party tools, including Power BI Publisher and Excel Power Utilities
Module #23 Best Practices for Data Analysis Best practices for data analysis in Excel, including data quality, data cleaning, and result interpretation
Module #24 Case Studies in Advanced Data Analysis Real-world case studies in advanced data analysis, including data mining, machine learning, and optimization
Module #25 Course Wrap-Up & Conclusion Planning next steps in Advanced Data Analysis Tools in Excel career
