i stopped manually updating reports every day
used to open the same file every morning, clean it, remove a few columns, fix dates, build the same summary… every single day. got tired of it and finally used power query. just loaded the file once, did all the cleaning steps there, clicked close & load. now whenever i get a new file with the same structure, i just hit refresh and everything updates instantly. no formulas, no dragging, nothing. took like 10 minutes to set up and probably saved me hours already. honestly feels like cheating a bit.