We meet the hyperlinks every day while surfing the Internet, and they have long time ago become part of Office applications. In Excel, this is often an unfairly ignored functionality. In addition to allowing you to go to an Internet presentation or write a letter to the specified e-mail address, a link can also be used to create a new document or position it on a prefix in an existing document.
When making reports, multiple Excel documents are often used. As you know, data in another worksheet or other document, if it is open, we can easily access by specifying the absolute address of a cell or cell range. But what if we want to access a closed document? And can Excel be used as a data repository? About the link to other Excel files more in the text that follows.
Excel is a software with lots of features, but perhaps its best application is data analysis. In order to have something to analyze, we must retrieve the data. Operational data are held in relational databases, so we should connect to DBMS. Most of the time it is and istance of Microsoft SQL Server. When connecting we’ll importing a content of a table, view or result of a query into Excel worksheet.
Macros represent short programs that the user mostly does not write, but are automatically generated by Excel. Their role is to automate frequently used procedures, and more ambitious users can use them to develop applications with the powerful Visual Basic for Applications (VBA) programming language. In this way there are almost no things that can’t be done in Excel, so it becomes a development platform.
Importing a table from the Internet is a useful Excel option that came at the wrong time. Sometimes, when web designers created pages using the TABLE structure, the tabular data was in the tables (where they should be). Today, the approach to making web sites has changed, so DIV tags are used to display tabular data, which for some reason can not be recognized by Excel. Hence this option has limited application capability.