Before anything else, let me inform you that this Excel Petty Cashbook tutorial is an ultimate guide. Which means that I’ll try my best to exhaust every important detail you need to know about analytical petty cash book and how to design and create one using Excel. But as it [...]
Have you ever been asked to design a Cashbook system in Excel? Back at school, this was a group assignment of which I was part. More interestingly, but unfortunately, I was asked to lead the group. Since I could type, they thought they were lucky to have me in that [...]
Once upon a time, not too long ago, a company launched the cloud version of its desktop software and name it QuickBooks Online. Now the choice is yours, but which one should you go for - QuickBooks Desktop or QuickBooks Online? Both desktop and online versions are accounting software developed by [...]
It is not a surprise to see that Excel has a dedicated formatting style designed just for accounting purposes: that's the Accounting Number Format. In this guide today, the Software Accountant wants you to understand everything you need to know about this number format and how to use it productively. [...]
The need to split cells in Excel normally arise when importing data. Though it is not limited to that. In most cases, Excel might import multiple values into a single column. When this happens, you may need to split the data into separate columns. You might be able to use [...]
Using Excel, years of service can be calculated with the DATEDIF function. Its purpose is to compute the differences between two sets of date, simply put, it subtracts dates in Excel. Thus, the DATEDIF function is what you’ll need if you want to calculate years of service (or excel date [...]
The aim of this tutorials is to show you the shortest possible ways to remove certain characters in Excel. Maybe there are certain characters or letters you want to delete from your cells leaving the remaining content. This tutorial is created just for that. Let me save some time by [...]
If you haven’t yet, you’ll soon chance in a situation through your journey with excel, where you’ll want to manipulate text by changing the case, I mean capitalization. In this tutorials, I want to focus on how to change the cases of text in Excel. For instance, you want to change [...]
Whether you are an accountant or a business owner, you must know the impact of time on the business and its finances. Time is required for your business to grow. However, the accounting part of your business management is what will drain more of your time than most. From recording [...]
The more I work with Excel, the more I fall in love with it. Without a doubt, Microsoft Excel has proven itself as the best spreadsheet application that has ever existed. With all its countless and amazing features, more and more new features are being introduced in every new version, [...]
