Module #1 Getting Started with Advanced Excel Overview of advanced Excel features, Importance of data analysis, and Setting up Excel for data analysis
Module #2 Data Preparation and Cleaning Importing data, Removing duplicates, Handling missing values, and Data normalization
Module #3 Data Visualization Fundamentals Introduction to data visualization, Best practices for charts and graphs, and Common chart types
Module #4 Working with PivotTables Creating PivotTables, Customizing PivotTables, and Using PivotCharts
Module #5 Data Analysis with INDEX-MATCH Using INDEX-MATCH instead of VLOOKUP, Advanced applications of INDEX-MATCH
Module #6 Power Query Fundamentals Introduction to Power Query, Connecting to data sources, and Data transformation
Module #7 Advanced Power Query Techniques Merging queries, Grouping and aggregating data, and Using Power Query formulas
Module #8 Data Modeling and DAX Introduction to data modeling, Creating calculated columns and measures, and Using DAX formulas
Module #9 Working with Power Pivot Creating Power Pivot tables, Building data models, and Analyzing data with Power Pivot
Module #10 Advanced Charting and Visualization Creating interactive dashboards, Using slicers and filters, and Advanced chart types
Module #11 Working with Macros Introduction to VBA, Recording and editing macros, and Using macros for data analysis
Module #12 Data Validation and Error Handling Using data validation, Handling errors with IFERROR and IFBLANK, and Using error handling techniques
Module #13 Working with Dates and Times Using date and time functions, Converting date and time formats, and Using date and time calculations
Module #14 Advanced Text Functions Using text functions, such as LEN, LOWER, and PROPER, and Using regular expressions
Module #15 Working with Arrays and Tables Using arrays and tables, Creating dynamic arrays, and Using array formulas
Module #16 Data Analysis with Advanced Formulas Using advanced formulas, such as AGGREGATE and FILTER, and Using formula auditing techniques
Module #17 Working with External Data Connecting to external data sources, Importing data from web pages, and Using web queries
Module #18 Data Analysis with Power BI Introduction to Power BI, Creating reports and dashboards, and Using Power BI for data analysis
Module #19 Advanced Data Visualization Techniques Using advanced visualization techniques, such as heatmaps and treemaps, and Creating interactive visualizations
Module #20 Working with Big Data Handling large datasets, Using Power Query for big data, and Using Excels data analysis add-ins
Module #21 Advanced Data Modeling Techniques Using advanced data modeling techniques, such as many-to-many relationships, and Using data modeling best practices
Module #22 Working with Power Apps Introduction to Power Apps, Creating custom apps, and Using Power Apps for data analysis
Module #23 Advanced Data Analysis Techniques Using advanced data analysis techniques, such as clustering and regression, and Using Excels built-in data analysis tools
Module #24 Data Storytelling and Communication Using data visualization to tell stories, Creating effective reports, and Communicating insights to stakeholders
Module #25 Course Wrap-Up & Conclusion Planning next steps in Introduction to Advanced Excel for Data Analysis career
