“Birthday Cake” is a way of combining Stacked Column Chart, shapes and images to, with a little extra formatting, get a graphic report reminiscent of a birthday cake with candles. It can be used e.g. to show the growth of income or profit of the company over a period of several years. This kind of chart is very easy to make, so if you want to attract the attention of bosses and colleagues, pay attention and follow the steps shown.
The inventory of goods is a boring but necessary activity that must be carried out, at least once a year, by all those who deal with sales. I have written before how to make an inventory of fixed assets. The inventory of goods is done in a similar way, but this time I will show how this is achieved by applying the technique of data consolidation. Excel has had this option for at least 10 years, so I believe it will be useful for each user.
Are you overweight? Weight gain is not just an aesthetic problem, it can be the cause of many diseases, so companies conduct an annual physical examination to check the health of their employees. In this example, you will learn how to calculate BMI (Body Mass Index), a coefficient that indicates whether you are below or above the optimal body weight, and how to use conditional formatting to mark those who have unfavorable BMI.
Many years ago I worked for ECOFINANCE company where, at my time, I wrote an Excel invoicing application. It seems to me that it was quite easy to use. Partly because it was enough to enter part of the name of the code or product to find the desired item. The seller would then only select the quantity and packaging and could quickly continue to enter items until the document is completed. Today this can be achieved much easier, without any VBA programming …
In your day-to-day work, many of you copy data from a company’s business information system or some spreadsheet where they are exported to create the necessary reports. The problem arises when the data changes. How to trace where the change occurred? What is the difference between a source and a derived table? In the text that follows, you will see how to use the INDEX and MATCH functions, as well as the conditional formatting technique, to highlight the differences between the tables.