With a pivot table, you summarize your data within a few seconds. You can create reports, analyze data, and easily share with others.That’s the beauty of pivot tables.But here is a twist:Normally when you create a pivot table you can select source data from a single table in a worksheet as Excel doesn’t allow you […]

SUMPRODUCT is one of the most important Excel functions and the best part about it is, you can modify it in several ways.And, one of its powers which I have discovered recently is using it as “SUMPRODUCT IF”.In short, a Conditional SUMPRODUCT.As you know, you can use SUMPRODUCT to multiply and sum specified ranges or […]

The best part of conditional formatting is you can use formulas in it.It has a very simple sense to work with formulas. Your formula should be a logical formula and result should be in TRUE or FALSE.If that formula returns TRUE, conditional formatting will apply and if it returns FALSE, conditional formatting will not apply.The […]

How to Automatically Add Serial Numbers in Excel Experts know the importance of serial numbers.Serial numbers are like salt. You never feel their presence but their absence makes your data tasteless.Yes they are important.Because with a serial number you can have a unique identity to each entry of your data.But the sad news is, adding […]

Sometimes in Excel, you need to perform some quick calculations. And, you can use paste special for these quick calculations instead of formulas.In paste special, you have four different options [Add, Subtract, Multiply, and Divide] which you can use.And today in this post, I’d like to show you how can you use paste special to […]