Calculating number of days between two dates – Excel Function Vs Common Sense
Business and every aspect of our life is about time and we have to compute days most often. To handle this Excel does provide a solution for in shape of a dedicated formula DAYS360()....
50+ Excel Tricks Accountants Love by Heart! – Episode 1
I often confront a question "what to know in Excel". Answer to this is not easy. To me Excel is like a journey and it never ends unless you stop. Similarly more you use...
Excel Pivot Tables – Grouping Data by Date and Time
Where reporting is about numbers and analysis, the big part of it is also about time. And to best understand the situation you sometime have to want information specific to certain time period or grouped for...
Multi level or Multi column sort in Excel – How To
Before in Excel tips we learnt about Custom Lists feature in Excel and how to use it to sort and have custom autofill series. In our example we sorted the sales data using our...
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...
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...
Using SUMIF function with Dates in Excel
I was in the middle of making an accounting project where I had to use SUMIF. This wonderful function that everyone must know especially accountants. In many instances SUMIF can be used as an...
Resume excel session with Save workspaces feature
In accounting world some work is repetitive and accountants have to open certain set of files almost on daily basis. Opening each file by reaching the location and double clicking might not be that...
ACCA Online Classes December 2013 Announcement and Quick Excel Tip on Duplicating Excel Worksheets
This time around the post is a mix plate. Some of you were worried that how come key strokes are silent on Excel for more than 24 hours. So here you have the confession...
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...