Shortcut to insert new row in Excel

If you press Alt + I + R, you would simply get a new row inserted right away in your Excel sheet :-)

keeping tasks tab in view in Outlook 2013, HOWTO

Tiered of clicking on Tasks to see remaining tasks and of-course forgetting them becuase they are not right in front of your eyes all the time, well then read this post from Microsoft which helps you to keep the tasks always visible in your Outlook 2013
http://office.microsoft.com/en-001/outlook-help/keep-upcoming-tasks-always-in-view-HA102809465.aspx

Concat two text cell in Excel

To concat two text cell in MS Excel, use CONCATENATE command.

E.g. =CONCATENATE("i";A1) -> would concat "i" to the begnning of your text at A1 cell.

Checks two cell text in Excel

This command, checks the A1 text with A2 text and writes TRUE or FALSE in C1. True is written in case of equality.

C1: =EXACT(A1,B1)

Removing letters from beginning / end of a cell in Excel

LEFT and RIGHT function allow you to remove the certain characters from the beginning or end of one or several. The example below removes the first 4 character from the beginning of A1 cell.

B1: =RIGHT(A1, LEN(A1)-4)

This removes 4 character from the end of the text in A1 cell.

C1: =LEFT(A1, LEN(A1)-4)

Having two Excel 2010 files beside each other in Windows 7

Wanna have two Excel files beside each other and you can't get it done !!! Well remember you are using Microsoft products, so don't be surprised that they don't manage normally to let you have two windows beside each other. Well but there is a hard way to do this : 

1. Open the first workbook any way you want. 
2. Start a second instance of excel. either double click on shortcut to excel.exe on your desktop or through windows start button | run, then type: excel and hit enter. Then file|open the second workbook. 
3. Now files are separated and you can have them beside each other ... Siiiiiigggggghhhhhhh :-S

Next line in a cell in Excel

As it sounds very easy, but if you are visiting this page, you know it is not that easy as it sounds ;-) Usually in such cases Shift+Enter is the right combination, but strangely Microsoft use that for another operation in Excel and instead uses Alt + Enter. Hold Alt key down and press enter.

Enable Wireless Networking on MS Windows Server 2008

Start -> All Programs -> Administrative Tools -> Server Manager

Choose Features in Service Manger and then choose the check-mark beside Wireless LAN Service and click Next. Later you need to click install and you are done. Wireless networking is now installed on your Windows Server 2008.

OBS : Bear in mind that using wireless services is not as secure as cable and therefore deactivated.