VBA To Create a Pivot Table [Macro Code]

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 macro code to create a pivot table, it was a failure.Since then I have learned more from my […]

➲ Continue Reading

How to Link/Connect a Single Slicer with Multiple Pivot Tables in Excel

Sometimes using more than one pivot table is a mess.But, it’s not a mess if you connect all the pivot tables with a single slicer. So, do you know how to link a slicer with multiple pivot tables?If you don’t know then follow this post. You will learn a superb trick to create some interactive […]

➲ Continue Reading

How to Enable PowerPivot In Excel 2010 Using Simple Steps

“PowerPivot will bring a lot more freedom to our information workers because they will have powerful, easy-to-use data analysis tools right on their PCs…without having to come to the IT department for help…” Ayad Shammout, Lead Technical Database Administrator, CareGroup Healthcare System I am sure above words will definitely inspire you. If you really want freedom […]

➲ Continue Reading

Excel Population Pyramid Chart

To analyze population data we can create a Population Pyramid in Excel. Here I have listed 3 different ways to create an Excel Pyramid Chart. All the three methods are simple to use & you can choose anyone which you think is a perfect fit for you.

➲ Continue Reading

How To Make a Pictograph in Excel

In this post, I will show you how to make a pictograph in excel using a bar chart. My idea to make a pictograph is to present the number of employees in various age groups in a company. I am just trying to click an idea to use a picture in a chart to make it more […]

➲ Continue Reading