Merge Multiple Cells at Once (Vertically / Horizontally) with Format Painter (Excel 2013)

This trick will teach you how to quickly merge multiple cells More »

Create Table of Contents in Excel File (Excel 2013)

Learn how to create table of contents in Excel! More »

How to Disable Responsive Feature in WordPress (LineMix Theme)

Learn how to disable the responsive feature in WordPress (LineMix Theme) More »

5 Project Documentation Mistakes You Are Making

Attention! You could be making these mistakes in your project documentation. More »

 

Using Table to Control Header and Footer in Word – Part I (Word 2013)

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.

6 Types of Hyperlink You Can Create in Excel (Excel 2013)

Creating hyperlinks in Excel can be beneficial in terms of helping you to navigate better, i.e. jumping from one worksheet or cell to another, or opening an external file that is linked to a particular worksheet. Here are six types of hyperlink that you can easily create in Excel:

The Proper Way to Upgrade Your WordPress

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.

Create Table of Contents in Excel File (Excel 2013)

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!

Merge Multiple Cells at Once (Vertically / Horizontally) with Format Painter (Excel 2013)

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)?

How to Disable Responsive Feature in WordPress (LineMix Theme)

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).

Capitalise All Letters in a Row or Column (Excel 2013)

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.

Highlight Cell Based On Specific Word or Value with Find and Replace Function (Excel 2013)

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?

4 Ways to Backup Your WordPress Site

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.

5 Project Documentation Mistakes You Are Making

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: