Register for Semperis' Hybrid Identity Protection (HIP) Conference - June 30 - July 1 Register for Semperis' Hybrid Identity Protection (HIP) Conference - June 30 - July 1
Office|Office 365

Microsoft’s New Excel Feature Will Automate All Your Redundant Tasks

Excel Automate hero

It has been a big year for Excel, first Microsoft introduced xLookup and now the company is bringing another new, and long overdue, feature to the spreadsheet application. Microsoft announced at Ignite 2019 that scripting support is coming to the application.

But this isn’t a text-heavy, syntax specific, scripting, this feature allows you to record your actions and turn them into a script. This script can then be integrated with Power Automate and be scheduled to run automatically or integrated with a larger flow.

For those that live in spreadsheets but never quite figured out how to write their own macros, this feature is going to make your tasks significantly easier. For example, if you have a weekly or month-end report that always needs to be transposed or formatted a certain way, with this new scripting feature, you can record the steps, play it back when the next week or monthly report arrives, and save yourself a lot of time.

While Microsoft has added many features to its productivity suite over the years, this may be one of my favorite additions. Not only is it going to save a lot of time but it will be easy enough to use that everyone from power users to novices can gain value from the function.

Unfortunately, you can’t quite get your hands on the tool yet. The feature will arrive in public preview later this year but thankfully, that’s less than two months away.

Related Topics:


Don't have a login but want to join the conversation? Sign up for a Petri Account

Comments (0)

Leave a Reply

Brad Sams has more than a decade of writing and publishing experience under his belt including helping to establish new and seasoned publications From breaking news about upcoming Microsoft products to telling the story of how a billion dollar brand was birthed in his book, Beneath a Surface, Brad is a well-rounded journalist who has established himself as a trusted name in the industry.

Register for the Hybrid Identity Protection (HIP) Europe Conference!

Hybrid Identity Protection (HIP) Europe 2021 - Virtual Conference

Mobile workforces, cloud applications, and digitalization are changing every aspect of the modern enterprise. And with radical transformation come new business risks. Hybrid Identity Protection (HIP) is the premier educational forum for identity-centric practitioners. At the inaugural HIP Europe, join your local IAM experts and Microsoft MVPs to learn all the latest from the Hybrid Identity world.