Getting complete power over your papers at any moment is important to relieve your everyday duties and increase your efficiency. Achieve any objective with DocHub features for papers management and hassle-free PDF editing. Access, adjust and save and incorporate your workflows along with other safe cloud storage services.
DocHub provides you with lossless editing, the chance to use any format, and safely eSign papers without searching for a third-party eSignature software. Get the most from the document managing solutions in one place. Consider all DocHub functions right now with your free of charge 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