Export of documents
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.
You are done editing and want to export the document as a PDF. It’s easy! Click on the File tab to enter the Backstage view, then go to the Export menu. The first submenu contains only one option: Create PDF/XPS. By activating it, we create a PDF document. Another submenu is called Change File Type. It contains several options by which we can create a template, save a document that will work on older versions of Excel, as ODT, CSS, TXT or some other file type.
Backstage view contains another menu named Publish. It allows you to publish reports to the Power BI service, and to do this you need to have a (commercial) One Drive For Business account and then further you can publish document directly to Power BI.