This trick will teach you how to quickly merge multiple cells More »
Learn how to create table of contents in Excel! More »
Learn how to disable the responsive feature in WordPress (LineMix Theme) More »
I have seen many occurrences of header and footer going out of places in Word documents for various reasons (some are even unexplainable!). While there are many ways to solve problematic header and footer, I prefer to use table to control them, especially if it involves a combination of text and image.
It is always a good practice to keep your WordPress updated. Whenever a new version of WordPress is available, the message “WordPress X.X is available! Please update now” will appear in your WordPress main screen where X.X refers to the latest released version. There are two ways to upgrade your WordPress, i.e. one-click update and manual. This tutorial will focus on the one-click update.
There are times where your spreadsheet will expand and have several worksheets within the same spreadsheet file. Normally, you would click the worksheet tabs (or next / previous arrow buttons) to navigate between worksheets. That’s okay, but…if you have more than 15 of them, it will be rather troublesome to sort through the list of tabs in your file just to find that particular worksheet!
Merging multiple cells across rows and columns is a fairly straightforward task. Simply choose the number of cells that you wish to merge, then click the Merge Cells button. Easy peasy, no? What if, you want to merge a defined set of cells in a repeated manner vertically (i.e. across several rows) and / or horizontally (i.e. across several columns)?
Many developers are jumping on the responsive web design (RWD) bandwagon, creating a flurry of responsive themes that will dynamically transform your viewing experience based on the device you use to surf the web. But not everyone will find it suitable for their site (and yes, I am one of them!). In this tutorial, I will show you how you can disable this feature for LineMix theme (version 2.5).
It is so easy to capitalise all the letters in a sentence or paragraph in Word (and vice versa), but it isn’t exactly straightforward to do the same in Excel. Yes folks, you can actually change the capitalisation of the words in Excel too! It just requires extra steps to achieve it as compared to Word.
It’s very easy to search for words or values (and replace them) in any excel-generated report by using the Find and Replace function. Do you also know that you can actually highlight the cell (i.e. fill in the cell colour) whenever that particular word or value is located?
I’ve had my fair share of horror stories on data loss. I lost my laptop to nasty thieves one night after work, and my last data backup was as old as one month! The amount of work I need to do in order to rebuild what I have lost was almost unimaginable! Then there was this incident where my laptop just died on me. Although I did perform periodic backups, I still need to rework on some files where recovery was just impossible.
Having worked with a diverse group of people in various industries, I have dealt with a lot of project documentation of varying types, ranging from user requirements and system design to scope of work and project charter. More often than not, mistakes are unavoidable (we are humans after all!) but some mistakes just shouldn’t be repeated. Here are the top five mistakes that I often encountered in project documentation: