Having comprehensive power over your documents at any moment is crucial to alleviate your day-to-day tasks and improve your productivity. Accomplish any goal with DocHub features for papers management and convenient PDF editing. Gain access, adjust and save and incorporate your workflows with other safe cloud storage services.
DocHub gives you lossless editing, the possibility to work with any formatting, and safely eSign papers without the need of searching for a third-party eSignature alternative. Make the most from the file management solutions in one place. Check out all DocHub capabilities today with the free of charge profile.
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