Traditional Excel has only two data types: text and numbers. All others (date, time, percentage, etc.) are specially formatted numbers. In the second half of 2019, Microsoft added new data types to Excel: Geography and Stocks. First, for a given term, offers an abundance of geographical determinants while the second provides data on stock market. A lot of new types have been announced, and since recently users of Microsoft 365 subscriptions can create custom data types.
From the very beginning, Power BI allows us to import Excel workbooks in two ways: as a data source or as a report. This second option is useful when we already have ready-made reports that we want to use in parallel with Power BI reports. Recently, within the Microsoft 365 subscription, the Publish to Power BI option has appeared, which enables direct publishing of reports on the Power BI service. How does this work?
Exporting a table to PDF is not a new feature, it has been around for ten years or more. But how to import a table from a PDF document into Excel? This task is performed by Power Query which, since the latest version, has become an integral part of Excel and you can’t bypass it, no matter what kind of data you import into the application. Since recently he has this fantastic option, let’s see how it is used …
Microsoft Teams allows you to easily access additional applications from the main menu – cloud services and connectors that you will use in your daily work. There are a handful of useful applications, organized by categories, which improve the functionality of Teams such as: Forms, Shifts, Approvals, Stream, Power BI, One Note and many others …
The backbone of the Microsoft Teams service are teams and channels, which means participants in communication and places where information and files are exchanged and work is being done on joint projects. This text will describe the theoretical settings and basic principles of working with teams and channels, and in some of the following you will have the opportunity to get acquainted with the practical details.