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...]
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...]
A how-to guide to conditional formatting based on another cell
Introduction The conditional formatting is used for highlighting cells that meet certain criteria. These cells can be duplicate values or they may fall within certain limits or a similar criteria. In today’s tutorial we will be explaining how to highlight a cell’s value when it meets criteria in a cell. Most often we use cell referencing to set criteria for conditional … [Read more...]
Getting Most Out of COUNTIF() and COUNTIFS() function in Excel
Introduction: There are instances when we are interested in counting things. This is true for accountants, engineers, managers and so on. To count, we usually record quantities, either on paper on spread – or if we record on paper, we eventually transfer it to a spreadsheet to make calculations more manageable. COUNTIF() or COUNTIFS() is the function that we use when doing … [Read more...]
Understanding How to Create a Histogram with MS Excel
Introduction: The data analysts start their analysis by visual examination of the data. This is to see if there are any patterns present or if there is any (apparent) relationship between variables. The data such plotted produced graphs of various types - an Excel Histogram is just one of them. In today’s tutorial, we will learn a little but of theory about histogram, how … [Read more...]