Whether you work with paperwork daily or only occasionally need them, DocHub is here to assist you make the most of your document-based projects. This tool can change URL in Sales Report, facilitate collaboration in teams and generate fillable forms and valid eSignatures. And even better, every record is kept safe with the highest safety requirements.
With DocHub, you can get these features from any location and using any device.
hello welcome to my short demonstration on using power query to automate gathering data from different sources and especially for daily reports weekly report on monthly reports okay so Im going to demonstrate using a report for a fictitious pizza company and this is the scenario every every day I do a daily report and the daily reports involves getting data from different branches okay so the first step is to make sure that you have a dedicated folder like as I have yet a folder called sales report you can call it whatever you like and then make sure its under the data the sauce details that are going data files that are going to be in that in that folder so currently I get it up from about 9:00 yeah exactly nine branches and every day every day I get this data right so I make sure I put the data in this folder and then you go into excel data menu its part of the features of power query but in 2016 its been fused natively into Excel and called get and transform so what if I use in