Fastest way to copy object

You can quickly create a copy of object as below,

1. Hold down the Ctrl key

2. Click and Drag the Object to copy

Text date conversion to formatted date

In this post, we will learn how to convert "text" date, for example 28.10.2008 to a formatted date i.e 28-Oct-2008. The steps are as follow;

1. Use Mid function to split text to three category i.e day, month & year
2. Using Date funtion to convert the value to formatted date.

Sort data in Excel

Normally we are interested to view data that are sort ascending or descending according to specific field selected.

Sample of data before sorting as below; In this case we want to sort data from highest to lowest marks.

For fastest result, place your cursor at cell "D5". Push sort button , the result are as below (for descending sorting)

That all for now, see on the next publish with more tips and trick.

-Admin-