Introducing the TEXTJOIN function in EXCEL 2016 We are familiar with CONCATENATE function that we have been using for a long time to perform concatenation or to join different strings or numbers. This function has been preceded by introduction of a new function in Excel 2016 –the TEXTJOIN function (and also CONCAT function). The CONCATENATE function suffers from following … [Read more...]
How to use the SUMPRODUCT function in Excel
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 brief introduction of the … [Read more...]
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 referencing to set criteria for conditional … [Read more...]
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 theoretical background of project … [Read more...]
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 the function that we use when doing … [Read more...]