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...
Convert Numbers to Words/Text in Excel WITHOUT pasting macros again! – NUMWORD Excel Addin
https://www.youtube.com/watch?v=huozBRRIq1c
This has been long overdue and I am happy that an Excel add-in that helps convert numbers to words or text is finally here. Just install this add-in and you can easily convert numbers...
Variance Analysis in Excel – Making better Budget Vs Actual charts
Either it is about daily life or business, we almost all the time in our minds comparing the actual results with our plans. Though we can talk numbers and percentages but the way charts...
Using Conditional Formatting to highlight range of percentages in Excel
With conditional formatting feature, Excel makes even the numeric bits easy to understand with visual aids. Conditional formatting lets you format the cell and text within in relation to particular condition.
Suppose you want your...
Excel DSUM Function – “The” Sum function you MUST know
You must have learnt SUM in your early days of Excel and later might have learnt about nested IF statements to do conditional sum and you might have already learnt about SUMIF and SUMIFS.
But there...
10+ ways to make Excel Variance Reports and Charts – How To
Whether it is daily life thing or any day at work, we are always comparing to see whats good and what is not so good. This differential analysis has a much popular name as variance...
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 TODAY functions and then used conditional formatting and sparklines to...
Stock Ageing Analysis Reports using Excel – How To
Stock is one of the most important investment made by the entity. Optimum quantity and turnover period is essential for entity to be successful. Faster the conversion, better the prospects for entity as inventories...
5 Advanced Excel VLOOKUP tricks you MUST know!
https://www.youtube.com/watch?v=fTpqXfCGoik
1. Use VLOOKUP instead of nested IF statement
If nested IF functions appear as puke-in-puke to you then VLOOKUP's approximate match can help you get rid of heinously long IF statements. The only condition is to...
Top 10 Excel keyboard shortcuts for Accountants
Excel and accountants are two interconnected entities. Around the world excel is the most active computer application in the hands of accountants. Even if accountants have some other accounting software at their disposal they...