簡單易用的Pivot Table (樞紐分析表)-助您從數據中提取重要資訊-內含Pivot Table中文教學和Pivot Table用法

數據集
選取Pivot Table
對話框
Pivot Table欄位窗格
Pivot Table
從大到小排序
結果
篩選下拉菜單
3月份的Amount
值欄位設定
項目個數
結果
請將以下欄位拖到不同的區域
二維(2D) Pivot Table

--

--

Excel問題,你問我答!

Love podcasts or audiobooks? Learn on the go with our new app.

Get the Medium app

A button that says 'Download on the App Store', and if clicked it will lead you to the iOS App store
A button that says 'Get it on, Google Play', and if clicked it will lead you to the Google Play store