Data analysis and presentation can be a very complex task most especially, if you work with a large mass of data on Excel. Also, there may be a demand to analyze data and present them in such a way that you can get different scenarios of a ” What-if-Analysis” problem just with the click of […]
In year 2000, when I got my first job in a manufacturing company as an account officer; then we had a chief accountant, an account supervisor, two (2) account officers, a cashier and one (1) computer operator. If you see the pile of books we use to maintain our records, you will tremble…great fear will […]
I have been involved in design and implementation of accounting systems for many businesses in Nigeria. Most often than not, I have encountered challenges in transitioning the current systems of some companies either to an accounting software solution or a tailored made system, using programs already at their disposal – Programs like Ms Excel. Most […]
Many Excel users claim to be gurus in Excel; they are comfortable with their knowledge of Advanced Excel and they felt that there is nothing more to learn. Ask some of them if they know about VBA, they will ask you, ” What is VBA?”. – In fact, many of them have never heard about VBA, […]
