Having full control of your papers at any moment is essential to alleviate your day-to-day duties and improve your productivity. Accomplish any objective with DocHub tools for document management and practical PDF editing. Access, adjust and save and integrate your workflows with other secure cloud storage services.
DocHub offers you lossless editing, the opportunity to work with any formatting, and securely eSign documents without the need of looking for a third-party eSignature software. Maximum benefit of the file management solutions in one place. Check out all DocHub features today with the free account.
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