About this Event
This training aims to use MS Excel to create basic to advanced and interactive charts. The module focuses on navigating the interface of Excel to perform tasks that are not as straightforward as just creating a regular chart.
- Bring own laptop with Excel
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
Where in Cubao:
Mpower Learning Manila
222 Vivaldi Residences, 628 EDSA cor Aurora Blvd., Cubao, Quezon City
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 [email protected] or chat with us to confirm.
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
Event Venue & Nearby Stays
Mpower Learning Manila, 222 Vivaldi Residences, 628 EDSA c.or Aurora Blvd, Mandaluyong City, Philippines
PHP 262.48 to PHP 2623.70
