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...
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...
Making Aging Analysis Reports using Excel Pivot Tables – How To
Last time when I discussed preparing aging analysis in Excel, I used formula approach to do it. I used the combination of IF and...
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...
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...
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...
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...
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...
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...