Apply Conditional Formatting to a Pivot Table

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 […]

➲ Continue Reading

Create Waffle Chart in Excel

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 […]

➲ Continue Reading

VLOOKUP MATCH Combination

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.

➲ Continue Reading

10 Powerful Double Click Mouse Tricks For Excel Power Users

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 […]

➲ Continue Reading

Insert Checkbox in Excel

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 […]

➲ Continue Reading