Category: Advanced

Advanced Excel Tips and Tutorials – Advanced Excel Features and Hacks Explained with Examples

Search By Color In Excel

Most users does not know that they can search by color in Excel. But with a bit of attention to details, you can search by color...

List Unique Values In A Column

Often times you need list unique values in a column to summarize, check or compile results. I will show you three ways to do it...

Excel Organization Chart

Here is an unusual use of column chart, as an  excel organization chart. It is pretty easy to make and look very nice. You can...

Create Custom Ribbon

We have been over customizing ribbons in a previous post. Now let’s see how we can create custom ribbon in Excel.