Excel Visual Basic modules require triggers to initiate. They can be initiated by using CTRL + combination shortcut keys, clicking a button, or simply pressing an ENTER key. I normally shun the use of CTRL + combination shortcut keys because it is not user-friendly. It requires the user to remember what keys to be pressed … Read more
You might have seen that your Access database file keeps on growing in size, even though you have not been putting in many new data. This is caused by the way how a database is structured. For all the database software that I used before, the database software leaves an unused section every time you … Read more
Both the WORKDAY and NETWORKDAYS functions are essential for project planning. The WORKDAY function allows you to calculate the completion date provided that you know the number of days that is required to complete the project. The NETWORKDAYS function does the opposite. You have a desired completion date and you want Excel to calculate how … Read more
Your Microsoft Access files are initially created in MDB or, with Access 2007 or after versions, in ACCDB format. In MDB or ACCDB formats, everyone can have access to your Visual Basic modules. Users can maliciously or accidentally change your codes and make your VB modules inoperable. To protect the integrity of your Access files, … Read more
You may want to include simple calculations in some of your Word documents, notably Quotes and Invoices. Ideally the quotes and invoices are generated from an Accounting system. But for a lot of small business owners, Microsoft Excel may already be their Accounting system. I have seen many small business owners use a calculators to … Read more
Quick Launch Bar is a wonderful tool to enhance your efficiency. It’s more convenient than placing your frequently used applications on your desk top. It is easy to put applications to the Quick Launch Bar. You just need to drag-and-drop the icons to the Quick Launch Bar. Besides putting the application icons from your desktop … Read more
I was once a part time interpreter about 20 years ago. I went to court houses, law firms, hospitals, and insurance companies to do instant verbal translations and document translations between Chinese and English. It was not an easy job but it paid well. The requirements of an interpreter are very high because you need … Read more
When we automate the Excel worksheets by using Visual Basic (VB) codes, we frequently have to make the cursor moved to pre-determined locations to do calculations, copy, cut, paste, sort, and filter data. If you know how to combine the movements with the looping, you have an ultimate tool for automation. The payoff is tremendous … Read more
Internal Rate of Return (abbreviated as “IRR”, also called “Yield”). In this article, “Internal Rate of Return” “IRR”, and “Yield” will be used interchangeably. IRR is one of the most important tools in the financial world. It measures how well an investment or a project performs over time. It is an essential part of benefit/cost … Read more
Ideally, all the reports should be generated from the system itself. However, we are living in a world with limited resources. The IT Department always has different priorities from you. Your urgent request may turn out to be the lowest priority of your IT Department. If you don’t know how to do some programming yourself, … Read more