Excel for Data Analysis & Visualization
Advancing to more complex charts. Create a range of visualizations in Excel for different data layouts, ensuring your incorporate best practices to build dashboards. You'll explore how to work with dual series and prepare more advanced charts, such as Bullet charts, Waterfall charts, or Scatter plots. We will also investigate various chart editing options.
Data Visualization best practices. We'll improve your skills in selecting chart elements, applying colors, legends, and labels, while also learning how to troubleshoot and customize poorly designed visuals for the benefit of end users. We'll explore PivotTables, PivotCharts, and how to combine them into a dynamic mini-dashboard. Are you ready to unlock the true power of your data?
WEEK 13-14 | 5 Modules | 6+ Hours | 2+ Skills
Course Modules: Building basic charts | Analyzing Data with Charts | Advancing to more complex charts | Data visualization best practices | Visualizing disaggregated data with PivotCharts.
Course Contents