How to replace zeros?

How to replace zeros with empty cells? Although this question seems simple, you may find yourself in a situation where you need something like this, and you will not have the right answer. When it comes to data in Pivot tables, it is logical to define this in the options. But they allow you to determine how to treat empty values, not zeros. Zero is not an empty value. You will find out how to replace zeros, regardless of the type of table, in the “recipe” that follows…

CONVERT function

How many grams are there in one cup? How many grams fit in a tablespoon? And in a coffee spoon? This is information that until now you had to search for on the Internet, and since recently there is an Excel function that enables these and some other conversions. It is very easy to use, and if you want to know how, read this “recipe” (it cannot be converted into several smaller ones, but it is interesting)!

IMAGE function

If you use Power BI Desktop to create business reports, you probably know that it is possible to insert an image into a table that is displayed based on its URL location. As of recently, if you are a Microsoft 365 subscriber, you can also do this in Excel using the IMAGE function. In this “recipe” you will find out how it is used…

Keep or discard?

If you have used Power Query, you know that it has options that allow you to keep or discard certain columns. If you’re an Excel user coming through a Microsoft 365 subscription, there are a few new functions available to you to do a similar thing. As a result they create a dynamic array with columns or rows extracted from a given matrix that are retained or discarded.

Merging arrays

If you work with a table in which there are several arrays, such as city names or sales values in them, until now you could only combine them by copying and pasting to the desired position in the worksheet. As of a few weeks ago, if you are a Microsoft 365 subscriber, you can also use two functions for working with dynamic arrays: VSTACK and HSTACK. They allow merging arrays which contributes to easier preparation of data for reporting.