Beat Excel! Get to next level in Excel!

Excel Gauge Chart

Here is the famous gauge chart. In this tutorial, I’m going to show you how to make an Excel gauge chart also further customizing it...

IF AND OR Function Combinations

Do you need to use a logical condition in your formulas? Do you need functions like between but can’t find it? This post will show...

Loading Bar Chart (incell chart)

In this tutorial, we are going to make an incell loading bar chart. It will fill dynamically as we input data and change it’s color...

Related Data Validation Lists

A very cool use of data validation is making related data validation lists. If your worksheets includes multi level data entry, this is a very...

Hyperlink

Hyperlinks lets yo link your content to other contents within or outside of your workbook. Be it another sheet or another workbook, even a web...

Excel Data Validation

  There is a way to restrict user input in excel.  This can be achieved by Data Validation.