10 The Basic Formula Of Excel And Its Functions by khalidharun

busy · @khalidharun · Jan 24 '18

$0.71

10 The Basic Formula Of Excel And Its Functions

my post tonight i just give 5 basic formula in excel for easy for friend to learn step by step first.
1.  Filter
    As the name suggests this filter is useful for filtering data that has been visited by us Categorizing can also group the data as you see fit.
http://blog.contextures.com/wp-content/uploads/2011/03/subtotal09.png
2. Conditional Formatting 
Conditional Formatting in Excel is to give the color according to what we want based on the value of the cell we choose, conditional formatting used for presenting the data we want.
http://content.invisioncic.com/r273034/monthly_2017_02/Conditional-Formatting.png.867304f3bb3dc75a2588f02f4de1353d.png
3. Format Painter 
Format Painter is the equation of the format and cell or table without mennyalin contents.
https://support.content.office.net/en-us/media/9b9e503e-de2f-4eb6-8e1f-6d9bee36e36b.png
4. Validation of Data in Excel
Validation of Data in Excel has function intuk enable you to input data, validation of data useful to prevent invalid or unwanted data into cell.apabila wrong you enter data eat you will be warned that your data wrong.
http://www.contextures.com/images/datavalidation/createdropdown07.png
5. IFS function
 IFS function is to check whether there is one or several conditions that are met, which then produces a value that is true. IFS can also be replaced with some ifs that have been stacked with some conditions.

👍 busy.org, minnowsupport, iklima, rian46, aziz95, khalidharun, nadila, kimberlymason

`author`	khalidharun
`permlink`	6vse2s-10-the-basic-formula-of-excel-and-its-functions
`category`	busy
`json_metadata`	{"community":"busy","app":"busy/2.3.0","format":"markdown","links":["http://blog.contextures.com/wp-content/uploads/2011/03/subtotal09.png","http://content.invisioncic.com/r273034/monthly_2017_02/Conditional-Formatting.png.867304f3bb3dc75a2588f02f4de1353d.png","https://support.content.office.net/en-us/media/9b9e503e-de2f-4eb6-8e1f-6d9bee36e36b.png","http://www.contextures.com/images/datavalidation/createdropdown07.png"],"tags":["busy","steemit","excel"]}
`created`	2018-01-24 16:59:18
`last_update`	2018-01-24 16:59:18
`depth`	0
`children`	1
`last_payout`	2018-01-31 16:59:18
`cashout_time`	1969-12-31 23:59:59
`total_payout_value`	0.562 HBD
`curator_payout_value`	0.144 HBD
`pending_payout_value`	0.000 HBD
`promoted`	0.000 HBD
`body_length`	1,401
`author_reputation`	263,629,267,286
`root_title`	"10 The Basic Formula Of Excel And Its Functions"
`beneficiaries`	`[]`
`max_accepted_payout`	1,000,000.000 HBD
`percent_hbd`	10,000
`post_id`	31,971,541
`net_rshares`	69,227,924,105
`author_curate_reward`	""

properties (23)vote details (8)

voter	rshares	pct
busy.org	45,825,523,376	0.05%
minnowsupport	18,880,435,946	1%
iklima	1,731,101,883	100%
nadila	559,023,102	100%
khalidharun	582,257,570	100%
rian46	617,253,440	100%
kimberlymason	433,222,500	100%
aziz95	599,106,288	100%