How to Create Waffle Chart in Excel [Step by Step Guide]

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

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.

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

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

VBA To Create a Pivot Table [Macro Code]

How to use a VBA Code to Create a Pivot Table [Writing a Macro Step By Step]   Before I hand over this guide to you to start using VBA to create a pivot table, let me confess something.I have learned using VBA just four years back and the first time when I wrote a […]

1 20 21 22 23 24 28