Introduction: We use programming language to build applications that we use in our work and domestic lives. This is true for almost every computer application that we use. There are numerous languages out there, that are at the disposal of the programmers that use them for various purposes. The language that is used to add more functionality to MS Office, or is used as a … [Read more...]
How to Annotate an Excel Pivot Table
Introduction: "Comments" or "Annotations" add a lot of value to data. They are frequently added by programmers to their codes to make them more understandable. Adding appropriate comments to a program or document is a good practice because a programmer or writer might forget, over time, the purpose of the code. For someone who was not part of the project it could be really … [Read more...]
Five Ways to Perform A Forensic Audit Using Excel
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...]