This training aims to use MS Excel to create basic to advanced and interactive charts.
VENUE
-Mpower Training Center
-222 Vivaldi Residences, EDSA cor Aurora Blvd.., Cubao, Quezon City
-Bring own laptop with Excel
TIME
All schedules are set at 8AM-5PM. However, if the headcount is low, the training may be set at 9AM-4PM or 9AM-5PM. Your certificate, still, will indicate 8 hours.The start time and end time will be finalized three days before the class. Please look for an email
from us or chat with us to confirm.
INCLUSIONS
For onsite:
-printed handout
-printed certificate
-fastfood lunch
-AM and PM snacks
-candies and coffee
-WIFI access
For via Zoom:
-PDF handout
-PDF certificate
Outline
OUTLINE
I . Introduction to Charting in Excel
• Creating Basic Charts
• Modifying Chart Formats
• Editing Chart Elements and When to Use Them
• Labels: Axis and Data Labels
• Data Points and Data Series
• Gridlines and Tick Marks
• Legends and Data Tables
II. Creating Special Charts
• Showing Relationships with Scatter Charts
• Sparklines
• Showing Flow of Numbers using Waterfall Charts and Bridge Charts
• Maximizing Area Charts
• Histograms
• Bubble Charts
• Showing Geographical Data with Map Charts
• Showing Hierarchy with Tree Maps and Sunburst Charts
III. Executing Complex Chart Concepts
• Charts with Triple Axis
• Creating Thermometer Charts
• Creating Gauge Charts
IV. Creating Interactive Charts
• Dynamic Charts using INDIRECT
• Dynamic Charts using OFFSET
• Dynamic Charts using Pivot Charts
V. Linking Charts to PowerPoint
• Linking Charts from Excel to PowerPoint
• Embedding Charts
• Using Paste Special to Link Charts