Pivot tables are a report that has existed in Excel for a very long time, and it allows us to look at a source dataset from different angles, as well as to easily change views on the data. Despite the fact that this is a very useful report, many people still do not know how to use pivot tables. That’s why Microsoft recently added an option in Excel by which, based on the selected data, it can recommend you what kind of pivot table to create.
Microsoft is constantly working to improve the user experience and make everyday work in Excel easier. A few years ago, the „Tell me what you want to do“ option appeared, and later its functionality was integrated into the Search field, which you can still see in the title bar of any Excel document. Search is now part of the context menu, and browsing Excel features is even easier than before…
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)!
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…
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.