0% found this document useful (0 votes)
24 views9 pages

Microsoft Office Excel

Download as pptx, pdf, or txt
Download as pptx, pdf, or txt
Download as pptx, pdf, or txt
You are on page 1/ 9

Training Is The Door To get Success

But Practice Is the Path of Achieving Success


 Relative = AB14
 Absolute = $AB$14
 Mixed = $AB14, AB$14
Count
Countif
Sumif
Vlookup
Hyperlink
Graph
•Chart Title
•Axis Title
•Legend
•Data label
•Data Table
•Change Chart
Type
•Chart Layout
150 •Data Series
Data1
100 •Secondary axis
50 Data2
0
•Marker
Data3

Data4
Pareto Chart
[Chart Title]
60 100%
50 80%
40
60%
30
Cause # 1
Cause # 2
Cause # 3
Cause # 4
Cause # 5
Cause # 6
Cause # 7
Cause # 8
Cause # 9

Cumulative %
40%
20
Defects

10 20%

0 0%

Causes
Vital Few Useful Many

The first 3 Causes cover 87.96% of the Total Defects

Cumulative
Percentage
Cutoff: 80%
# Causes Defects Cumulative%
1 Cause # 1 50 46.3%
2 Cause # 2 30 74.1%
3 Cause # 3 15 88.0%
4 Cause # 4 5 92.6%
5 Cause # 5 3 95.4%
6 Cause # 6 2 97.2%
7 Cause # 7 1 98.1%
8 Cause # 8 1 99.1%
9 Cause # 9 1 100.0%
10 100.0%
11 100.0%
12 100.0%
13 100.0%
14 100.0%
15 100.0%
Insert new rows above this line

You might also like