OnMyGrad Logo

做fmcg/marketing既人一定要識既excel skills

#FMCG
#excel
#computer
NoJob
06-Jan-2020
last edit: 11 Jul

做fmcg/marketing既人有咩一定要識既excel skills?🙇🏼‍♀️

1416 view
2 answers
#1
Colin@OnMyGrad
last edit: 06-Jan-2020
++++++

好問題,Excel+skill其實識少少,喺職場真係方便好多。加減乘除基本就唔駛講啦,fmcg/marketing好多時都deal+with+product+sales同campaign+effectiveness,所以不時都會用到sumif+/+countif系列,注意countif+vs+countifs係有少少唔同。更加常用嘅會有vlookup,用嚟對返啲數。至於點樣用,通常我以往都好簡單Google打"How+to+use+xxx+in+Excel"都會搵到Microsoft+support有教,如果都係睇唔明,上YouTube+search同一句跟住做就通常冇死。

Source:+Microsoft+Support

再進階少少,可以學埋用Pivot+table,都可以幫慳到好多時間。Btw以前deal+with一啲social+media+(FB)+data時,喺FB+gen出嚟嘅data嘅時間一般都係GMT+0,所以仲要識將時間加返8個鐘先至準,不過點樣寫條formula,就留返俾你做功課啦😉

Last+but+not+least,Excel仲有一樣好方便嘅嘢就係同Outlook合作做mail+merge,通常會用喺EDM,或者beauty+product有個unique+code俾人redeem+sample都好常見,至於exactly點用,都係問Google大神啦,不過每次send前,都要記住做幾次testing同proof+read先。以前我同supervisor比較fd😂😂send呢啲通常會煩佢叫佢睇幾次,再捉住手仔先一齊send..

Source:+Google

++++
#2
Anthony@OnMyGrad
last edit: 07-Jan-2020

剛剛都收到一位FMCG+MT嘅reply,佢大大力推薦大家要學識vlookup同pivot+table。(由於呢啲都係一啲最basic嘅excel+function,所以輕輕一講就算嗱,唔識嘅話俾啲圖同link你哋慢慢睇啦)+Pivot+table+(中文名好kai,樞紐分析表)喺FMCG都真係好常用,因為佢哋真係會gather咗好多嘅data+(no+matter+from+retail+outlets+or+marketing+team),腦細問起一啲specific嘅data就真係自己整定個pivot+table分定類就fit啦。Official+usage+of+pivot+table:+「樞紐分析表是一項強大的工具,可用來計算、建立摘要和分析資料,讓您比較資料和查看資料中的模式與趨勢。」Right...強大的工具...by+Mic記。+Setting+up+a+Pivot+Table+Step+by+Step: 

Source:+經濟日報+(台灣)

整多條片你嘆下:

https://support.office.com/zh-tw/article/%25E5%25BB%25BA%25E7%25AB%258B%25E6%25A8%259E%25E7%25B4%2590%25E5%2588%2586%25E6%259E%2590%25E8%25A1%25A8%25E4%25BE%2586%25E5%2588%2586%25E6%259E%2590%25E5%25B7%25A5%25E4%25BD%259C%25E8%25A1%25A8%25E7%259A%2584%25E8%25B3%2587%25E6%2596%2599-a9a84538-bfe9-40a9-a8e9-f99134456576





++++