When you want to display data that contains multiple separated series in a chart, it can often look clumsy. It is possible to tolerate presentation of three or four series, but anything more than that is a nightmare for those who watch the reports and need to draw a certain conclusion. The solution is to display several smaller, separate charts instead of one. This type of data presentation is called small multiples, and here’s how to achieve it in Excel reports.
When you enter phone numbers in a cell, you must enter them as text which means that you should add an apostrophe before entering the number. In this case, it is best to enter the number in international format. If you don’t want to think about codes and calling numbers, you can retrieve this data from the auxiliary records, and then join them with the help of the TEXTJOIN function. You will find out how to enter email addresses and phone numbers in the following text.
How to count words? There is no longer a need to send telegrams, and the need to count words seldom arises. However, this is a nice opportunity to try out how to use the TEXTSPLIT function in combination with some other Excel functions. Who knows, maybe this will be useful to you one day? In honor of Pink Floyd, let’s count the words in the song “Shine On You Crazy Diamond”.
Microsoft Copilot is a chatbot, based on ChatGPT, and is integrated within many Microsoft services and applications. If you use it in Power BI Desktop reporting platform, it enables you to create quick measures and to generate DAX statements based on natural language. With Microsoft Copilot, creating measures has become much simpler, and you will find out how it is used in the “recipe” that follows.
Arranging data sets in Excel reports can sometimes get complicated, for example when you are editing a list of visitors to your stand at a business fair or congress. Then we usually manually copy the lists, merge them, and further remove duplicates. Excel has some new functions that allow you to literally do this procedure in a couple of steps, and in the following “recipe” you will find out how to apply them in practice.