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...
401k Calculator

401k Calculator

This template evaluates your 401(k) plan position and simulates future contributions by you and your employer. This spreadsheet also provides an analysis of your final balance in regards to your contributions, your employer’s contributions, and interest earned until...
INDEX & MATCH: A Better Way to Look Up Data

INDEX & MATCH: A Better Way to Look Up Data

VLOOKUP and HLOOKUP are the go-to functions for most Excel users to look up data in a table. However, there is an alternative to this function that can do the same job, with added benefits. It’s the INDEX and MATCH combo. Using these two formulas in conjunction can...
Crunch Data Even Faster with Excel SUMIFS Function

Crunch Data Even Faster with Excel SUMIFS Function

SUMIF function, as the name suggests, sums up the values in a range of cells, if a certain criteria is met. What if you want to compare multiple checks and add different columns? That’s where its older brother, SUMIFS, come into play. SUMIFS can do the exact same...
Reducing Formula Errors in Excel

Reducing Formula Errors in Excel

Following certain guidelines when working in Excel can save you the headache of dealing with errors. And if something does go wrong with a formula, there are things you can still do. Let’s take a look at some recommended methods for creating formulas, and how to...
Extract Data Quickly From Tables with Excel’s SUMIF Function

Extract Data Quickly From Tables with Excel’s SUMIF Function

SUMIF function is, in a way, a combination of SUM and IF statements. The formula SUMs up the values of a range of cells, IF certain criteria is met. In other words, data that pass the logic test gets to be added up (or another column of your choice, that corresponds...