Login & Start Learning!

or

VIDEO PLAYLIST

Testimonials

Patricia Henry

“During my last semester of college, I only knew a little bit of Excel and was in the job hunt for my post grad life. I purchased the student packet from Excel Tutor and learned may more than I ever thought possible about Excel. I am so excited to put all my new Excel knowledge on my resume.”

Patricia H.
David Phillips

“ I’ve been working in the insurance industry for a few years now and have been trying to get my fellow colleagues to understand Excel and perform at a more efficient rate. I found this site and after completing the courses myself, I now have my entire department completing these courses! ”

David P.
Phil Banks

“My boss told me that I needed to find a way to be “more efficient and effective” for my daily tasks. That’s when I went hunting for an online Excel course. Excel Tutor was the answer! I learned so many tricks and I even received a promotion in my job last week due to what I learned from this website.”

Phil B.

Pivot Tables: Pivot Table – Filters

  • Description
  • Discussion
When analyzing large amounts of data, we often want to only view a certain segment. Pivot tables allow us to filter our data so we can look at relationships in a subset of data. For example, if we have national data, we might want to look only at the performance of our advertisement in Florida – thus we would filter the data to only show values which are from Florida. Why Florida though? I happen to live here so I’m a little biased:)

Support Files:

Data-and-Pivot-Tables-Start.xlsx Data-and-Pivot-Tables-Complete.xlsx

Leave a comment

(Your email address will not be published.)

1 comment “Pivot Table – Filters

  • Avatar
    Gloriane May 13, 2016 - 2:35 AM

    Your article perfectly shows what I needed to know, thanks!

    Reply

Rate this Video:

Avatar

Members Also Watched

  • Introduction (2m 4s)

  • Task 5: 6 – 10 (3m 36s)

  • Task 5: 1 – 5 (2m 54s)

Loading...