I download an excel file every week and make changes like deleting columns, counting and adding rows and so on. Can I automate this repetitive task ? In this post, I'll attempt to answer this question. The built-in Excel feature we'll use to accomplish this is Power Query. If you haven't used Power Query inside of Excel before, don't worry, I'll walk you though the steps. www.excel-university.com/automate-file-cleanup/