About this Course

Numbers, in itself and of themselves tell only half the story.  When faced with ploughing through a morass of numbers or reading a column graph, most people opt for the latter.  Communicating numbers, analysis and trend through the use of charts is a very effective (and proven) method.

This course explores chart creation techniques that go beyond the Microsoft Excel chart wizard options where an Excel user will be shown a new frontier in advance charting techniques.

Objectives

Upon completion of this workshop, participants will be able to;

• This course equips experienced Microsoft Excel users with a practical understanding of advanced data plotting and charting techniques.
  
• Examines the various formatting and trending methods, and explores ways to maximize data display with charts. 
  
• Learn to create formula-based charts, establish target values, and display meaningful charts.
  
• Learn to identify useful Excel Chart for any need and scenario and focus on how to properly design each type of chart for effective communication.
  

Target Audience

Experienced Microsoft Excel users, including project leaders, data analysts, and other officers who have a vested interest and need in plotting data and charts at the industrial, corporate, and project levels.

Duration

Two days

Methodologies

Learners must have been using Excel on a regular basis and have no difficulty creating formulas and cell formats; or must have attended Excel - Level 1 Fundamentals course (preferably also the Excel Level 2 Advanced course).

A combination of lectures, explicit teaching, practical demonstrations and peer teaching is applied for this course.

Experiential learning approach is adopted where the learners will be required to consider the experience as a learning process joined with critical reflection which further qualifies for this theory to be applied for this course because at each segment, the learners are introduced to some form of experience after which they are asked to reflect on these experiences before sharing with each other and putting ideas into practice.

Rate this course:

Log in to submit

Comments