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...
How to make a basic Tax calculator in Excel
Business and Taxation go hand in hand. However, taxation calculations are most of the time tedious and if you need to make a small change you might have to punch millions of calculator keys...
Dealing with Telephone numbers in Excel – Dialing in the correct format
Many have the impression that Excel is a tool to do maths. But the ones who are using it on daily basis know that Excel is way beyond just calculation and helps you maintain...
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...
Excel Drop Down List using Data Validation and Excel Tables that updates dynamically –...
Excel drop down lists are one easy way to keep your data error free and other benefit it is that it automates data entry to some extent. Data validation help us make such drop down lists easily.
For...
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...
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...
Budget Vs Actual – Analyzing Profit and Loss Statements in Excel using Pivot tables
This tutorial is effectively a continuation of last tutorial on profit and loss statements using pivot tables in which we learnt how to make a report in Excel using pivot tables feature to make...
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...
Making dynamic Chart of Accounts, Journal + Ledgers in Excel – How To
Excel is one of the favourite tools for accountants and for everyone else who has anything to do with accounting information. It is a tool of choice when it comes to data extraction and...