Home
Buku
Trik Dahsyat Formula & Fungsi Excel 2010

Trik Dahsyat Formula & Fungsi Excel 2010

RRP:

~~Rp. 62.800~~

Your Price:

Rp. 53.400 (You save Rp. 9.400)

Brand:

Elex Media Komputindo

Weight:

340 Grams

Rating:

( 5 product reviews )

Shipping:

Calculated at checkout

Product Description

Trik Dahsyat Formula & Fungsi Excel 2010

Oleh Yudhy Wicaksono

SINOPSIS

Excel 2010 merupakan versi terbaru Microsoft Excel yang dikeluarkan saat ini. Salah satu kunci untuk menguasai Excel 2010 secara optimal adalah dengan menggali kedahsyatan yang dimiliki formula dan fungsi. Formula dan fungsi Excel sering kali digunakan sebatas hanya untuk menyelesaikan berbagai macam proses perhitungan, dari yang sederhana sampai yang rumit.

Selain untuk menyelesaikan perhitungan, formula dan fungsi Excel sebenarnya mempunyai ratusan kemampuan dahsyat lainnya. Namun karena belum terpetakan dengan jelas, kemampuan tersebut seperti menjadi misteri yang tidak pernah terungkap.

Buku Trik Dahsyat Formula dan Fungsi Excel 2010 membahas lebih dari 175 contoh trik dahsyat penggunaan formula dan fungsi Excel 2010 untuk menyelesaikan pekerjaan sehari-hari. Trik yang dibahas sebagian besar merupakan kombinasi antarfungsi Excel atau kombinasi fungsi Excel dengan fitur Excel yang lain sehingga diperoleh hasil yang luar biasa.

Buku ini sangat cocok digunakan sebagai media latihan dan referensi untuk meningkatkan kemampuan Anda dalam menggunakan formula dan fungsi Excel 2010. Meskipun disusun menggunakan Excel 2010, buku ini juga dapat dimanfaatkan pengguna Excel 2007. Untuk memudahkan pemahaman pembaca, penulis menyertakan CD bonus berisi file latihan dan file kunci jawaban setiap trik yang dibahas.

DETAIL

Judul	Trik Dahsyat Formula & Fungsi Excel 2010
Seri	Microsoft Excel
ISBN / EAN	9789792792515 / 9789792792515
Author	Yudhy Wicaksono
Publisher	ELEX MEDIA
Publish	19 Januari 2011
Pages	324
Weight	340 gram
Dimension (mm)	140 x 210

Find Similar Products by Category

Buku

Product Reviews

curtrbGMYbmu

Posted by hreczw on 6th Apr 2012

sOdNRC , [url=http://pijfghnafqpb.com/]pijfghnafqpb[/url], [link=http://pqdzwaelruvl.com/]pqdzwaelruvl[/link], http://enzbhesrldpv.com/
MNHNjoxj

Posted by iiopceh on 4th Apr 2012

HfRyij <a href="http://aeiftcykulvg.com/">aeiftcykulvg</a>
YQhaxmQyuFU

Posted by yokfabjfi on 3rd Apr 2012

FUJvby , [url=http://iepijocvnmgq.com/]iepijocvnmgq[/url], [link=http://ppgaqwtqsnpx.com/]ppgaqwtqsnpx[/link], http://gubghgggcsbf.com/
MvyeaYyonj

Posted by iyqpwayigi on 2nd Apr 2012

pefQBo <a href="http://elsjpemavomw.com/">elsjpemavomw</a>
Mussawir

Posted by Mussawir on 1st Apr 2012

Hi Andy, me againThere are a few issues that have riesan. Are you still willing to help me with them, or have I exceeded my quota of requests?I am forwarding to you the most current copy of the worksheet. I worked all weekend long trying to resolve a couple of them, but i could not. One i think the only resolution is to enter the data manually. But I'll put the question to you just in case you know a way it can be done.It is: L3 which is Total Days. The formula we are using is giving us an incorrect answer. Not to mention, i was looking for the answer to the wrong question besides. Total Days is supposed to tell us what number Trading Day of the Trade (Calendar) year the current day is. There are approximately 250 trading days in the year. Since January 1st, what trading day is the current day (today). The formula =Sum(u5:u3218) we currently have in L3 adds up the totals from the column No of days in a trade . It is an attempt to answer the wrong question, and it answers the wrong question incorrectly. My bad!Can you figure out how to come to a correct answer of what formula to use to get the result I am looking for? Or should we just resolve to entering it manually each day?The OTHER issue I worked on the most this weekend. The thing is, i think i'm using the correct formula. I searched and searched the internet and everything seemed to keep saying the same thing. Use the formula i currently have. But it is bringing back an incorrect answer. It is Cell G3, # of Winners. I counted manually and the answer should be 82, but it keeps saying 217. The formula entered is =COUNTIF(T5:T2318, >=0 ) which should be adding only the positive %s in the column. But it's pulling more than just the positives from somewhere and i cannot figure out why, or how to resolve it? I believe Winning %age to be incorrect also, but should correct itself when # of Winners is corrected.Can you please help me with these two issues?Thanks for your consideration and all you've done so far!!