Excel Pivot Tables – Grouping Dates by Week Within Months, Quarters or Years –...
Earlier we learned about grouping and ungrouping time related information very easily using excel pivot tables. It saves huge amount of time in preparing summary pivot table reports with different dimensions of time.
However, we...
Excel Pivot Tables – Grouping Data by Date and Time
Where reporting is about numbers and analysis, the big part of it is also about time. And to best understand the situation you sometime have to want information specific to certain time period or grouped for...
Running Totals and Running Balance with Excel Pivot Tables – How To
Last time when I discussed how to do running totals and running balance using Excel many different ways were discussed but one was left for today which is doing running totals and running balance...
ACCA Online Classes December 2013 Announcement and Quick Excel Tip on Duplicating Excel Worksheets
This time around the post is a mix plate. Some of you were worried that how come key strokes are silent on Excel for more than 24 hours. So here you have the confession...
Excel Pivot Table Slicers: Old Filters got Overhauled!
First things first, this post is strictly for those who have Excel 2010 or later installed. But is this a warning not to read this post if you have older versions? NO! The intention...
Excel Mouse Mayhem – 35+ Mouse tricks for mouse mongers
I know many of the Excel users prefer keyboard shortcuts and Excel does provide plenty of them. But if we are keen to know and remember keyboard tricks then we should pay some homage...
10+ ways to SUM Top N values in Excel data range – Ready to...
We all love to add things up. Its always good if things add up to the way we want. And no doubt from Excel newbie to pro everyone uses SUM formula. We have recently...
Conditional SUM with Excel SUMPRODUCT function – Intro + Examples
One of our dear member at our Excel facebook page Mr. Zeeshan Sarwar shared a problem in which he wanted to sum only those invoices amounts against which "paid on" date is mentioned.
Putting it...
20+ Excel Table tricks to turbo charge your data
In my last article on tables Introduction to Excel Tables - Data beyond just formatting I discussed the basics. If you are new to excel or if you think that tables are meant for just...
Automating Data Entry using Data Validation in Excel
This is mainly a data entry tutorial and can be used in other scenarios as well. But as sales and price data is easily understood so I am using the same. Let me know...