Duration: 1 day
Time: 9am to 6pm

What Will Be Taught For This MS Excel Training Course?

This 1 day workshop empowers you the basic concepts of charting and to demonstrate the ability to create and use charts on a personal computer. You will be able to accomplish operations associated with developing, formatting and using charts in Microsoft Office.

Module 1. Charting
  • Introduction
  • Philosophy
  • Psychology
  • Anatomy
  • Chart Types
Module 2. Creating Charts in Excel
  • Creating Charts with the Chart Wizard
  • Moving and Resizing Charts
  • Identifying Chart Objects
  • Changing the Chart Type
  • Changing the Chart Type and Sub-type
  • Changing the Plot Direction
  • Removing/Adding a Legend
  • Moving the Legend
  • Charting Non-adjacent Ranges
  • Changing the Chart Range
  • Changing the Data Source
  • Changing the Chart Location
  • Printing a Chart
  • Creating Charts
Module 3. Formatting Charts in Excel
  • Adding Chart Titles
  • Formatting Chart Objects
  • Changing the Text Orientation
  • Adding a Data Table
  • Creating an Exploded Pie Chart
  • Adjusting the 3-D View
  • Deleting a Chart
  • Formatting Charts
  • Applying User-defined Charts
Module 4. Advanced Charting in Excel
  • Adding and Removing Gridlines
  • Formatting Gridlines
  • Formatting an Axis
  • Changing the Axis Scaling
  • Formatting the Data Series
  • Adding Data - Different Worksheets
  • Using a Secondary Axis
  • Changing Data Series Chart Types
  • Adding a Trendline
Module 5. Charts Exploration
  • Pie Chart
  • Bar/Column Charts
  • Pictogram Charts
  • Histogram Charts
  • Polygons Charts
  • Line Charts
  • XY – Scatter Charts
  • Radar Charts
  • Bubble
  • Cartogram
Module 6 - Bar And Column Charts
  • Use Bar and Column Charts Effectively
  • Create Stacked Column
  • Create a 100% Stacked Bar Chart
  • Variations of Column and Bar Chart
  • Create Pictogram Charts
Module 7 – Line And Area Charts
  • Use Line and Area Charts
  • Create Line Chart with Markers
  • Summarize Data into Months
  • Use Stacked Line Chart to Determine Total
  • Change Data Series Order in Area Chart
Module 8 – Scatter And Bubble Charts
  • Create a Simple Scatter (XY) Chart
  • Create a Multiple XY Chart
  • Create a Bubble Chart
  • Format The Bubbles
Module 9 – Create Interactive Charts With List And Pivotcharts (Optional Topic)
  • Use Excel Table For Creating Chart
  • Create a New Table
  • Create a Chart from a Table
  • Get Answers with PivotTables
  • Insert a PivotTable
  • Create a PivotTable Layout
  • View the Report Differently
  • Rearrange The Layout
  • Create a PivotChart Report
  • Create a Filtered PivotChart
Module 10 – Case Studies (Optional Topic)
  • Case Study 1
  • Case Study 2

Who Should Attend This Microsoft Excel Course Training?

Anyone with general proficiency in Microsoft Excel 2013 and looking to create and use charts in Excel.

Pre-requisite

An understanding of Windows / MS Office Excel 2013 will be an added advantage.

  w/o GST w GST
Course Fee $320 $342.40

 




Please click on the course date to enrol.


  • CL: Classroom Learning
  • VILT: Virtual Instructor-Led Training
  • GTR: Guaranteed To Run
  • Sat: Saturday
  • Wkn: Weekend
Note: Courses are conducted via classroom unless stated otherwise beside the course dates.