Custom Lists

Often we fill out tables with data that are meaningful strings. This can be for example the days of the week, the names of months, and so on. Therefore, it would be convenient to have automation using just enough to enter only the first member of the string, for example, “MONDAY”, and when applying a fill-in technique to Excel, automatically fill in the other several selected fields with the names of the remaining days of the week. This automatics are the Custom Lists and will be referred to in the following text.

Sorting data

When we enter data in a table, we often need to edit them in a ascending or descending order. In other words, sorting them. Excel offers quick sorting, according to the content of the first column in the table, as well as advanced sorting where it is possible to set several criteria and select multiple sorting methods. The following text will detail the sorting of data, and I’m sure you will learn something new.