Create an Excel Heat Map

Create an Excel Heat Map

What is a Heat Map? A heat map is a two-dimensional graphical representation of data, where values are represented by a color scale in a matrix layout. Color-coded cells allow easily identifying the outliers and see the patterns in your data. Excel’s cell-based matrix...
Data Validation: Excel Doing the Data Cleaning for You

Data Validation: Excel Doing the Data Cleaning for You

One of the most versatile features of Excel that is data validation can validate user entries based on rules set by you. With this feature, you can impose strict rules on cells where users can’t enter any invalid data, or display warning messages to make your users...
Least useful Excel formulas

Least useful Excel formulas

Microsoft Excel features more than 400 formulas that users enjoy when creating marvelous data models, calculators, and fun tools. Microsoft keeps adding new ones every now and then, but usually also keeps the existing ones for the sake of backwards compatibility....
Manage Tasks Better by Visualizing the Data in Gantt Chart

Manage Tasks Better by Visualizing the Data in Gantt Chart

What is a Gantt Chart? Gantt charts are widely used in managing resources, operations, production, and other fields. The start and end times of each item is portrayed using the X axis scale and the bar length. Thanks to the way this chart is structured, you can see...