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 Project Timeline or Gantt Chart with MS Excel
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 to VBA for MS Excel
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...]