OneNote is used to take notes. It comes as a free desktop app with Windows, but also as part of the Microsoft 365 suite or a web service. Notes are captured in notebooks, and each of them can have multiple sections and parts. In notes, we can write down text, keep To Do lists, add images, video or audio recordings, links… Notebooks are stored as documents in the OneDrive repository, which means that notes can be easily accessed from any device.
We often come across Excel documents that have multiple reports found in several worksheets. If you want to find the report you want, click on the tab with the name of the corresponding worksheet. However, this is not always the optimal solution. In order to facilitate positioning on the desired report, we introduce links that we have attached to certain forms. That is, we introduce a navigation panel to navigate within the document.
When you start using Excel business intelligence tools you’ll realize that they enable connecting with data from multiple sources. This can be an Excel spreadsheet or text files, databases, data from the Internet, data warehouse “in the cloud” … If you have ever used MS Access, you will easily understand how to add and link tables within the model. If not, read this article and you will see that it is easy and quite intuitive task.