Course Information
Schedules
- 30 Dec 2024 (Mon) - 13 Jan 2025 (Mon) 7:00 PM - 10:00 PM
- 20 Jan 2025 (Mon) - 27 Jan 2025 (Mon) 10:00 AM - 1:00 PM
Registration period
21 Oct 2024 (Mon) - 19 Jan 2025 (Sun)
Price
HKD 2,580
Course Level
Study Mode
Duration
9 Hour(s)
Language
Cantonese
Location
Room 603 Dominion Centre, 43-59 Queen's Road East Wanchai, Hong Kong
4 views
Course Overview
Welcome to Building Dynamic Dashboards with PivotTables! In today’s data-driven world, the ability to visualize and analyze information effectively is paramount for making informed decisions. This course is designed to empower you with the skills needed to create compelling dashboards using Excel's powerful PivotTable feature. Throughout our journey, you will learn how to transform raw data into intuitive, interactive dashboards that not only present key insights but also allow for real-time analysis. Whether you are a business professional, analyst, or data enthusiast, this course will equip you with the tools and techniques necessary to enhance your data storytelling and drive impactful results. Join us as we explore the capabilities of PivotTables and unlock the potential of your data!
What You’ll Learn
- Understanding Pivottables
- Building A Pivottable
- Manipulating Your Pivottable
- Changing The Pivottable View
- Customizing Pivottable Fields
- Setting Pivottable Options
- Performing Pivottable Calculations
- Creating Custom Pivottable Calculations
- Creating A Pivotchart
- Disperate And External Data Sources
- Designing Effective Dashboards
- Integrating Pivot Tables into Dashboards
- Adding interactivity
- Finalizing and Sharing Your Dashboard
