Although Excel recognizes only two types of data: numbers and text, sometimes you’ll be working with Boolean values, such as TRUE and FALSE expressions. There is a simple trick to convert these values into ones and zeros respectively, so that you can add them more easily, and you will find out how to do this in a short “recipe” that follows.
More recently, Microsoft Copilot, an AI-based assistant, has become an integral part of Excel in all its versions. Now it can help you, in English or another language, analyze data, create charts, offer you the appropriate Excel function, or show you its syntax. To put a long story short, it can make your daily work much more productive!
Microsoft Copilot is a digital assistant, based on artificial intelligence (AI), or large language models (LLMs), that understands human language and can provide answers to questions: give explanations, write texts, generate images, etc. It can be used independently, within a web browser, and is also integrated into applications and services that are part of the Microsoft 365 package, such as: Word, Excel, PowerPoint, Outlook…
When we create a sales report, sometimes we want to show the values in their original form, and sometimes they can be recalculated values, such as thousands or millions. Such a report is created in a very simple way using the Data Validation option, which allows you to select the desired unit size, and recalculate values with help of the Excel LAMBDA function. Let’s create a report like this with a chart to visualize the data.
In one of the previous “recipes” we talked about how to use the Excel GROUPBY function. On that occasion, you could find out how to use it in one of the standard scenarios of its application, and now you will learn how to use it in a slightly more advanced way. To begin with, how you can group by two or more dimensions, and then how to display percentages, determine the depth of the calculation, and so on.