Classroom/ Online: Yes/ Yes
Scheduling Date(s):
1) Dec 31, 2024 (classroom)
2) Mar 12, 2025 (classroom)
3) Jun 16, 2025 (classroom)
4) Sep 17, 2025 (classroom)
5) Dec 31, 2025 (classroom)
Note: Please click specific date for detailed venue and course fee etc.
Creating Eye-Catching Charts using Microsoft Excel
Microsoft Excel has many useful features such as Quick Analysis Charts, Recommended Chart, Combo Charts, Chart Elements icon, Chart Styles icon, Chart Filters icon, Formatting Task Pane, more flexible and dynamic Data Labels that offer you different options to create and format charts. Microsoft Excel introduces some new chart types such as Waterfall Chart, Histogram and Sunburst chart.
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 represent and the additional functionality that you might not have heard about.
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 represent and the additional functionality that you might not have heard about.
Objective
• Participants will be able to create professional-look charts to enhance the visualization of their reports.
• Participants will master the skills to create dynamic charts using different form controls and advanced Excel functions.
• Participants will master the skills to create dynamic charts using different form controls and advanced Excel functions.
Outline
Chapter 1: Creating Charts with Recommended Charts Tool
1.1 Using Recommended Charts Tool
1.2 Using New Chart Tools
1.3 Creating Dynamic Titles and Labels
1.4 Formatting Charts using Task Pane
1.5 Adding Pictures to Pie Chart
1.6 Adding Trendline to Line Chart
1.7 Adding Trendline to Column Chart
Chapter 2: Creating Interactive Chart from Excel Table
2.1 Introducing Excel Table
2.2 Creating Chart from Excel Table
2.3 Filtering Chart with Auto Filter
2.4 Filtering Table with Slicer
Chapter 3: Using Quick Analysis Tools for Charting
3.1 Using Formatting Tab to Create Data Bar
3.2 Using Charts Tab to Create Stacked Column Chart
3.3 Using Sparklines to Show Data Trends
Chapter 4: Creating Special Charts
4.1 Creating Combo Chart
4.2 Creating Pie of Pie Chart
4.3 Creating Project Gantt Chart
4.4 Creating Waterfall Chart
4.5 Creating Histogram
4.6 Creating Sunburst Chart
Chapter 5: Controlling Dynamic Charts using Drop-down List
5.1 Introducing Form Controls
5.2 Creating Combo Box
5.3 Creating Data Table for Combo Box Driven Chart
5.4 Creating Combo Box Control Stacked Column Chart
5.5 Creating Check Boxes
5.6 Creating Data Table for Check Box Driven Chart
5.7 Creating Check Box Control Stacked Column Chart
1.1 Using Recommended Charts Tool
1.2 Using New Chart Tools
1.3 Creating Dynamic Titles and Labels
1.4 Formatting Charts using Task Pane
1.5 Adding Pictures to Pie Chart
1.6 Adding Trendline to Line Chart
1.7 Adding Trendline to Column Chart
Chapter 2: Creating Interactive Chart from Excel Table
2.1 Introducing Excel Table
2.2 Creating Chart from Excel Table
2.3 Filtering Chart with Auto Filter
2.4 Filtering Table with Slicer
Chapter 3: Using Quick Analysis Tools for Charting
3.1 Using Formatting Tab to Create Data Bar
3.2 Using Charts Tab to Create Stacked Column Chart
3.3 Using Sparklines to Show Data Trends
Chapter 4: Creating Special Charts
4.1 Creating Combo Chart
4.2 Creating Pie of Pie Chart
4.3 Creating Project Gantt Chart
4.4 Creating Waterfall Chart
4.5 Creating Histogram
4.6 Creating Sunburst Chart
Chapter 5: Controlling Dynamic Charts using Drop-down List
5.1 Introducing Form Controls
5.2 Creating Combo Box
5.3 Creating Data Table for Combo Box Driven Chart
5.4 Creating Combo Box Control Stacked Column Chart
5.5 Creating Check Boxes
5.6 Creating Data Table for Check Box Driven Chart
5.7 Creating Check Box Control Stacked Column Chart
Who should attend
• This course is not for beginners who have no experience in using and creating Excel charts.
• Participants must be familiar with basic tasks in Excel and able to create charts, formulas and functions.
• This course is for frequent Excel users who wish to get the most out of Excel charting and graphics features.
• Participants must be familiar with basic tasks in Excel and able to create charts, formulas and functions.
• This course is for frequent Excel users who wish to get the most out of Excel charting and graphics features.
Methodology
This is a one-day hands-on practice course
Testimonials
Very comprehensive coverage on chart creation. Covers all the relevant topics that would be applicable to daily work. The trainer is cheerful and approchable, and willing to patiently spend time repeating difficult steps.
Health Sciences Authority
Ms Valene is very patient and detailed. The course was very will planned. It is full score!
JTC Corporation
Very useful and easily learnt and applied. Trainer engaged everyone and provided individual guidance when necessary.
JTC Corporation
Ms Valene had simplified training to simple and easy to understand steps for me. There were interesting sharing and short-cuts which we could use everyday. A very friendly and knowledgeable trainer.
Care Corner Singapore Ltd
Well-paced and patient trainer. Shared many useful tips and shortcuts. Things learn can be applied on my work very relevant.
Ministry of Manpower
Health Sciences Authority
Ms Valene is very patient and detailed. The course was very will planned. It is full score!
JTC Corporation
Very useful and easily learnt and applied. Trainer engaged everyone and provided individual guidance when necessary.
JTC Corporation
Ms Valene had simplified training to simple and easy to understand steps for me. There were interesting sharing and short-cuts which we could use everyday. A very friendly and knowledgeable trainer.
Care Corner Singapore Ltd
Well-paced and patient trainer. Shared many useful tips and shortcuts. Things learn can be applied on my work very relevant.
Ministry of Manpower
Profile of Valene Ang
Valene Ang is a Microsoft Certified Trainer (MCT) with a degree in Business Computing. Her Professional qualifications including Advanced Certificate in Training and Assessment (ACTA) and Master Instructor for Microsoft Office Specialist (MOS). She has broad experience in corporate IT training and course materials development.
Valene has a broad experience in customizing Microsoft Office training programs, developing customized course outlines and course materials, assisting corporate clients in business data analysis and providing dynamic report solutions. Her training focuses on providing practical solutions to real life Excel problems.
Valene conducted many Microsoft Office training in Singapore, Malaysia and China. Her corporate clients include NOL, PSA, IRAS, DFS, CPF, PUB, MOM, MOE, NEA, DHL, SingTel, Singapore Expo, Changi Airport Group, SPRING Singapore, Nanyang Polytechnic, Singapore Polytechnic, Republic Polytechnic, Denza (ShenZhen) and etc..
