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