Course Information

Date18 May 2020, Mon
Time9:00 AM - 5:00 PM
VenueRoyal Plaza on Scotts Singapore Hotel Including Tea breaks and International Gourmet Buffet Lunch at Award winning Carousel Restaurant (Halal Certified)
FeeS$ 500 (Nett)
ContactJaslyn
9767 9686 / 6278 9785
jaslyn@cbsgroup.com.sg
Register

Registration is on a 1st come 1st serve basis. Register early to avoid disappointment.

Testimonials

I've been making full length films and documentaries for many years. We use professional equipment and…
Nay Win Tun, Video Editor
Perfect Your Elevator Pitch through Digital Storytelling
Very through and comprehensive
– NAFA
1 day Workshop on The Motivational Conversation - Rodney Woulfe
I will recommend this to my colleagues who have negative attitude towards their life, so that they can…
– Nanyang Technological University
1 day Influencing Difficult People in the Workplace by Ms Nancy Yeo
Nancy is very clear, engaging and insightful. She is able to tap on her vast experience to share with…
– WWW Cargo Pte Ltd
1 day Influencing Difficult People in the Workplace by Ms Nancy Yeo
‹ back to previous page
18
May 2020

Visualizing Data with Advanced Charts in Microsoft Excel 2016

Mastering Excel charts & graphs and build custom visuals!

Excel charts are commonly used for data visualization and presentation. This course provides highly interactive, hands-on, and practical guide to an easy to understand visualization of data.

Apart from the default charts that are available in Excel, there are new advanced charts that you can easily create and use in your day-to-day work. Microsoft Excel 2016 introduces 6 new built-in chart types:- Waterfall, Histogram, Pareto, Box & Whisker, Treemap, and Sunburst that you can use to make your reports or dashboards more impressive.

This course will provide you useful knowledge and skills to create interactive charts for your professional reports. You will learn what each chart and graph represents and the additional functionality that you might not have heard about.

COURSE BENEFITS

COURSE BENEFITS
  • Understand WHEN, WHY, and HOW to use the new build-in different chart types in Excel 2016
  • Comprehensive understanding of Excel’s latest data visualization tools and techniques
  • Explore that Excel is an incredibly powerful and dynamic data visualization platform
  • Create stunning, beautiful, and effective data visualizations in excels
  • Tell meaningful and engaging stories to decision-makers
  • Mastering unique tips, and tools to customize the look and feel of the charts
  • Build charts and graph to present your reports, charts or dashboards to the next level

COURSE OBJECTIVES

COURSE OBJECTIVES
  • Participants will be able to create professional-look charts to enhance the visualization of their reports or dashboards.
  • Participants will learn quick and effective way to create dynamic charts with form controls and Excel functions.

COURSE OUTLINE

COURSE OUTLINE
Using the Built-In Chart Types

  1. Creating Pie-of-Pie Chart
  2. Creating Column Chart to Compare Targets
  3. Creating Dynamic Chart Titles and Axis Titles
  4. Using Chart Elements, Chart Styles and Chart Filter
  5. Adding Trendline to Line Chart
  6. Forecasting using Trendline
  7. Adding Trendline to Column Chart
  8. Working with Chart Template

Using the In-Cell Charting Tools

  1. Creating Data Bar with Conditional Formatting
  2. Editing Conditional Formatting Rules
  3. Adding Icon Sets to Data
  4. Creating Line Sparklines to Show Data Trends
  5. Creating Column Sparklines to Compare Data
  6. Creating Win/Loss Sparklines to Show Binary Data

Exploring New Chart Types

  1. Creating Treemap Chart
  2. Creating Sunburst Chart
  3. Creating Histogram
  4. Creating Pareto Chart
  5. Creating Box and Whisker Chart
  6. Creating Waterfall Chart

Creating Advanced Charts

  1. Creating Combo Chart
  2. Creating Gantt Chart
  3. Creating Actual vs Target Chart
  4. Displaying Percentage on Category Axis
  5. Displaying Symbol on Category Axis
  6. Displaying Multi Line Category Labels Chart
  7. Creating Combo Box Control Chart
  8. Creating Check Box Control Chart
  9. Using Spin Button Control to Change Chart Type

WHO SHOULD ATTEND

WHO SHOULD ATTEND
  • Participants must be familiar with basic tasks in Microsoft Excel 2016 and able to create charts, formulas and functions.
  • This course is for frequent Microsoft Excel 2016 users who wish to get the most out of Excel charting and graphics features.
  • This course is not for beginners who have no experience in using and creating Excel charts.

Participants should bring a laptop with Windows version Microsoft Excel 2016.
This course is not for MAC version Microsoft Excel.

TRAINING METHODOLOGY

TRAINING METHODOLOGY
Instructor led with hands-on exercises.

Participants are required to bring a laptop equipped with Windows version Microsoft Excel 2016

This course is NOT for MAC version Microsoft Excel users

ABOUT THE TRAINER

ABOUT THE TRAINER
Microsoft Excel Expert and Microsoft Certified Trainer: Valene Ang

Valene Ang is an experienced certified IT trainer with over 19 years of experience in training professionals from various organisations. She received her degree in Business Computing from the University of Southern Queensland, Australia. Her Professional qualifications including Advanced Certificate in Training and Assessment (ACTA) and Master Instructor for Microsoft Office Specialist (MOS).

Valene has extensive training and course development experience. She customized many Microsoft Office training courses for corporate clients, assist them in business data analysis and provide dynamic report solutions. Her training focuses on 100% hands-on exercises as well as providing practical solutions to real life Excel related problems.

Valene conducted many Microsoft Excel, PowerPoint and Word training in Singapore, Malaysia and China. Her corporate clients include CPF, PUB, MOM, PSA, IRAS, DFS, MOE, NEA, DHL, SingTel, Singapore Expo, Changi Airport Group, SPRING, FairPrice and many more.

10 Years of successful track records

Our clients share our passion for people development. We take a long term view of relationships and the
deep and sustained impact has been greatly fulfilling. We have trained over 26,000 learners to date.

AIRBUS
AVIVA
CISCO
DHL
ExxonMobil
mapletree
NUS - National University of Singapore
PSA - The World's Port of Call
PUB - Water for All Conserve, Value, Enjoy
sembcorp
Singapore Airlines
Singapore Tourism Board
Standard Chartered
StarHub
WDA - Singapore Workforce Development Agency