Q. I noticed there is a new tab in my Excel 365 called Automate. What does this do? A. There is an Automate tab available in Microsoft 365, Excel for Microsoft 365 for Mac, and Excel for the web. The ...

The desktop version of Microsoft Excel will soon support a handy task automation feature previously only available to users of the web application, it has been revealed. “With this update, you can now ...

Have you ever wished Excel could do more than crunch numbers and organize data? Imagine generating polished PDFs or sending out personalized emails—directly from your spreadsheet—without needing to ...

What if you could eliminate the tedious, repetitive tasks in Excel that eat away at your productivity? Imagine a world where your spreadsheets update themselves, reports are generated and emailed ...

We're going to build off my previous series to show how to further the communication channel between Excel and PowerShell. In a recent series of posts, I explained how to launch a PowerShell script ...

Microsoft has restarted its monthly feature round-up, detailing how Excel changed during January 2026 across Windows, Mac, and the web. The headline upgrade is Agent ...

I have a set of spreadsheets where the data (text) is color-coded by row. Would it be feasible to write a formula or script to count how many of what color rows are spread across the workbooks in my ...

Microsoft is considering adding Python as one of the official Excel scripting languages, according to a topic on Excel's feedback hub opened last month. Since it was opened, the topic has become the ...

In this video, we explore 10 essential Excel skills for the Modern Analyst to elevate Excel from a basic spreadsheet to a robust analytics tool. Key topics covered include: - Importing live web data ...