When you are transferring data between your computer and external hard drive, if the drive becomes much slower than before, it is very likely that something wrong has occurred. This article will unveil the 7 main reasons and according solutions.
Nowadays, many prefer to select an external hard drive for data backups in that it is affordable and its copying speed is higher than traditional data storage media, such as CD or DVD. However, sometimes, an external hard drive may become very slow...
Read more »
The Excel ribbon can be modified to suit a particular job. This exercise creates new menus that point users to specific sheets relevant to their task.
In this article, we will introduce how to create customized menus in your Excel worksheet, like this:
This article assumes the reader has the Developer ribbon displayed and is familiar with the VBA Editor. If not, please Google "Excel Developer Tab" or "Excel Code Window".
Workbook
The workbook to be used has a number of sheets. We...
Read more »
Excel Templates are typically workbooks, with a reporting framework, often supported by functions. A templates (xltx) can be used over and again without polluting it with data. After population with data, a template workbook is saved as an xlsx, preserving the virgin state of the xltx itself.
In this exercise we will use VBA code to open and populate a template. The template can be found here and Excel Macro used can be found here.
This article assumes the reader has the Developer ribbon...
Read more »
