How to get Maps in to Excel charts & dashboards [Master Class]
This is third episode of our Monthly Master Class.
In this one, you will learn how to get maps in to your Excel workbooks. Understand 5 key techniques for making maps based visualizations in Excel – from regular charts to cell grids to VBA to Power Maps, everything is covered in this intense Master Class.
We are moving to New Zealand [personal]
Time for a quick personal update. We (Jo, kids & I) are moving to New Zealand on July 15th. We are going to Wellington and will be living there for next 2 years. New Zealand…Really? Why? How? To understand that, we need to go back in time, to EDATE(TODAY(), -75). In April 2010, I moved back to […]
Sum up neither “A” nor “B” values – How to use DSUM function in Excel [video]
We know how to use SUMIFS function to answer questions like, “What is the sum of values for ‘A’?” But how would you answer questions like,
- What is the sum of values that are neither “A” nor “B”?
We can still use SUMIFS, but it will get awfully long. So let’s turn our attention to other functions in Excel.
SUMPRODUCT – Beginner to Advanced [Master Class]
This is second episode of our Monthly Master Class.
In this one, you will learn all about SUMPRODUCT. Know all about basics to advanced usage of this powerful & versatile formula in this 98 minute master class.
Advanced Interactive Charts using Excel [Master Class]
As announced earlier, here is the first one of our Master Classes. In this one, you will learn how to create advanced interactive charts in Excel by blending pivot tables, slicers, timelines, VBA, conditional formatting and charts. The final outcome is BEAUTIFUL!!! Monthly Master Class – Episode 1 – Trailer Check out a quick trailer of the […]
Introducing Chandoo.org Monthly Master Class
Hi folks,
I have an exciting announcement for you. Starting this month, I will be running a monthly master class on advanced Excel. This is a video class to help advanced users learn creative, powerful ways to use Excel in their day to day work.
What is this Master Class?
The idea is simple. Every month, I will create a lengthy video discussing one of the below topics, specifically targeted at advanced Excel users. As our blog grew, we have a lot of experienced, advanced users and I want to help you achieve more. You will learn,
- Dashboards
- Data Analytics
- Visualizations
- VBA / Macros
- Business Modeling
- Business Intelligence
Each class will be on an different topic with in-depth coverage, creative outputs and awesome techniques. You can sign up for the class that suits your needs.
A slicer that doesn’t slice [Pivot Table Tricks]
Mary Ellen, one of our readers, has an interesting conundrum,
I have some data that goes to Pivot table then to pivot chart. There is a slicer to filter the data. But when I slice, my pivot chart gets messed up. How to have the slicer, but still see the insights in the chart?!?
See above demo to understand:
This is because when you slice by a school, the pivot table gets filtered and hence % row total for that school becomes 100% (as there are no other schools).
How to fix the problem? The easy answer is to remove the slicers. But we want to have our slicers and eat a slice of them too. So we crank up the Excel awesomeness valve and get to work. There are two ways to achieve what we want.
- Old school method: Two pivot tables, some formulas & a line chart
- New Excel method: Power Pivot and a line chart
Read the rest of this article to know more.