Module 1: Make Your Data Work For You
How to Conduct a SkillzXpress Course
Suggested Course Timing and Duration
Why SkillzXpress™ Courseware?
How to Use This Material Effectively
Using the Exercise and Practice Files
Skills Gauge
Reference Materials and Website
Module 2: Charts
Why Use Charts?
The Good, The Bad and The Ugly
Components of a Chart
Choose a Chart Type
Review 1
Module 3: Creating Charts In Excel
Create Charts with Chart Wizard
Move and Resize Charts
Change the Chart Type and Sub-type
Change Data Source Using Range Border
Change Data Source Using Source Data Dialog box
Add New Data Series to Chart
Change the Plot Direction
Change Location of Legend
Change Chart Location
Review 2
Practice 2
:: Course 50102 ::
Module 4: Formatting Charts
Format a Chart
Change Background Colour
Add Chart Titles
Add Chart Titles in 3D Charts
Change Text Orientation
Format Text Objects
Add Data Table
Review 3
Practice 3
Module 5: Advance Chart Features
Change Value Axis Scale
Format an Axis
Format Time-based Category Axis
Add Gridlines
Format Gridlines
Format Data Series
Add Data Labels
Create a Combination Chart
Add a Secondary Axis
Add a Trendline
Create User-defined Charts
Use a User-defined Chart
Review 4
Practice 4
Module 6: Pie Charts And Doughnut Charts
Use a Pie Chart Effectively
Create a Simple Pie Chart
Rotate the Chart and Adjust 3-D View
Explode a Pie Chart
Create a Doughnut Chart
Review 5
Practice 5
:: Course 50102 ::
Module 7: Bar And Column Charts
Use Bar and Column Charts Effectively
Create Stacked Columns
Create a 100% Stacked Bar Chart
Variations of Column and Bar Chart
Create Pictogram Charts
Review 6
Practice 6
Module 8: 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
Review 7
Practice 7
Module 9: Scatter And Bubble Charts
Create a Simple Scatter (XY) Chart
Create a Multiple XY Chart
Create a Bubble Chart
Format The Bubbles
Review 8
Practice 8
Module 10: Create INTERACTIVE CHARTS WITH LIST AND PIVOTCHARTS (OPTIONAL TOPIC)
Use Excel List For Creating Chart
Create a New List
Create a Chart from a List
Get Answers with PivotTables
Use the PivotTable Wizard
Create a PivotTable Layout
View Our Report Differently
Rearrange The Layout
Create a PivotChart Report
Create a Filtered PivotChart
Review 9
Answers to Review Questions
Programme scope, delivery arrangements and suitability are confirmed during enquiry.