The normal way of formatting cells in Excel (highlight the area, then Format - Cells at the top of the screen) doesn't work for pivot tables. Or rather, it will work once, but as soon as you Refresh ...

Preliminary Setup As I mentioned in my post on how to format tables in Excel, before I do anything with raw data, I format it as a table.

If you wish to create a a Pivot Table and Pivot Chart in Excel, then this detailed article will guide you through the entire process.

If you've have lots of data and lots of analysis to do, but little time or skill, you need Excel's Power Pivot feature. Here's how to get started with it.

Yes, removing table formatting and converting your data back to a regular range can impact pivot tables or charts that were created based on the table structure.

As the thread name suggests, I'm here to ask about data mining and pivot tables. I'm asking this because, this is my project in my computer class, and this project is 20% of my final grade.