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 […]
“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 […]
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.
If you know how to present data in an understandable and effective way, you can deliver your message strongly.For this purpose, one of my favorite things is a PICTOGRAPH and in Excel, creating a pictograph is quite simple and easy.Today in this post, I’d like to share with you a simple step by step process […]
Creating In-Cell Charts with REPT Function is a smart move. You can use these charts in your dashboards to give a quick view to your user. I have used this text repeating formula to create an In-Cell Column Chart & a Star Rating Template. But, here I have created an In-Cell Gantt Chart for the sake of my laziness. Let me […]