Conditions are everywhere, in our work, day to day life, in our conversation, everywhere. And when it comes to VBA coding, conditions are one of the most important things.If you want to be advanced VBA user then an IF statement is must learn. And, I believe that you are already familiar with word IF and […]
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 […]
In this tutorial, I will show you how to add a running total in a pivot table. You will also learn about different situations in which you can use it.
You know that pivot table is one of the most important tools to analyze and summarize data.You can create instant reports using pivot tables.And to make it more appealing to your users, you can apply conditional formatting to a pivot table.Just look at below where I have applied conditional formatting in a pivot table to […]
If you one of those people who hate to use a pie chart in Excel then there is an alternate for you.Waffle ChartA set of grids (squares of equal area) which represents the entire chart. It is also called a square pie chart.In the below example, we have a dynamic waffle chart which you can […]