Introduction COUNTIF () function constitutes a family of functions that is used for counting and specially for counting conditionally. We said that COUNTIF () is a family because there are few other similar function that are present in Excel that starts with COUNTIF. These functions include COUNTIFS() that is used for counting more than one criteria, COUNTA () that is used … [Read more...]

Creating a Project Timeline in Excel A project is a onetime activity that can span over varying length of time. A project could be an activity that can finish in a day or it could cover months and years. Project management is the process of managing this activity. As the complexity of the project increases, it becomes more and more difficult to manage it, hence require more … [Read more...]

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...]

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...]

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...]