Monthly Archives: January 2016

Limitation (or bug?) with Filter by Color

Did you know that you can filter by color since Excel 2007?  Yes, that’s almost 10 years.  I wont’ say it is a new feature notwithstanding the fact that many people are not aware of it yet. 😛 Filter by … Continue reading

Rate this:

Posted in Excel Tips | Tagged , | 16 Comments

Sort by row (i.e. from left to right)

Sorting is easy, when the orientation of data is vertical. Although we are expecting data in a vertical layout, it is not uncommon that we still encounter data in a horizontal layout in real world.  Don’t you? With data in a row, … Continue reading

Rate this:

Posted in Excel Basic, Excel Tips | Tagged | 2 Comments

Display % of column and % of row in a dynamic way

This post is intended to give you an introduction of CHOOSE function and Option Button (Form Control). Here’s the situation: We want to display the % of total in a 2-D table.  Nevertheless the % can be of column total … Continue reading

Rate this:

Posted in Excel Tips, Formula | Tagged , | Leave a comment

Excel Humor #3 – Advanced User

Happy New Year!!! Wish you a happy, healthy and prosperous year of 2016. In a word, wish you EXCEL in 2016! 🙂 Let’s start the year with FUN!

Rate this:

Posted in General | Tagged | Leave a comment