Place Key Information in Golden Triangle on your Reports, Dashboards etc. [Quick Tips]
Today, we will take a detour to world-wide web and learn how we can improve our dashboards, reports, presentations or workbooks by using one of the ideas, called as Golden Triangle.
Update Report Filters using simple macro – a Dynamic Pivot Chart Example
Last week, we have learned what Pivot Table Report Filters are & how to use them.
Today, I am going to show, how you can use simple macro code to change the report filter value dynamically.
We will learn how to create the chart shown here.
Comparing Sales of One Product with Another [Excel Techniques]
This is a guest article by Theodor on how to Compare Sales of One Product with Another
Ok, now here’s one for you.
Suppose you’d like to come up with a sales report on different products, comparing their evolution on the same period of different years (say Jan ’09 vs. Jan Jan ’10). At the same time, you’d like to keep an eye on their yearly trend (entire 2009 vs. entire 2010).
Read on to learn how you can use Excel Charts to do this very easily.
There is an Easter Egg in Excel!
Did you know that MS Excel has a hidden, life altering Easter egg? This is a story of how I found it and discovered joy. Read on.
Almost an year ago, I have quit my job with one of the leading IT companies in the world, to embark on an uncertain but very exciting journey. I have started my own business around MS Excel – creating & selling awesome Excel products & training programs.
This is a continuation of the Chandoo.org Start-up Story posted around the same time last year. Grab a cup of coffee and read it in leisure. Do not expect any Excel tips. 🙂
What are Pivot Table Report Filters and How to use them?
Today we will learn about Pivot Table Report Filters.
We all know that Pivot Tables help us analyze and report massive amount of data in little time. Excel has several useful pivot table features to help us make all sorts of reports and charts.
Report Filters are one such thing.
Are You Ready for Online VBA Classes? I need your help!
Many of you have emailed and asked me, “Chandoo, can you help us learn VBA too? Just like you do with Excel.”
Well, as flattering as those requests were, the fact is, I was lousy at VBA. Well, I used to be very good at Visual Basic, back in the college days. But my programming skills have rusted over the years as I did very little coding. I guess, I have become a business-guy. So it took me time to re-learn VBA. And now, I am happy to announce that We are ready to start our very first batch of VBA Class.
But, before we start, I need some help from you. I want to know what is it that you want to learn, so that we can design the course curriculum & methodology around your needs.
So please take a few minutes and complete this survey:
Celebrating India’s Worldcup Cricket Victory – In Excel Dashboard Style!
I know I am late to the party, but better late than…, uh! forget it.
As the keen readers of our blog knew, I like cricket and I show my enthusiasm by making an excel dashboard (or info-graphic) whenever Indian team reaches a major milestone. So naturally, I was super excited when we won the ICC World cup 2011. Last time Indian won the event was in 1983 and my idea of a dashboard at that time was a bottle of milk and jingo-bell, my favorite shake-to-make-annoying-noise toy. I think our latest world-cup victory deserves something more than that. So here we go.