Easy Website Metrics Dashboard with Excel
Do you run an e-commerce website? You are going to love this simple, clear and easy website metrics dashboard. You can track 15 metrics (KPIs) and visualize their performance. The best part, it takes no more than 15 minutes to setup and use. Here is a preview of the dashboard.
Click to download the template.
Top 10 Excel Formulas for any situation
Excel has hundreds of formulas. But as a new learner or user, you may want to just focus on top 10 formulas to get the most out of it. Assuming you already know the basics (check out Beginner Excel page if you are complete newbie), here is a list of top 10 Excel formulas for you.
Selective Sub-totals in Pivot Tables [Quick Tip]
Recently I was creating a pivot report with multiple items in row labels area. I had to show sub-totals, but only for one of the fields. Something like above.
How to show selective sub-totals in Pivot Tables
Summarize only filtered values using SUBTOTAL & AGGREGATE formulas
We all know the good old SUM() formula. It can sum up values in a range. But what if you want to sum up only filtered values in a range? SUM() doesn’t care if a value is filtered or not. It just sums up the numbers. But there are other formulas that can pay attention […]
Formula Forensics No. 037 – How to Count and Sum Filtered Tables
How to Count and Sum data from Filtered Tables
CP007: aweSUM() – Overview of SUM functions in Excel
Podcast: Play in new window | Download
Subscribe: Apple Podcasts | Spotify | RSS
In the 7th session of Chandoo.org podcast, lets make you aweSUM().
Imagine for a second that Excel cannot add up numbers. And no it cant subtract them either. What would that look like?
A glorified Notepad. That’s right. Excel’s ability to add up numbers, along with features like formulas, charts, pivot tables & BHATTEXT() are what make it such a lovely software. May be not the BHATTEXT(), but we all agree that Excel is so versatile and useful because it can add up numbers (and perform other calculations) with ease.
But how well do you know the SUM formulas of Excel?
In this podcast, you will learn,
- Special personal fruit announcement 😛
- + operator
- Status bar & total rows in tables
- Auto Sum feature
- SUM() function
- SUMIFS function
- Special cases of SUMIFS function
- SUBTOTAL & AGGREGATE functions
- Other summing functions – SUMPRODUCT etc.
Top 10 Formulas for Aspiring Analysts
Few weeks ago, someone asked me “What are the top 10 formulas?” That got me thinking.
While each of us have our own list of favorite, most frequently used formulas, there is no standard list of top 10 formulas for everyone. So, today let me attempt that.
If you want to become a data or business analyst then you must develop good understanding of Excel formulas & become fluent in them.
A good analyst should be familiar with below 10 formulas to begin with.