Excel tips for Accountants

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

FIFO Inventory Valuation in Excel using Data Tables – How To

Inventory can be valued in number of ways, FIFO, LIFO and AVCO being the most famous. To learn few more inventory valuation methods have a quick look at this: What are different inventory valuation methods? Entities purchase...

Dynamic Common Size and DuPont Analysis Financial Statements in Excel

What if you have to make few analysis together in Excel like common-size analysis, ratio analysis and duPont analysis, well this is what I did this weekend. And the best part is that it...

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

Grand Totals to the left of Excel Pivot Table instead of default right

In pivot tables by default grand totals appear at the right end of the report. But sometimes the pivot table is so wide that user just can't see the grand totals and we have...

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

Excel for Accountants – 10 Must Read Tutorials

Top 10 Excel keyboard shortcuts for Accountants Making Profit and Loss Statements in Excel using Pivot tables Budget Vs Actual – Analyzing Profit and Loss Statements in Excel using Pivot tables Preparing Fixed...

Make Budgets in Excel with Expenditure Limit – Budget Ceiling using Data Validation ...

Budgets help control the expenditures even before they actually incur. The concept of budget is to provide a ceiling or cap to expenditures so that departments or cost centers don't exceed a certain limit. If...

Making Cash flow summary in Excel using Pivot tables with data on multiple worksheets

Cash flow summaries are scary because of piles of data. But it is a routine work and accountants have to go through it every accounting period (monthly, quarterly and/or annually). Few days back I was approached...

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