Getting complete control over your papers at any moment is crucial to relieve your everyday duties and boost your productivity. Achieve any objective with DocHub tools for document management and convenient PDF editing. Gain access, modify and save and integrate your workflows along with other protected cloud storage.
DocHub provides you with lossless editing, the chance to work with any format, and safely eSign documents without looking for a third-party eSignature alternative. Get the most from the file managing solutions in one place. Check out all DocHub features today with your 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