Wednesday, January 29, 2020

Excel_Pivot Tables

To improve my skills, I would like to write what I've learned about Pivot Table

  1. We can add column to calculate what we want =  Pivot Table Tools - Analyze - Field, Items & Sets
  2. We can change the font, create charts from pivot table
  3. Slicers are visualizing what we have selected
  4. Explore the 4th quadrant of pivot table. Boleh buat macam-macam sebenarnya
  5. Use doughnut chart to visualize utilization of budget
  6. Achievement is 1+% progress. Variance is the % progress


No comments:

Post a Comment