Generating item codes

It is a common practice in domestic retail outlets to keep a large number of items under one code. In fact, it is one item, but its additional attributes are not taken into account, such as: color, size, design, season … Consequently, the stocks are incorrect. How to form item codes in such a way that, within the code itself, all its attributes are taken into account? We will use permutations!

Rounding numbers

Rounding the numbers in Excel is done automatically. Nevertheless, there is sometimes a need to influence how the rounding is done. This is crucial when we create reports with data expressed in thousands or millions, when decimals represent significant amounts of money. We can do this by adjusting rounding based on how the number is displayed or using rounding numbers.