Tuesday, May 26, 2015

好料分享 - EXCEL FUNCTIONS FOR FINANCE PROFESSIONALS


EXCEL这字眼对大家已不再是陌生词,几乎会用电脑的人都对这词很熟悉。它是Microsoft里其中一个产品。在职的上班族都会用它,可以把数据整理和变成简单化,靠的就是里面的Function Formula。各行各业都很需要它,而且你能够掌握它的功能和奥秘,许多老板都需要你这样的人才(说到这样神,不学都不可啦!)。J就不加以解释,在次就简单与大家分享Excel Functions。




在Excel里,你是否常常看到一些很类似复杂又简单的Formula呢?
只要你懂基本数学,你就能够了解如何运用Excel里面的Function formula。

自己很爱数学这科目,对数字产生一定的好感,也很想去学怎样用Excel,甚至想过报读Excel这课。后来,J选择自修,上YouTube或论坛学习Excel的功能。

J拥有这副本也要很感激当时教Investment Analysis的教授。他给了很多往后能在金融界派上用场的好料。Excel Function dictionary 这副本是其中之一,还有也包含一些跟金融有关的电子书, E-Books。当时的J,不把这些好料当宝看待,只想考个PASS,能过这个module,可以毕业就行,也没有多余时间学别的(半工半读人的想法)。

虽说自己不至于Expert那类,但对这Excel的运用还是可以“骗”得了以前的同事吧!你能够掌握Excel里一些功能,对你往后真的有所帮助。现在J会时常参考它的Formula是因为自己用Excel做了买卖股票的记录。

好了说了这么多接下来,看目录:

Excel Function Dictionary
Credit © to Peter Noneley hard works
ExcelFunctionDictionary百科全书的简介

重点在此 FunctionList
用了这字典,让J学会如何用Vlookup, Text, Date还有其它简单的Functions。如果读者真的有兴趣想要拥有它,可以留下你们的脚印或留言在Contact Me。


点击此获得 可下载版本





   - J丰-
26/05/2015


** Update on 28/6/2015: I had decided to put up the link here so that you all can download yourself without sending me email.

** Please note that there is third party advertisements and it's safe to click " skip ads" to download a copy.









12 comments:

  1. I want it...
    garylee_619@hotmail.com
    dorara

    ReplyDelete
    Replies
    1. Hi Dorara,
      Thanks for supporting my blog. I already sent you email. Check your inbox.

      Delete
  2. Hi, I would like to have it as well.
    Thanks for sharing.
    kyo12331@hotmail.com

    Leo

    ReplyDelete
    Replies
    1. Hi Leo, Thanks for your supports. PM sent, pls check your inbox.

      Delete
  3. Hi,Can send it to me, thanks. sengchai84@yahoo.com

    ReplyDelete
    Replies
    1. Hi Seng Chai, Thanks for supporting my blog :) . PM sent, please check your inbox.

      Delete
  4. To All the visitors/readers,

    If you find it interested and need a copy for your reference.

    I would like to encourage you all drop me a message through CONTACT ME form in order to secure your email privacy and avoid publicly.

    Thanks.

    ReplyDelete
  5. Hi, I would like to have a copy.
    Thanks for your sharing.
    elventth@gmail.com

    ReplyDelete
    Replies
    1. Hi, PM sent. Please check your inbox.

      Delete
    2. 可lz可以发给我吗 我也想学习用excel来计算组合 dinobii3@gmail.com0谢谢

      Delete
  6. pm me dinobii3@gmail.com
    我也想学习怎么用 新手一枚

    ReplyDelete

Welcome your comments !

欢迎你们的留言!

Related Posts Plugin for WordPress, Blogger...