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.
Sometimes it is necessary to open two Excel files and perform a comparative review. This can be done in several ways but one of the most effective is by using the View Side By Side option. In the text that follows, you will see how this option is used, and as an example, we will take two files containing lists of employees with the value of their salaries in two comparative years.
Since March 2018, PowerBI Desktop has several new options for viewing and editing reports. First, there is an option to highlight one visual in relation to others, which is in its context menu. And then, there are a few more options that allow you to capture your favorite report views, view and manage objects in a report, lock objects, show field properties, and a set way to synchronize slicers…
Data entry in large tables can be complicated, first of all because, by adding new rows, the header disappears from the screen. Therefore, we are not sure in which column we enter which data, so the work is much slower. “Freezing” rows or columns is a technique by which we fix one or more rows or columns so that they always appear on the screen. At the same time, we can continue to fill in the data of new rows and/or columns with a clear idea of where we need to enter.
Depending on what we want to acomplish it is possible to use several different views on the worksheet. These views make it easier to get into large tables or to adjust the appearance of the work environment in accordance with our own desires. In this way, Excel can be configured to resemble more like a data entry form or print preparation software. Personally, when preparing to print a document, I often use the Page Layout view, and in the text that follows, you will see and why!