Category: Advanced

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

Hide/Show Sheet Tabs

You can hide/show sheet tabs in Excel to prevent users seeing and accessing sheets that you don’t want them to. (adsbygoogle = window.adsbygoogle || []).push({});

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...