How to Calculate Estimated Travel Time in Excel?

Case1: How many Days/Hours/Minutes it will take to travel 56,986 miles if a vehicle is traveling at constant speed of 12.5 miles per hour? Additional Information: During the travel time vehicle stops for 5 times with 18 hours as break each time Also consider the Overhead/Maintenance time of 100 hours for the one way trip […]

Read More

How to Flag Multiple Matches In Your VLOOKUP Formula?

This article will explore the Excel VLOOKUP Formula and show you how to combine it with an IF statement to flag if there are multiple lookup values matches in your data set. VLOOKUP is really great for pulling in data from a larger table in Excel, but sometimes in a larger data sets there may […]

Read More

Excel Formula : SUMPRODUCT () for Advanced Users

When I first learned about the SUMPRODUCT  formula  in  Excel , I almost dismissed it as a useless  formula  used by only few users. How often would anyone need to multiply 2 or more groups of numbers together and add up the results!? To get to the story, we know that formula is keyed in as: […]

Read More

How to Highlight a Row in Excel Using Conditional Formatting

You can use conditional formatting to format or color the cells based on their contents. For example, you have a cell to turn red when it contains text ‘No’ or a value less than 90%. But how do you highlight an entire row? When a cell contain specified content.
This tutorial will help you learn how to highlight other cells based on a cell’s value? To see how this was done, read on.

Read More