Removing values from table

How do I remove set of values from the table? In practice, sometimes we encounter a scenario where it is necessary to remove from the list of entities one or more of the values specified in an ancillary records. For example, in the first list there is a list of workers, and in the second list of workers that need to be removed. How to perform this without having to manually remove one by one from the table?

Counting by color

When creating tables, we often use our own markup, e.g. change the cell background color of the data we want to indicate in some way. How to automatically count them later? If we applied a filter or these cells are within a structured table, it is enough to filter the table by color, so that we can use SUBTOTAL function to find out how many cells are colored in a certain way. Can this also be done using COUNTIF?

Excel for Human Resources

Excel is used to solve many challenges, and among other things it can also serve as a human resources management software. You will find out how to link an employee to a Personnel Data in Excel, and how to easily search them. Many of you who read my blog loved Serbian TV series “Military Academy”. In this “recipe” I used data on several actors from this series (except for names and photos, most of it is fictitious).

Word frequency

How often do repeat certain words in the given text? Which one of them is most often repeated? The answer to this question can be obtained using a few simple techniques, which will be more talk in the text that follows. To begin with, a news post is taken from the link we will analyse it to measure the frequency of words occurrence. The selected text should be copied to cell A1 of the new worksheet.

Categories and subcategories

Excel can be a good tool for filling questionnaires and for this purpose are often used structured tables where we keep the results. When the result is one of a few, in advance known, values the input is done by selecting it from the list. Sometimes there is a need to, after choosing value in the first list, affect the items that appear in the second. For example, choosing a category affects the display of related subcategories. How can we achieve this?