How to switch from Hangouts to old Google Chat
| |

How to switch from Hangouts to old Google Chat

Google introduced Hangouts to replace the old Google Chat interface and most likely you’ll be using this interface in your Gmail interface as well as on your mobile devices. Hangouts added a several features missing from traditional chat including the Group conversations. However, I, for one, prefer the traditional Google Chat interface that gives me a one shot view of who is online and not.

How to change your post slug in WordPress for good SEO
| |

How to change your post slug in WordPress for good SEO

If you have configured your WordPress blog to display permalinks, WordPress will automatically generate a post slug using the title of your post. However, this post slug tends to be very long if you have a long title. Good SEO dictates that you keep your post slug as short as possible and you can do this by removing some stop words.

MEDIAN IF tutorial in Excel 2007 and Excel 2010
| |

MEDIAN IF tutorial in Excel 2007 and Excel 2010

Excel 2007 brought a host of new functions to Excel that were missing in Excel 2003. One of these functions was AVERAGEIF which returns the average (arithmetic mean) of all the cells in a range that meet a given criteria. One essential function that is still missing is MEDIANIF or MEDIAN IF which should ideally return the median of all the cells in a range that meet a given criteria.

The new Gmail inbox automatically sorts your emails
|

The new Gmail inbox automatically sorts your emails

Gmail today unveiled a new inbox view that brings back control to email. The new Gmail inbox will automatically sort your emails based on who you receive them from and all are easily accessible by a familiar tabbed interface. Your key emails will automatically show up in Primary and serves as the default inbox that you can access either from you desktop, Andoird or iOS mobile app.