Introduction: One can, surprisingly enough, use excel for conducting a forensic audit. Before jumping to that discussion, lets start with an introduction of auditing procedures. There are two types of procedures that attempt to minimize fraud in financial transactions - one called Statutory Procedure and one utilizing Forensic Techniques. The first technique is primarily … [Read more...]
Introducing the TEXTJOIN function in EXCEL 2016
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...]