+ Reply to Thread
Results 1 to 2 of 2

Pivot Report Best Practices?

  1. #1
    Registered User
    Join Date
    05-16-2019
    Location
    Reno, Nevada
    MS-Off Ver
    2019
    Posts
    1

    Pivot Report Best Practices?

    I start a new job as an entry level data analyst next week and I'm trying to brush up on my Excel Skills. I know that I will be asked to create a Pivot Report Table and I was wondering how you would format it to make it presentable to people.

    I'm looking for some learning material or suggestions - What are some best practices that are good to follow?
    Thanks in advance everyone!

  2. #2
    Forum Expert
    Join Date
    08-12-2012
    Location
    Sydney, Australia
    MS-Off Ver
    Excel 2010
    Posts
    5,636

    Re: Pivot Report Best Practices?

    Good luck with your new job

    with pivot tables, often you need to input Data into the data source in to get the exact result you expect
    ie the data you get may not be enough to generate the pivot table....use formulas in data source (rather than calculated fields)

    i'm a sucker for classic layout, just find it reads and acts the way it should
    Pivot slicers are nice, try not to overuse though
    If you are satisfied with the solution(s) provided, please mark your thread as Solved.
    Select Thread Tools-> Mark thread as Solved. To undo, select Thread Tools-> Mark thread as Unsolved.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Replies: 0
    Last Post: 07-14-2016, 03:51 PM
  2. Pivot Report doesn't show current records but they are in pivot table
    By dixiecricket in forum Excel Charting & Pivots
    Replies: 8
    Last Post: 06-16-2015, 11:25 AM
  3. Multiple Pivot report filter - based on another pivot on another worksheet
    By Jabba69 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 11-24-2014, 05:45 AM
  4. Best practices for multiple Add-Ins?
    By AdamBecker in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 05-08-2013, 11:55 AM
  5. Replies: 0
    Last Post: 12-10-2012, 12:52 PM
  6. Replies: 0
    Last Post: 11-18-2011, 07:31 AM
  7. [SOLVED] best practices question
    By Gary Keramidas in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 03-22-2006, 06:15 AM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1