Use charts to present data
Uploaded time: August 17, 2022 Difficulty Beginner
Use charts to present data
The key points of this lesson
In this lesson, we've introduced different types of charts.
Column chart, line chart, pie chart, bar chart, area chart, scatter chart, radar chart, and a bubble chart, each chart has its own features that we should select the chart which best fits the topic.
- For example, bar charts and column charts are suitable for comparing data, but having too many data categories may lead the chart to be less intuitive.
- Line charts and area charts can show data changes intuitively, which tell data increases and decreases through the fluctuation of the lines.
- Pie chart indicates the proportion of a subset in the total, serving as a good choice for analyzing the percentages of regional sales.
Many different elements make up a chart, such as title, data labels, trendlines, and so on. Try to control the number of elements and keep it simple and easy to understand.
You'll Learn
The basics of WPS Spreadsheet.
The most commonly-used batch processing skills for increasing productivity.
Process large data in WPS Spreadsheet.
Master the popular PivotTables to create dynamic reports.
Nest dynamic formulas, including the IF, VLOOKUP, SUMIF, and MATCH functions to impress your leader.
Acquire skills in improving security, sharing, co-editing, and printing files.
Course Content
Start from beginners, from theory to practice, don't worry about learning
Basics of WPS Spreadsheet
6 lectures
3592 minutes
How to make a table efficiently
6 lectures
3664 minutes
Most commonly-used Formula Skills
5 lectures
3471 minutes
PivotTable
2 lectures
1329 minutes
Data Visualization
6 lectures
3709 minutes
Security and Painting
3 lectures
1896 minutes
You'll Get
- 300+ Mins Videos
- 100+ Real Cases
- 40+ Practice Files
Comments
Catalogue
1. Basics of WPS Spreadsheet
1-1. Get to know WPS Spreadsheet
10m26s
1-2. Create a chart from scratch
8m59s
1-3. How to input data into a table efficiently
12m21s
1-4. How much do you know about data format
8m41s
1-5. How much do you know about data format 2
10m25s
1-6. How to carry out simple calculations in a table
9m
2. How to make a table efficiently
2-1. The Go to and Find & Replace function of data
11m15s
2-2. How to efficiently sort and filter data part
13m31s
2-3. Data validation to help you limit the content of your forms
11m12s
2-4. A few efficient ways to handle large data
9m14s
2-5. How to Process data with Text to Columns
7m31s
2-6. How to merge and split files
8m21s
3. Most commonly-used Formula Skills
3-1. Get started with functions and formulas
10m29s
3-2. Most-used Statistical Functions
11m28s
3-3. Do you really know about the Logical functions?
11m52s
3-4. Quick to learn the time and dates functions
11m58s
3-5. A magical function everyone needs to know: VLOOKUP
12m4s
4. PivotTable
4-1. Use PivotTable to analyze data
11m54s
4-2. Use PivotTable to analyze data 2
10m15s
5. Data Visualization
5-1. Apply conditional formatting to data
11m12s
5-2. Use charts to present data
9m15s
5-3. Different ways to utilize column charts
11m5s
5-4. Line Charts and Area Charts
9m37s
5-5. Pie Charts and Sparklines
10m2s
5-6. Beautify The Table
10m38s
6. Security and Painting
6-1. How to protect your worksheet and workbook
9m35s
6-2. Share and revise workbooks
9m38s
6-3. How to print a table
12m23s
Does this video help you?