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

Create Waterfall Charts in Excel – Visualize Income Statements!

A waterfall chart in Excel is a great way to visualize running totals making it super easy to understand how addition and subtraction of values affected starting value and how we reached the final...

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

Dynamically Highlight data points in Excel charts using Form Controls

Charts and graphs and other visual means make information easier to understand and analyze. Excel gives plenty of options in this department as different types of graphs are possible. But in some cases wrong chart types in...

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

Calculate Moving Average in Excel – How To

One of the ways to predict future is by observing where past is leaning. Trend analysis helps in forecasting the future based on past data. However, such data has the effects of different types...

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