MS Excel: Charts and Dashboard
EVENT #: 71071
Go beyond basic pie and line charts! Learn different charting techniques in Excel, including dynamic charting.
No Paypal? No problem! Click here for other registration options: https://bit.ly/insightsjoin
This is a 3.5-hour session on August 19, 8:30AM-12NN via Zoom.
Go beyond basic pie and line charts! Learn different charting techniques in Excel, including dynamic charting-- the prerequisite to make dashboards in Excel!
Requirement: Advanced knowledge of MS Excel. Basic users must undergo advanced Excel training before undergoing this class.
1. Review of Chart Elements
- Pie Chart
- Line Chart
- Column Chart
-Modifying Chart Elements
- Formatting Data Labels
- Formatting Axes
- Formatting Data Series
2. Special Charts and Techniques
-Waterfall Chart and the Concept of Floating Data Points
-Gantt Chart in Excel
3. Dynamic Charts Using Tables
4. Dynamic Charts and Dashboards using PivotCharts
-Slicers and Timelines
-Managing Data for Dashboards
5. Dynamic Charts using Excel Functions
-INDIRECT Function in Charting
-Math Functions used in Charting