Building Professional Charts with Microsoft Excel (2010/2016) 2017-09-15T14:24:02+00:00

Project Description

Loading...
Welkin Course Codes: CPC0, CPC6

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 Professional Recognition

mos-certificate

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 course Business Analysis with Microsoft Excel.

Course Fee

$580

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
Enquiry/Booking
Building Professional Charts with Microsoft Excel 2016
COURSE INFODATES(dd/mm)TIMEDURATIONDAY(S)AMOUNT
CPC6-18011K
 Mongkok
 Cantonese / PC
17/1~17/1
0930-12303 hrs/
1 sessions
WED580.00
CPC6-18031C
 Central
 Cantonese / PC
12/3~12/3
0930-12303 hrs/
1 sessions
MON580.00
CPC6-18051K
 Mongkok
 Cantonese / PC
23/5~23/5
0930-12303 hrs/
1 sessions
WED580.00
CPC6-18071C
 Central
 Cantonese / PC
20/7~20/7
0930-12303 hrs/
1 sessions
FRI580.00
CPC6-18091K
 Mongkok
 Cantonese / PC
24/9~24/9
0930-12303 hrs/
1 sessions
MON580.00
CPC6-18111C
 Central
 Cantonese / PC
15/11~15/11
0930-12303 hrs/
1 sessions
THU580.00
Building Professional Charts with Microsoft Excel 2016
Complete your Enrol
How to enrol/pay online

Building Professional Charts with Microsoft Excel 2010/2007
COURSE INFODATES(dd/mm)TIMEDURATIONDAY(S)AMOUNT
THERE IS NO AVAILABLE COURSE AT THE MOMENT!
Building Professional Charts with Microsoft Excel 2010/2007
Complete your Enrol
How to enrol/pay online

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
  1. 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
  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. 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. Proceed with on-line registration or send the completed enrolment form (download) to us together with a cheque (made payable to Welkin Compuer Training) for the program fee.
  2. CEF applicants have to complete the CEF Application Form (download) and send it to us for certification. They will then send the form to the Office of the Continuing Education Fund, Room 916, 9/F, Kwai Hing Government Offices, 166-174 Hing Fong Road, Kwai Chung, New Territories, together with a photocopy of their HKID Card before course commencement.
  3. Applicants will receive application results from the Office of the CEF within 14 working days.

You may also be interested in