DTube Tutorial - Creating Charts in Excel by steemitph

steemph · @steemitph · Jul 15 '18

$3.46

DTube Tutorial - Creating Charts in Excel

<center><a href='https://d.tube/#!/v/steemitph/h3irvout'><img src='https://ipfs.io/ipfs/QmRC2DsDtYrS8V26tEjE2D6sowmpmDyaqNmvMshQTBcQza'></a></center><hr>

Our daughter Sam asked me to teach her how to create charts using Microsoft Excel. I thought about creating a video while doing so for a couple of reasons; 1 to document one of the very rare times I am helping Sam with school work, and 2 to help her classmates whose parents might not be very familiar with Microsoft excel. I am quite pleased that the curriculum for Home Economics and Livelihood Education now includes learning about use of basic computer applications. During my time, Home Economics and Livelihood Education was mostly about gardening, sawing, and carpentry.

![Charts.jpg](https://ipfs.busy.org/ipfs/QmdsHiBNfF8SJDbPbW2NLiEpwG5UaAZn3iZwBUiZfiq5Be)

Learning about Excel when I started working in the Business Process Outsourcing industry helped me a great deal in freeing myself up from manually preparing reports, and I was able to allocate some of the time saved in learning other things that helped me become better at my job. So when Sam asked me to teach her about creating charts, I confidently said yes. 

### Tools Used & Data Sources

</center>

#### Microsoft Excel Version

I've used many versions of Excel, the earliest I can remember was the 2003 version. The one we used in this tutorial is Excel 2016. The basic functions pretty much remained unchanged over the years, but the layout might look a little different.

 #### Screen Recording Application

I am quite new in making tutorials. To create this video I used ***[Open Broadcaster Software](https://obsproject.com/)***. It is an opensource screen recording application with GitHub Repository that can be found ***[here](https://github.com/obsproject/OBS-studio/graphs/contributors)***.

#### Video Editing Application

Since my wife **@dandalion** took an interest in creating video format posts a couple of months ago, I tried to learn basic video editing. I have been using a free video editing application called ***[Hitfilm Express](https://fxhome.com/express)*** since.

**<div class="pull-right"><center><sub><img src="![archive-1850170_1920.jpg](https://cdn.steemitimages.com/DQmSZE1ix1PPk13KteZHYKjLaV7U5AY4jjydQBt9u5CtfqS/archive-1850170_1920.jpg)"/><br/><em><a href="SOURCE HERE">Image Source: Pixabay CC0 Creative Commons</a></em></sub></center></div>**

#### Data Sources

- Pie Chart Data - Is a sample budget patterned after our monthly household expense
- Line Chart Data - Is actual Philippines inflation trend data taken from ***[Philippines Inflation Rate Highest Since October 2011](https://tradingeconomics.com/philippines/inflation-cpi)***.
- Bar Chart Data - Is taken from a press release of Philippine Statistics Authority titled: ***["Farmers, Fishermen and Children consistently posted the highest poverty incidence among basic sectors"](https://psa.gov.ph/poverty-press-releases)***.

<center>![entrepreneur-593371_1920.jpg](https://ipfs.busy.org/ipfs/QmYKXs4RN5TBWhDgsMxQ9nuZxq51uFezQVTUz94yFndHVE)</center><center><sub>**Image Source:** ***[Pixabay CC0 Creative Commons](https://pixabay.com/en/entrepreneur-startup-start-up-man-593371/)***</sub></center>

Sam is in fourth grade of our ***[K-12 Basic Education Curriculum](http://k12philippines.com/)***. Creating charts is one of the most important functions of Excel. As mentioned in the video, I am planning to create more video tutorials in Excel starting with the basics, formulas, and pivot tables. 

![steemitph.png](https://res.cloudinary.com/hpiynhbhq/image/upload/v1516937299/wucsqjto8vxr72ji60rb.png)
<center>![sndbox.gif](https://res.cloudinary.com/hpiynhbhq/image/upload/v1516937289/fiweupxvxvbcfh2q0rzq.gif)</center>

<hr><a href='https://d.tube/#!/v/steemitph/h3irvout'> ▶️ DTube</a><br /><a href='https://ipfs.io/ipfs/QmSQzRmQXkqd3KnEeu3ZPjyCzh4bjVPLBY16kW22L9QYME'> ▶️ IPFS</a>

👍 silvergoldbotty, surpassinggoogle, tombstone, steemitph, cryptopie, abh12345, immarojas, kevinwong, qurator-tier-1-2, dandalion, showtime24, eric-boucher, tangmo, crokkon, bearone, shortcut, paolobeneforti, steemph, arcange, sndbox-alpha, digitaldreamer, jazzybells, enjieneer, eastmael, playitforward, mintvilla, leesongyi, steemph.bulacan, east.autovote, kenan1989, aaronleang, steemgigs, mrblinddraw, jaff8, watersnake101, silviabeneforti, crypto3d, steem-untalented, massivevibration, sireh, carrotcake, steemnest, tpkidkai, reddragonfly, pjmisa, erb, reewritesthings, emrebeyler, howtostartablog, luvabi, paradise-found, fingersik, reginecruz, revisesociology, st3llar, originalmrspice, jeffbernst, raphaelle, littlesteemitph, dandalioncub, world-travel-pro, heymattsokol, adamzi, themanualbot, and 65 others

properties (23)

post_id

56,640,564

author

steemitph

permlink

h3irvout

category

steemph

json_metadata

"{"tags":["steemph","philippines","sndbox","steemiteducation","dtube"],"app":"dtube\/0.7","video":{"info":{"title":"DTube Tutorial - Creating Charts in Excel","snaphash":"QmeK3RS5eGC6vx1Nmj6dmATeccsFRRVn7xAbmATZ4PqHMb","spritehash":"QmXPoahxAmMA4xCAAsDcwvUPhcs7QD7h3KD1thmXkrFZHv","duration":889.5887,"author":"steemitph","permlink":"h3irvout","filesize":999593458},"content":{"description":"Our daughter Sam asked me to teach her how to create charts using Microsoft Excel. I thought about creating a video while doing so for a couple of reasons; 1 to document one of the very rare times I am helping Sam with school work, and 2 to help her classmates whose parents might not be very familiar with Microsoft excel. I am quite pleased that the curriculum for Home Economics and Livelihood Education now includes learning about use of basic computer applications. During my time, Home Economics and Livelihood Education was mostly about gardening, sawing, and carpentry.\n\n![Charts.jpg](https:\/\/ipfs.busy.org\/ipfs\/QmdsHiBNfF8SJDbPbW2NLiEpwG5UaAZn3iZwBUiZfiq5Be)\n\nLearning about Excel when I started working in the Business Process Outsourcing industry helped me a great deal in freeing myself up from manually preparing reports, and I was able to allocate some of the time saved in learning other things that helped me become better at my job. So when Sam asked me to teach her about creating charts, I confidently said yes. \n\n### Tools Used & Data Sources\n\n<\/center>\n\n#### Microsoft Excel Version\n\nI've used many versions of Excel, the earliest I can remember was the 2003 version. The one we used in this tutorial is Excel 2016. The basic functions pretty much remained unchanged over the years, but the layout might look a little different.\n\n #### Screen Recording Application\n\nI am quite new in making tutorials. To create this video I used ***[Open Broadcaster Software](https:\/\/obsproject.com\/)***. It is an opensource screen recording application with GitHub Repository that can be found ***[here](https:\/\/github.com\/obsproject\/OBS-studio\/graphs\/contributors)***.\n\n#### Video Editing Application\n\nSince my wife **@dandalion** took an interest in creating video format posts a couple of months ago, I tried to learn basic video editing. I have been using a free video editing application called ***[Hitfilm Express](https:\/\/fxhome.com\/express)*** since.\n\n**<div class=\"pull-right\"><center><sub><img src=\"![archive-1850170_1920.jpg](https:\/\/cdn.steemitimages.com\/DQmSZE1ix1PPk13KteZHYKjLaV7U5AY4jjydQBt9u5CtfqS\/archive-1850170_1920.jpg)\"\/><br\/><em><a href=\"SOURCE HERE\">Image Source: Pixabay CC0 Creative Commons<\/a><\/em><\/sub><\/center><\/div>**\n\n#### Data Sources\n\n- Pie Chart Data - Is a sample budget patterned after our monthly household expense\n- Line Chart Data - Is actual Philippines inflation trend data taken from ***[Philippines Inflation Rate Highest Since October 2011](https:\/\/tradingeconomics.com\/philippines\/inflation-cpi)***.\n- Bar Chart Data - Is taken from a press release of Philippine Statistics Authority titled: ***[\"Farmers, Fishermen and Children consistently posted the highest poverty incidence among basic sectors\"](https:\/\/psa.gov.ph\/poverty-press-releases)***.\n\n<center>![entrepreneur-593371_1920.jpg](https:\/\/ipfs.busy.org\/ipfs\/QmYKXs4RN5TBWhDgsMxQ9nuZxq51uFezQVTUz94yFndHVE)<\/center><center><sub>**Image Source:** ***[Pixabay CC0 Creative Commons](https:\/\/pixabay.com\/en\/entrepreneur-startup-start-up-man-593371\/)***<\/sub><\/center>\n\nSam is in fourth grade of our ***[K-12 Basic Education Curriculum](http:\/\/k12philippines.com\/)***. Creating charts is one of the most important functions of Excel. As mentioned in the video, I am planning to create more video tutorials in Excel starting with the basics, formulas, and pivot tables. \n\n![steemitph.png](https:\/\/res.cloudinary.com\/hpiynhbhq\/image\/upload\/v1516937299\/wucsqjto8vxr72ji60rb.png)\n<center>![sndbox.gif](https:\/\/res.cloudinary.com\/hpiynhbhq\/image\/upload\/v1516937289\/fiweupxvxvbcfh2q0rzq.gif)<\/center>","video240hash":"QmZ9Mr9XfAJGDHzSJgANgVV4HRHfu9wP3JwXX6fJvkSjP1","tags":["steemph","philippines","sndbox","steemiteducation"],"videohash":"QmSQzRmQXkqd3KnEeu3ZPjyCzh4bjVPLBY16kW22L9QYME","video480hash":"QmUGTSdf2nyzX6b5AfcR3QuMLLRnu9Z2M82xd3AsMegAuy"}}}"

created

2018-07-15 17:58:21

last_update

2018-07-15 17:58:21

depth

children

net_rshares

2,042,549,718,952

last_payout

2018-07-22 17:58:21

cashout_time

1969-12-31 23:59:59

total_payout_value

2.755 SBD

curator_payout_value

0.703 SBD

pending_payout_value

0.000 SBD

promoted

0.000 SBD

body_length

3,918

author_reputation

26,777,977,837,039

root_title

"DTube Tutorial - Creating Charts in Excel"

beneficiaries

0.

`weight`	2,500
`account`	dtube

max_accepted_payout

1,000,000.000 SBD

percent_steem_dollars

10,000

author_curate_reward

vote details (129)

voter	rshares	pct
tombstone	110,957,387,223	0.06%
lola-carola	171,890,794	0.6%
kevinwong	38,562,802,419	0.15%
eric-boucher	32,627,510,302	10%
arcange	13,611,061,258	2%
raphaelle	960,827,341	2%
shortcut	22,349,606,324	10%
themanualbot	859,662,072	1%
immarojas	41,010,619,803	25%
abh12345	62,140,943,498	15%
anomaly	238,677,087	1%
surpassinggoogle	442,662,261,550	2%
tangmo	32,093,179,802	100%
heymattsokol	928,655,659	6%
paolobeneforti	20,231,665,501	6%
silviabeneforti	2,412,778,535	4%
paradise-found	1,318,667,351	1%
southparkqueen	716,809,899	10%
fingersik	1,308,392,083	2%
erb	1,385,981,259	4%
moksamol	423,039,805	1%
steemgigs	2,716,767,064	10%
teachblogger	676,002,299	5%
kenan1989	4,096,571,358	20%
eurogee	288,737,576	2%
dbzfan4awhile	321,485,558	3%
luvabi	1,327,260,186	5%
world-travel-pro	951,793,431	0.2%
bitrocker2020	769,399,020	1%
leesongyi	4,674,407,174	2%
kemal13	718,796,573	30%
bearone	23,633,248,410	50%
reddragonfly	1,593,570,499	4%
howtostartablog	1,342,467,183	3%
faluthi01	141,471,632	10%
affiedalfayed	243,421,026	2%
carrotcake	2,045,824,491	2%
st3llar	1,061,162,502	5%
coloringiship	766,636,101	2%
cryptopie	82,026,165,817	33%
sunnylife	427,647,142	0.2%
dwightjaden	188,516,285	2%
watersnake101	2,533,043,110	50%
mintvilla	5,001,449,221	12%
martibis	125,594,136	3%
steemitph	85,433,702,286	100%
dandalion	35,905,573,884	100%
aaronleang	3,394,037,168	10%
jazzybells	10,189,988,952	10%
bleyker	88,271,957	20%
steem-untalented	2,282,964,769	10%
pjmisa	1,473,797,505	70%
steemph	17,501,533,823	40%
massivevibration	2,202,396,866	5%
crokkon	25,849,155,492	50%
steemitdoctor	624,496,924	100%
markjason	632,127,470	20%
anna-mi	781,465,099	10%
princekelly	131,704,955	10%
eastmael	7,686,883,349	50%
revisesociology	1,152,143,463	1%
playitforward	5,368,086,877	6%
filipino	355,460,364	10%
silvergoldbotty	732,201,756,562	13.9%
penauthor	65,934,283	1%
mrblinddraw	2,667,826,731	18%
animagic	237,996,731	20%
enjieneer	8,543,789,488	30%
showtime24	35,501,010,482	100%
zulfan88	64,562,164	10%
jaff8	2,588,095,733	4%
emrebeyler	1,342,849,392	0.1%
twotripleow	164,755,755	5%
spectrums	191,274,200	20%
nairadaddy	400,883,518	1%
jeffbernst	964,782,838	4%
sireh	2,182,665,678	5%
tpkidkai	1,649,072,393	100%
littlesteemitph	959,513,084	100%
dandalioncub	957,836,937	100%
awolesigideon	198,168,300	10%
paulthebeloved	720,437,630	50%
asyrafahamed	255,221,766	6%
paragon99	94,600,749	10%
beautifuldata	61,289,297	30%
steemnest	1,758,353,844	100%
crypto3d	2,322,532,872	10%
admiralsp	507,407,909	20%
blogger-funda	88,719,232	20%
adamzi	924,986,772	3%
magpielover	129,699,957	100%
gilnambatac	742,668,384	100%
sndbox-alpha	12,679,950,001	20%
frankremmy	65,615,517	3%
gratefulvibes	163,690,794	2%
east.autovote	4,494,436,057	100%
kaeo	122,321,600	20%
rinbird	122,021,426	20%
steemfix	587,227,971	100%
steemrent	613,389,843	100%
iamthenerd	200,341,154	1%
antigenx	440,850,594	1%
medical-hall	99,463,868	20%
reginecruz	1,158,644,129	100%
sissyjill	106,229,280	7%
originalmrspice	981,185,032	1%
morbyjohn	176,136,158	7%
reewritesthings	1,362,613,991	100%
carloniere	81,658,435	20%
hackerzizon	102,248,456	1%
casperleow	163,366,285	16%
theagriculturist	61,091,140	10%
katrina71	88,596,023	16%
blockmountain	92,907,700	10%
ahna8911	60,911,047	10%
apteacher	442,176,175	4%
gunter01	497,538,209	50%
mannylumanao	105,867,533	10%
digitaldreamer	10,684,227,969	100%
zam398	228,760,242	10%
steemph.bulacan	4,498,617,858	100%
bullish27	75,941,784	10%
dotman-art	88,118,220	10%
carpet.duck	80,667,306	10%
karinquintero	88,596,941	16%
qurator-tier-1-2	36,950,730,629	3.5%
odankiara12	60,891,116	10%
ogsenti	61,207,387	100%
chaer	475,139,839	100%

`post_id`	56,864,669
`author`	steemitboard
`permlink`	steemitboard-notify-steemitph-20180717t202907000z
`category`	steemph
`json_metadata`	{"image":["https:\/\/steemitboard.com\/img\/notify.png"]}
`created`	2018-07-17 20:29:06
`last_update`	2018-07-17 20:29:06
`depth`	1
`children`	0
`net_rshares`	0
`last_payout`	2018-07-24 20:29:06
`cashout_time`	1969-12-31 23:59:59
`total_payout_value`	0.000 SBD
`curator_payout_value`	0.000 SBD
`pending_payout_value`	0.000 SBD
`promoted`	0.000 SBD
`body_length`	719
`author_reputation`	38,705,954,145,809
`root_title`	"DTube Tutorial - Creating Charts in Excel"
`beneficiaries`	`[]`
`max_accepted_payout`	1,000,000.000 SBD
`percent_steem_dollars`	10,000

`post_id`	57,052,210
`author`	cryptopie
`permlink`	re-steemitph-h3irvout-20180719t131606596z
`category`	steemph
`json_metadata`	{"tags":["steemph"],"app":"steemit\/0.1"}
`created`	2018-07-19 13:16:09
`last_update`	2018-07-19 13:16:09
`depth`	1
`children`	0
`net_rshares`	0
`last_payout`	2018-07-26 13:16:09
`cashout_time`	1969-12-31 23:59:59
`total_payout_value`	0.000 SBD
`curator_payout_value`	0.000 SBD
`pending_payout_value`	0.000 SBD
`promoted`	0.000 SBD
`body_length`	96
`author_reputation`	1,655,346,400,850,630
`root_title`	"DTube Tutorial - Creating Charts in Excel"
`beneficiaries`	`[]`
`max_accepted_payout`	1,000,000.000 SBD
`percent_steem_dollars`	10,000

`post_id`	57,142,476
`author`	tangmo
`permlink`	re-steemitph-h3irvout-20180720t090307140z
`category`	steemph
`json_metadata`	{"app":"steemit\/0.1","tags":["steemph"]}
`created`	2018-07-20 09:03:09
`last_update`	2018-07-20 09:03:09
`depth`	1
`children`	0
`net_rshares`	0
`last_payout`	2018-07-27 09:03:09
`cashout_time`	1969-12-31 23:59:59
`total_payout_value`	0.000 SBD
`curator_payout_value`	0.000 SBD
`pending_payout_value`	0.000 SBD
`promoted`	0.000 SBD
`body_length`	277
`author_reputation`	143,072,298,919,375
`root_title`	"DTube Tutorial - Creating Charts in Excel"
`beneficiaries`	`[]`
`max_accepted_payout`	1,000,000.000 SBD
`percent_steem_dollars`	10,000