Introduction There are two ways of organizing your data in Excel, either it could be a list or it could be a excel table. Both has its advantages and disadvantages. In today’s post, we will try to learn about the later and see how to get most out of it – i.e. excel tables. Tables are identified by a header row and a column, where is for list, there is only a header row. … [Read more...]
Getting Most out of COUNTIF () function
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...]