We are accustomed, when we want to change the type of Excel document, to save it under another name. However, in some recent versions of Excel, this operation is further facilitated. If we enter the Backstage view there we will find the Export menu that allows you to export directly to PDF or change the file type. Also, you can also directly add documents to Power BI.
One of the phases of the project for the implementation of ERP information systems is retrieving data. These can be master data (partners, contacts, pricelists, etc.) or financial data. Most of them are retrieved from the company’s old information system, which is often exported as TXT or CSV files. Excel has a mechanism for retrieving entire files and manipulating data, which will be discussed in the text that follows …
Although Excel is the best software to work with tables, we often create them in other software. Also, tables are commonly used for data exchange, when they are exported as tables in a text file as “Comma Separated Values”. In this file, each row of the table is a separate line in the text, and the values that are in the columns are separated by commas (hence the name). In the text that follows, we will show how to import text from one such file …