Category: Advanced

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.

Repair Corrupted Excel Workbook

You can encounter corrupted workbooks time to time. Sometimes one of your workbooks gets corrupted, sometimes a file you received is. But there is no...