Project Description


Welkin Course Codes: CPC9

Course Features

Microsoft Excel is a convenient and powerful tool to create charts. The graphical nature of a chart attracts attention and help readers understand data trends and analyses better. This course demonstrates how data can be communicated and visualized effectively through the use of charts. Course topics include:

  • Basic charts creation and their types
  • Chart formats and modifications
  • Chart designs and templates
On course completion, you will be able to create different types of charts with Microsoft Excel to present data graphically.
  • Qualified and experienced instructors
  • Easy-to-follow, step-by-step hands-on learning approach
  • Best practices explained and demonstrated

Learn from the Experts

Get Your Skills Certified

Certify your Excel skills with Microsoft Office Specialist Excel certification. The certification is not a requirement for course completion but we highly recommend you to get your skills professionally recognized.
Remark: The course fee does not include the certification exam.

Further Study

After completing this course you may further develop your knowledge and skills in Microsoft Excel with the CEF reimbursable course Business Analysis with Microsoft Excel.

Course Fee


Course Duration

3 Hours

Course Prerequisites

Course participants should have a basic knowledge of Microsoft Excel.

Title of Award

Upon successful completion of the course, students will receive a Certificate of Achievement.

Schedule & Online Enrolment

Sign up for your course by clicking the Enrol button and proceed to Checkout to finish course registration.

Building Professional Charts with Microsoft Excel 2019
Course No. 課程編號Info. 語言/系統/地點Start 開課日End 完課日Day(s) 上課日Time 上課時段Duration 課程長度Enrol 報名
CPC9-22011KCantonese / PC / MongKok04/0104/01TUE0930-12303 hours / 1 sessions20220104


CPC9-22031KCantonese / PC / MongKok25/0325/03FRI1400-17003 hours / 1 sessions20220325


CPC9-22051KCantonese / PC / MongKok03/0503/05TUE0930-12303 hours / 1 sessions20220503


CPC9-22071KCantonese / PC / MongKok29/0729/07FRI1400-17003 hours / 1 sessions20220729


CPC9-22091KCantonese / PC / MongKok01/0901/09THU0930-12303 hours / 1 sessions20220901


CPC9-22111KCantonese / PC / MongKok07/1107/11MON1400-17003 hours / 1 sessions20221107


A chart is a powerful tool to graphically present the results of data analysis or market trends. This course is specially designed for those who want to master Excel’s chart creation features. Completing the course will enable you to create different types of charts and use a variety of techniques to build charts with a professional look. You will also learn how to make use of multiple combination charts to enhance data presentation effectiveness.

  1. Building Charts with Excel
    • An Overview of Excel Charting
    • Creating Charts with the Chart Wizard
    • Excel Chart Types
    • Printing Charts
    • Troubleshooting
    • Excel in Practice
  2. Modifying Excel Charts
    • Options for Improving Your Charts
    • Changing the Chart Type
    • Changing a Data Series
    • Adding a Secondary Axis to the Chart
    • Value Axis Scaling
    • Category Axis Scaling
    • Changing the Series Order
    • Adding a Trendline to a Data Series
    • Troubleshooting
    • Excel in Practice
  3. Formatting Charts
    • An Overview of Formatting Charts
    • Formatting Lines: Axes, Tick Marks, High/Low Lines, and Error Bars
    • Formatting Text: Data Labels, Titles, Legends, and Text Boxes
    • Enhancing Charts with Shapes
    • Formatting Data Series
    • Changing the Border, Color, or Fill of a Chart Item
    • Formatting 3D Charts
    • Troubleshooting
    • Excel in Practice
  1. Creating Chart
    • Column Chart
    • Bar Chart
    • Line Chart
    • Bar Chart
    • Radar Chart
    • XY Scatter
    • Others
  2. Professional Charting Techniques
    • Formatting Charts for a Professional Look
    • Creating Column Depth
    • Pie Chart Techniques
    • Using Fill Effects to Show Variance in 3D Charts
    • Using Form Controls with Charts
    • Stacking Multiple Charts
    • Creating Cost and Production Curves with Charts for Variance
    • Linking Chart Text to Worksheet Cells
    • Charting Hidden Data
    • Creating Effective Multiple-Combination Charts
  1. You can enrol this course by our online system, or call (852) 3605 3322 for reservation.

You may also be interested in