// 你唔可以唔識嘅6個超實用 #Excel 功能🔖 | 幫你secure return offer同double productivity //睇落好簡單，但係以下要介紹嘅excel function喺10個BBA學生入面得2個真正master到！想輕鬆secure return offer同double productivity，就記住要Save低依個post🔖，好好學識SUM、COUNT、AVERAGE、SUMIF、COUNTIF、AVERAGEIF啦！1️⃣ SUM係最基本同常用嘅formula，可以輕鬆幫你計所有data嘅總和。⭐ =SUM (D3:D9 ▶️ 你要計總和嘅data範圍)2️⃣ SUMIF就係SUM嘅進階版，可以幫你喺選擇嘅data範圍中，根據指定嘅條件作出filter，然後再搵出總和。⭐️ =SUMIF(D2:D16 ▶️ 條件範圍 ,”上衣” ▶️ 條件嘅actual date ,F2:F16 ▶️ 你要計總和嘅數字範圍)3️⃣ COUNT就顧名思義，幫你統計總共有幾多data。要記得嘅係中間冇任何calculation㗎，只係陳述俾你知有幾多valid嘅data存在，而valid對COUNT依個function嚟講就只係數字型嘅數據，所有文字同空白都係唔計㗎！⭐ =COUNT (D3:D9 ▶️ 你要查詢嘅data範圍)4️⃣ COUNTIF亦係COUNT嘅進階版，會根據你set嘅條件幫你去統計有幾多個data存在，同樣都係唔存在calculation㗎⭐️ =COUNTIF(B2:J10 ▶️ data嘅範圍 ,"TURE" ▶️ 你嘅search criteria)記住COUNTIF嘅search criteria係要完全符合㗎，佢唔會幫你搵到有部分符合嘅data。除咗specifically搵某個文字之外，仲可以搵數字，就唔需要加” “ ▶️ =COUNTIF(B2:J10,10)；又或者可以搵空白嘅儲存格 ▶️ =COUNTIF(B2:J10,"")5️⃣ AVERAGE就係平均值啦，都係一啲最普通嘅excel function！⭐ =AVERAGE (D3:D9 ▶️ 你要計平均值嘅data範圍)6️⃣ AVERAGEIF同以上兩個”IF”一樣，就係AVERAGEIF嘅進階版，可以filter出符合criteria嘅data先再計平均值⭐️ =AVERAGEIF(A1:A6 ▶️ data範圍 ,"=0" ▶️ criteria)除咗=之外，大家仲可以用>=同<=去擴criteria㗎！👍🏻雖然睇落依啲formula好似好簡單，但當你要處理大量嘅data嘅時候，好多同學仔都會唔記得咗可以用IF嘅formula幫手快速搵到啲相關嘅data。有做consulting嘅同學仔同Career Hackers分享過，佢開會前做好晒所有data analysis同slides，點知開會嗰陣client突然問佢一條好簡單嘅問題：到底有幾多customer喺research入面有提及”save”依個字？因為佢本身冇prep到，所以開頭都嚇咗一嚇，後來佢活用COUNTIF就好快搵到個答案，事後仲俾senior讚醒目添！想更加深入了解management consulting淨係學excel係唔夠㗎，你要擁有一個Management Consultant應該要有嘅知識同特質，更加好嘅就要有relevant experience呀，咁你就要join我哋嘅self-paced A Day of Management Consultant virtual experience啦！😇你可以選擇喺anytime、anywhere完成依個experience，⚡短短3個鐘你會化身成為一個professional management consultant，幫一個retail brand去restructure同implement a new merchandising process。📝過程中你會接觸到process mapping、case analysis、client communication and management，訓練你嘅problem-solving skills🧠。Top performers仲會有Elyx Consulting Founder & CEO Mr. Chris Lam俾feedback你㗎！🥳想拎多啲經驗，快人一步加入consulting industry，有興趣嘅同學仔不論major同year都快啲去Bio條link報名啦！#hongkongcareer #careerplanning #careertips #香港 #搵工 #職場 #internship #gradjob #mt #graduateprogram #excel #excel技巧