Quickly fill Blank cells with the Value in the Cell Above
There are situations when you ask someone to punch data for you and they come up with one lazy idea to leave the cell blank if the same value is repeating in subsequent cells in the same column. Download the tutorial workbook or look at the picture below to understand the situation better. This is definitely […]
Excel Pivot Tables - Grouping Dates by Week Within Months, Quarters or Years - Workaround
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 also learned one limitation of this feature i.e. if we want to group dates by week within a month or […]
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 certain period of time. Excel is good and the best thing happened to Excel is Pivot Tables and one of the […]
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 using Pivot Tables in Excel. The reason was by that time we didn’t discussed how to make pivot tables. But as […]
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 and also your Excel tip for which you wait everyday. So again fulfilling the promise to make you excel at Excel […]
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 is however, very opposite. I would really like that you must convince rather pressurize IT department of your company to have […]
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 to PC’s mouse. Following are the double click tricks you can do with your mouse in Excel to make your daily […]
10+ ways to SUM Top N values in data range - Ready to be Ben 10 of Excel?
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 discussed how to do conditional SUM as well where we learnt to add up only those values that certain criteria. However, […]
20+ Excel Table tricks to turbo charge your data
Following are the tricks you can do with the features Excel tables offer. Following list is in no particular order. I think all of them are handy that every excel user must know to make his/her work more easy. As there are more than 20 tricks you can perform with tables, the whole article has […]
Calculate number of Work Days in Excel using formula
Few days back I scribbled about calculating days between two dates and there I discussed DAYS360 formula method and one other common sense method to find out the number of days between two dates. But what if we want to find out working days between two dates and not just any days i.e. excluding weekends […]
