How to Highlight Blank Cells in Excel using Conditional Formatting [Quick Tip]
With huge data pinpointing blank cells is near to impossible. Sometimes back we learnt how to fill blank cells with zero using Go-To special feature in Excel. But what if we only want to...
Budget vs Actual Variance Reports with “In the Cell Charts” in Excel
In life we all want to be in control. And usually we measure or judge whether things under control by comparing whats happening with what should be happening. In other words, we tend compare the actual events/results with...
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...
One minute Excel Tutorial – Watch Window
Accountants and analysts around the world does one amazing job and that is they give the meaning to mammoth data by processing it using their skills and the same information is then used by...
Preparing Fixed Asset (CapEx) forecast model in Excel – Depreciation & NBV Calculations
In any financial model (forecasts or variance analysis) the idea is to derive expectations where business will end up if particular set of assumptions (scenario) prevails. These are basically calculations that help the decision...
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...
Excel ALTernate ‘Powercut’ – One key to rule ALL shortcut keys
Ranking up in Excel world is not easy but definitely there are steps you can take to become an Excel head and one of such steps is to remember shortcuts. Well you have no...
Automating Data Entry using Data Validation in Excel
This is mainly a data entry tutorial and can be used in other scenarios as well. But as sales and price data is easily understood so I am using the same. Let me know...