Do you like Visio? It is an application that essentially belongs to the Microsoft Office, but is purchased separately. I used it to draw diagrams, but the number of objects it offers indicates that it is applicable in many activities where some type of design is performed. Recently, there is an add-on that allows you to easily create Visio diagrams within an Excel document. It’s called Data Visualizer. Let’s see how it is used!
This is a function that is used to aggregate – group data from a given range, which is done by specifying a parameter that calls a specific function (SUM, AVERAGE, COUNT, MAX, MIN, etc.). We can also perform aggregation using other functions, but this one is specific in that it offers various options that allow you to ignore nested functions, hidden rows, errors …
The LET command exists in several programming languages and is used to assign values to variables. In a similar way in Excel, you can declare one or more variables, assign values to them, and define the expression in which they are used using the LET function. This is especially beneficial when there are parts within the formula that are repeated several times. The LET function, in addition to shortening the formula, also significantly affects the performance …
Icons are illustrations that we first encountered when Office 2019 appeared. Although we could find a multitude of icons, divided by categories, Office 2021 has significantly improved this segment so that now, in addition to a rich icon gallery, you can add images, transparent photos of people, stickers, or other vector images that can enhance the look of your report. Let’s see how this is used!
Sharing and collaborating on documents in the OneDrive repository is not a new feature. Still, Office 2021 has taken it to a significantly higher level. Collaboration on a document is available in most Office applications, and in this “recipe” we will focus on Excel: how to share a document, how to see what your peers are doing, and how Sheet View works – a view of a document in which you see your own changes.