thank you KK teach us a lots. May I ask a question? I wonder why the Date in my pivot table that I created every time has no month as you did. I have Years, Quarters & dates.
Hi Steven, 1. Make sure that your date column in the source data is recognized as a date type. If the dates are stored as text, Excel might not be able to group them correctly. 2. The date column in your source data, you may change the format from 25/07/2024 to 25 Jul 2024 by custom format. 3. If point 2 does not work, the date column is text that causes the problem you encountered.
![Tee Grizzley - Blow for Blow (feat. J. Cole) [Official Video]](http://i.ytimg.com/vi/wNLN5xsx5dc/mqdefault.jpg)
謝謝您的用心教學❤
Hi Aj
多謝你嘅好評，協助轉發俾有需要嘅朋友，就係對本平台嘅義工最大嘅支持🙏😀
Thank you. Very clear and helpful.
Yes:)
Hi 閃臣
多謝你嘅好評。
協助轉介給有需要嘅朋友，就是對本平台嘅義工們最大支持。👍
KK Sir, 你的教學影片認真製作，深入淺出又實用，對我工作非常有幫助，在眾多講解Excel的RUclipsr中，本人覺得你是最好的，thks!
Hi Alice
多謝你嘅好評，協助轉介給有需要嘅朋友，就是對本平台嘅義工們最大支持。👍
@@KKLeung sure ~👌
1. Use Excel Table 0:17
2. Field Sorting and Moving 7:43
3. Types of Layout 10:27
4. Field Expand/ Collapse 13:53
5. Date Feature 16:46
Thanks
好實用! 我成日要用pivot table 希望有多D教學 謝謝
多謝你嘅好評。
協助轉介給有需要嘅朋友，就是對本平台嘅義工們最大支持。👍
thank you KK teach us a lots. May I ask a question? I wonder why the Date in my pivot table that I created every time has no month as you did. I have Years, Quarters & dates.
Hi Steven,
1. Make sure that your date column in the source data is recognized as a date type. If the dates are stored as text, Excel might not be able to group them correctly.
2. The date column in your source data, you may change the format from 25/07/2024 to 25 Jul 2024 by custom format.
3. If point 2 does not work, the date column is text that causes the problem you encountered.
KK Sir, 這個video 好有用。而layout 就是一直想你解答問題，而lock column 已忘記在邊個位找出來。謝謝你的指教。
多謝你嘅好評。
協助轉介給有需要嘅朋友，就是對本平台嘅義工們最大支持。👍
I have made a small pivot table with your help..... thanks. Is it possible we can download some data from you for practice?
The portion under the RUclips, there is a link for downloading the demo file.
@@KKLeung great for us
請問會有excel 練習檔 可下載嗎 謝謝
多謝收看，因外出旅遊，8/April 後才可回覆提問。謝謝 KK
已提供下載示範文檔.
🙏🙏🙏❤❤
Hi Paul,
多謝收看。
請問怎樣set自動生成年，月，季？謝謝
只要你將日期(date) 擺放在Pivot table Row 位置, 年度,季度, 月份 是會自動產生出嚟, 只要按影片操作就可以.
KK
好有用。多謝！
Hi Elaine
多謝你嘅好評，協助轉介給有需要嘅朋友，就是對本平台嘅義工們最大支持。👍