Data Analysis and Visualization with Microsoft Excel

1 – Data Analysis Fundamentals Introduction to data science Create and modify tables Sort and filter datasets 2 – Visualizing Data with Excel Create charts to represent trends and comparisons Format and style visualizations for clarity Apply best practices in chart design 3 – Analyzing Data with Formulas and Functions Use formulas and named ranges for efficient analysis Apply logical and lookup functions Build forms, use data validation, and automate inputs 4 – Analyzing Data with PivotTables Build PivotTables from raw data Analyze, filter, and summarize results 5 – Building Dashboards in Excel Use PivotCharts to visualize dynamic data Add slicers and timelines for interactivity Combine visual elements into a dashboard 6 – Geospatial Visualizations Create map charts to show data by location Customize and interpret map-based visuals 7 – Performing Statistical Analysis Use sparklines and trendlines to show patterns Apply the Data Analysis ToolPak for statistical insights 8 – Getting and Transforming Data Connect to outside data sources with queries Clean, combine, and shape raw data for analysis 9 – Modeling Data with Power Pivot Enable Power Pivot and load data models Use DAX formulas for advanced calculations Create relationships between datasets 10 – Presenting Insights with Reports (Optional) Plan and build formatted Excel reports for stakeholders