Category: Advanced

April 19, 2014

Text to Columns

Sometimes you may need to divide text data columns. This can quickly become a dreadful task. To overcome this problem, Excel provides a tool named...

April 15, 2014

Heat map is a good way of visualizing distribution and it is very useful for quickly seeing where data is piling up, thus which data...

April 13, 2014

This time I will show you how to disable Send a Smile that places itself on your office apps and never goes away. I was...

March 22, 2014

Microsoft introduced Slicers with Excel 2010 and we all fell in love with it. Filtering tables and pivot tables became much more fun after we...

March 4, 2014

Sunburst chart is a nice way of presenting relational datasets together in a compact form. This chart type is very strong in summarizing data but...

March 2, 2014

You can setup a data validation list to limit entry to certain cells. But you will realize at some point that your data validation can...