Excel Tips: 5 Tricks 小秘訣, 助你提升工作效率 👍

[@kathyleung6741]

Thank you!! Kk sir!! 我喺最近interview就係要喺一大堆data揾資料，然後要將啲資料copy & paste..我覺得你教到用freeze panes嚟凍結頭一行header真係好有用，令我可以更加容易用到ctrl+F嚟揾資料，而且你教到用ctrl +e嚟做flash fill亦都令我學到嘢，對我下一次見工都有幫助呀!! 👍👍👍

[@KKLeung]

Hi Kathy 多謝你嘅好評，協助轉介給有需要嘅朋友，就是對本平台嘅義工們最大支持。👍

[@ritatsang2697]

My situation is almost similar to yours. Due to my lacking of knowledge on PivotTable & V-Lookup, I missed a lot of good employment opportunities. Sigh! I am hopeful through the lectures provided by Mr KK, I would be able to get thru those obstacles. Again, many thanks to Mr KK for your excellent lectures thru videos which enable me to learn new Excel skills as well as to review some of the Excel features which were neglected by me for a very long time…

[@SzeYongLim]

我來自馬來西亞。真的很喜歡看你的影片❤。學到很多。不是很會粵語句子，所以只好寫華語，希望你能看到明白。 有2個問題請教關於highlight targeted cells： 1）如何把相關 absent &

[@KKLeung]

Hi Sze Yong 多謝你嘅收看 1 可以參考下面嘅影片, 裏面有示範如何highlight entire row 2 Google sheet 較少用,所以未能提出建議 kzbin.info/www/bejne/bpTJhnR3m799f7csi=YmcmK_U3S9shveXH

[@yvonne3438]

​@@KKLeungThank you!

[@hanapalace]

真的非常詳細及有用的教學, 謝謝分享。

[@KKLeung]

多謝你嘅好評，協助轉介給有需要嘅朋友，就是對本平台嘅義工們最大支持。👍

[@KSL12070]

好有用。看了你們的好多片。謝謝。

[@KKLeung]

Hi KS 多謝你嘅好評，協助轉發俾有需要嘅朋友，就係對本平台嘅義工最大嘅支持🙏😀

[@paulyeung5628]

謝謝k.k.sir ❤❤👍👍🙏🙏

[@KKLeung]

Hi Paul, 多謝你嘅收看。😀

[@kennyfok6872]

Very good, thank you.👍

[@KKLeung]

Hi Kenny 多謝你嘅好評，協助轉介給有需要嘅朋友，就是對本平台嘅義工們最大支持。👍

[@chiwaileong-rr5fn]

可惜沒有檔案提供做練習

[@KKLeung]

多謝收看，有關示範文檔要查看是否仍在，遲啲再回覆你。

[@KKLeung]

示範文檔現已提供下載 1drv.ms/x/s!AmTiTp3HvInWg_xrJrfeWaByx3hUGg?e=HLOtqb