Excel MS Office

Conditional Formatting in Pivot Table

You know that Pivot Table is one the most important tools to analyze data. And, Conditional Formatting is useful to deliver a strong message to the user along with data. In this post, you will learn about how you can combine these two awesome tools. You will learn to apply conditional formatting in pivot table. Below, I have used conditional formatting in pivot table to present a dynamic formatting. It will highlight city which has highest amount & a city which has lowest amount every time I

Read more
Excel MS Office

Excel Pivot Chart

Do you remember when last time you created an Excel Pivot Chart? And, do you know Excel Pivot Chart is the easiest way to create dynamic charts in excel? The bad news is, most of the Excel users avoid using Excel pivot chart in their work. But the good news is, creating an Excel Pivot Chart is simple, just like a creating a pivot table. In this tutorial, you will learn how to use an Excel Pivot Chart and how you can make

Read more
Excel MS Office Tips and Tricks

5 Effective Ways to Quickly Repair a Corrupt Excel File

Excel is extensively used by both business organizations and individuals for maintaining records or tasks. The most petrifying situation is when the file is corrupt, and the data becomes inaccessible. In this blog, we will be discussing the causes of corruption and five ways to repair a corrupt Excel File. Even a minor error can completely corrupt the file. Some of the common causes of Excel file corruption are: Improper shutdown of the system – One of the primary causes

Read more