Excel chart of Top / Bottom “N” values using RANK() function and Form controls

Ever fancied that you have large set of data and from it you can have a chart of top or bottom N values and better yet you have the ability to switch between chart...

ABC Inventory Analysis using Excel Charts

Earlier this month we learnt how to carry out ABC inventory analysis in Excel using conditional formatting technique. It was easy and we had loads of fun as we not only understood how to...

FREE Excel Invoice Template V1.0 with Customer and Product list – Unlocked + Download...

Everyone loves getting paid but to get paid one needs to send invoice and to make an invoice that is not only effective from a business perspective but also help you get invoicing done...

ABC Analysis using Conditional Formatting in Excel

ABC analysis is an inventory management technique in which stock is classified in usually three categories on the basis of their importance. Such classification help management to concentrate their efforts on such products that...

Making Interactive Charts in Excel [How To]

Graphs and charts are amazing tools to understand the information in the blink of an eye. It not only saves you from reading at all levels. That is why charts and Excel is one...

Excel Conditional VLOOKUP – Switching Between Multiple Lookup Ranges

We all love LOOKUP functions in Excel and the heart favourite is VLOOKUP. We are well introduced to VLOOKUP and have already seen VLOOKUP in action several times, but we never came across a...

Making Aging Analysis Reports Using Excel – How To

Aging analysis is helping accountants since ages and is one of those reports that are prepared mostly in Excel to track both receivables and payables. So today we are learning how to conduct aging...

Create Edgy To-Do or Checklists with Check boxes in Excel + Shortfall calculator

The ones who like to plan adores to-do lists as well. And if you are also the one who likes to strike a line or tick or dash or mark then this tutorial is...

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...