Tag Archives: automation

Dear Analyst #57: Automating weekly reports, working with stakeholders, and data definitions with Nadja Jury of Education Perfect

One of the best feelings is knowing you’ve streamlined and automated a report such that your colleague doesn’t have to spend hours creating the report every week. Whether you automate the report through a bunch of Excel formulas or setting up some sort of data pipeline, analysts are always thinking about driving internal efficiencies. This […]

Why You Should Stop Doing Manual Spreadsheet Work

Copying and pasting from one cell to another? Sorting through data trying to find the signal from the noise? Up-level this and go through your entire day when you’re sitting at your desk doing “work.” Creating calendar invites, copying and pasting from Excel into PowerPoint, formatting a spreadsheet until it’s perfect. These are things people generally consider to […]

Join our community of 5,000+ Excel and data analysis enthusiasts!

  • Learn Excel techniques and shortcuts
  • Episode updates from the Dear Analyst podcast about Excel
  • Updates on online and offline data workshops

Enter your e-mail and hit the blue button!