MS Excel: Charts and Dashboard


August 19, 2021

Manila, Philippines



Advertisement


Click an image to zoom. MS Excel: Charts and Dashboard

EVENT #: 71071

EVENT DESCRIPTION

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

-Basic Charts

- Pie Chart

- Line Chart

- Column Chart

-Modifying Chart Elements

- Formatting Data Labels

- Formatting Axes

- Formatting Data Series

-Combination Charts

2. Special Charts and Techniques

-Waterfall Chart and the Concept of Floating Data Points

-Gantt Chart in Excel

-Conditional Charts

3. Dynamic Charts Using Tables

4. Dynamic Charts and Dashboards using PivotCharts

-Advanced PivotTables

-Grouping

-Slicers and Timelines

-Connecting PivotTables/PivotCharts

-Dashboards

-Managing Data for Dashboards

-Dashboard Visualization

5. Dynamic Charts using Excel Functions

-INDIRECT Function in Charting

-Math Functions used in Charting




Share this event:  

EVENT LOCATION

Manila, Philippines
August 19, 2021

RELATED EVENTS


TALK ABOUT THIS EVENT


OUR AFFILIATES



ADVERTISEMENTS