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