Introduction to SUMPRODUCT: In today’s post we will review some of the use of SUMPRODUCT function. The SUMPRODUCT function is amongst one of the favorites functions for Data Analysis – Particularly when you want to answer exploratory question like “how many”, “how frequent”, finding sum and averages against criteria’s. So we will start with a […]

#### Recent Excel Tips

## A how-to guide to conditional formatting based on another cell

Introduction The conditional formatting is used for highlighting cells that meet certain criteria. These cells can be duplicate values or they may fall within certain limits or a similar criteria. In today’s tutorial we will be explaining how to highlight a cell’s value when it meets criteria in a cell. Most often we use cell […]

## Creating Project Line (Gantt Chart) in MS Excel

Introduction: Though there many “dedicated” application available for project managers to manage their projects, like MS Project or Primavera Project Planner, we can also create a project time line in MS Excel! In today’s tutorial, we will be exploring the ways to create a project time line in excel, along with the terminology and some […]

## Getting Most Out of COUNTIF() and COUNTIFS() function in Excel

Introduction: There are instances when we are interested in counting things. This is true for accountants, engineers, managers and so on. To count, we usually record quantities, either on paper on spread – or if we record on paper, we eventually transfer it to a spreadsheet to make calculations more manageable. COUNTIF() or COUNTIFS() is […]

## MS Excel Data Validation for Accountants

Introduction: Data Validation is meant to ensure that user inputs correct type of information in the cell. The Data Validation can be achieved in the form of “Drop-down Lists” that make sure that user can only choose from a given set of values or using options like input being whole number, a decimal value, a […]

## Choosing between Vlookup and Index-Match formulas

Introduction INDEX()+MATCH() and VLOOKUP(), both have their proponents and opponents. Both of these formulas perform almost the same function. Both have pros and cons. In today’s tutorial we will try to compare their usage and that how they can be used to get most out of them, when we should drop one and use another. […]