In an old cartoon was promoted a saying: “Cats and mice can be friends”. Consequently, Excel and Power BI can also be friends! Power BI allows you to import Excel reports, whether traditional, Pivot or Power Pivot reports. This is not a whole new topic, but I think it would be nice to remember it in a new light, with an emphasis on what you can do for free and when you definitely have to buy licenses.
Comments in Excel are not new option. Nevertheless, from the version to the version, there was more and more work to improve the possibility of collaborative work on the documents. Consequently, Excel has a new type of comment. They refer to commenting on shared documents, which in most cases are on the OneDrive repository, and you can view them in a simple way: by clicking the Comments button in the upper right corner of the window.
Newer versions of Excel no longer support the document sharing option I have written in one of the earlier texts. It can still be used after manually adding to the quick menu or toolbar, but collaborating on documents has evolved into co-authoring. This means that the documents are saved on the OneDrive repository, and that the right-hand users can change them at the same time.
In a previous post I talked about the history and gave brief introductory remarks regarding PowerBI service and its “tastes” (PowerBI, PowerBI Desktop, PowerBI Mobile). In the text that follows you will see how to apply on PowerBI service and import data from a desired source. We will connect to data table, taken from ERP solution, and connect to the data you will later use to create the report. Concentrate, the magic begins!
Anyone who has elementary computer literacy can open a document, whether it’s Excel or some other file. Excel 2013 brought several novelties that, even in doing this simple operation, make daily work easier. These are options for creating shortcuts to the most frequently used documents in the menu and opening a copy of an existing document. More detailed, in the text that follows …