• Formulas
  • Excel Tips & Tricks
  • Excel Charting
  • Tutorials
  • VBA
  • Book Store
  • More
    • Blog
    • Download Area
    • Excel Video Tutorials
Home » Pivot Tables

Excel Tip Custom Sorting Your Pivot Table.

July 16, 2019 by Barbara

Hello, welcome back for another #Excel tip. Today let's take a look at how to use Custom Sorting in a Pivot Table.  This is one tip I use all of the time, so I really wanted to share it with my subscribers.   If you need to sort your Pivot Table by a sequence other than say Numeric or in Date order then this will be very useful.  I need to sort my Pivot Tables on a regular basis by the products in order of importance to the business.  You can see a sample of raw data … [Read more...]

Filed Under: Blog, Excel Tip Category, Excel Tips& Tricks, Pivot Tables Tagged With: Excel, Excel Excel Tips, Pivot Table

Defer Data Updates In Your Excel Pivot Table. – Pivot Table Tip

August 14, 2018 by Barbara

Hello, Excellers. Today I want to show you a really quick Excel Pivot Table tip that might be very useful for you if you are updating or making changes to a large Pivot Table. You may already know that normally when a Pivot Table data field is added, removed, or moved to a different location the whole Pivot Table is recalculated. So, if you have a large dataset then it may take a little while to update the table. Did you know that you can edit and change your Pivot Table around without the … [Read more...]

Filed Under: Blog, Excel Tip Category, Excel Tips& Tricks, Pivot Tables Tagged With: Excel Tips, Excel Videos, Pivot Tables

How To Apply Conditional Formatting To An Excel Pivot Table – Correctly – Excel Tip

April 25, 2018 by Barbara

This next tip I know causes a bit of frustration with Excel users, based on the number of times I have been asked about it. It is applying conditional formatting to a Pivot Table. The method of applying conditional formatting to a Pivot Table is not the same as applying it to a regular data set. In a regular data set, you would probably use the method below to highlight all sales values above the average in the data set. This is all working well for us, with the conditional … [Read more...]

Filed Under: Blog, Excel Tip Category, Excel Tips& Tricks, Pivot Tables Tagged With: Blog, Excel Tips, Pivot Tables

Pivot Table Tip- Assign The Correct Row And Column Labels Quickly

April 18, 2018 by Barbara

Hello Excellers, today I want to share with you a really good Excel Pivot Table Tip with you. Do you ever quickly create a Pivot Table, then end up with really naff labels on them. A bit like below? .. Both the row and column labels really are of no use to use. They look really bad don't you think?. Creating A Pivot Table. Here is a recap of how to create a quick Pivot Table. Select the data set you want to use for your table The first thing to do is put your cursor somewhere … [Read more...]

Filed Under: Blog, Excel Tip Category, Pivot Tables Tagged With: Blog, Excel Tips, Pivot Tables

Excel Tip – How To Hide Negative Numbers In A Pivot Table

December 20, 2017 by Barbara

Hello Excellers, I have a handy Excel Pivot Table Tip for you today. I was creating a Pivot Table this week, (one of many!), and it contained negative numbers. Now, this was not the end of the world, but I really only wanted positive numbers to show in my Pivot Table. I did not want the either of the zeros or the negative numbers to be visible. This is a handy little Excel trick, so I thought I would share it with you. Here is a sample of the type of data set I was working on and how to hide … [Read more...]

Filed Under: Blog, Excel Tip Category, Excel Tips& Tricks, Pivot Tables Tagged With: Blog, Excel Tips, Pivot Tables

  • 1
  • 2
  • 3
  • …
  • 5
  • Next Page »

Tags

Blog Cells Excel Excel Charting Excel Excel Tips Excel Formulas excel tip Excel Tip Category Excel Tips Excel Tips& Tricks excel tutorials Excel Videos Excel Video Tutorials formatting Formula formula friday Formulas macro Macro Mondays Macros Pivot Table Pivot Tables Power BI Power Query Tutorials vb VBA Worksheets

Recommended Excel Resources

Free Excel Dashboard Webinar

Copyright © 2020 · Enterprise Pro Theme on Genesis Framework · WordPress · Log in

 


Popular Pages

  • Home

More Info

Want FREE Excel Tips?

Click on my FREE eBook, its my bonus for joining thousands of others who receive my 3 xFREE Excel tips every month in my Excel Newsletter. Join Us!.

Need Answers To Excel Questions Like These?

*How Do I Create A Timestamp In Excel?
*I Want To Change The Width Of The bars On My Excel Chart
*How Can I Find Out The Length Of My Text in Excel? Click the link below to receive more Excel tips' and my Free Ebook

New To Excel? This Is A Great Place To Start!!

Learn Excel Dashboard Course Excel Basics
Scrollbars
Colour of Sheet Tabs
Conditional Formatting
Calculations Introduction

Excel Charting

Self Expanding Charts
One Click Charts
Create Quick Dynamic Charts
Easy Combination Charts

Video Tutorials-If You Like To Learn By Watching

Subscribe to YouTube to get notified of of new Excel videos.


Self Expanding Chart
Delete Obsolete Items From A Pivot Table-Excel 2007
What Are Pivot Tables- Create Your First One
Enable The DeveloperTab In Excel

Some Fun Stuff

Pivot Table Song

 

Search

Navigation

  • Formulas
  • Excel Tips & Tricks
  • Excel Charting
  • Tutorials
  • VBA
  • Book Store
  • Top Menu

Social

  • Twitter
  • Facebook
© 2021 howtoexcelatexcel.com. All rights reserved.
  • Privacy Policy