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 alternative for you. Waffle Chart. A 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 […]
In this post, I’ll reveal the secret about how I use VLOOKUP And MATCH to create data for my Dynamic Charts. I’ll also tell you about reasons to use VLOOKUP And MATCH to increase the power of VLOOKUP. But before doing this let me explain you everything about the combination of these two awesome functions.
Before I tell you all time favorite Double Click Mouse Tricks which I use. Let me show you that, why I am using them. If you are using Keyboard Shortcut Keys to save your time & increase your productivity, you are a smart guy. All Excel users are always eager to learn more excel keyboard shortcuts so they […]
One of the most demanding and fascinating things for an Excel user is to create interactive things in Excel. And a checkbox is a small but powerful tool that you can use to control a lot of things by unchecking/checking it. In short: It gives you the power to make your stuff interactive. And, I’m sure you use […]