Office Scripts and Power Automate | Mark Proctor

Wouldn’t it be amazing to turn hours of work into a single mouse click?

Historically, VBA was the tool used to achieve automation in Excel. Then Power Query and Power Pivot came along, giving us new ways to automate. But things didn’t stop there, we now have Office Scripts, Power BI connected data sets, and Power Automate.

In this session, we will look at the tools we can use to automate our processes. And along the way, discover we can reduce the one-click dream by one more click.

---------------------

About the Speaker: Mark Proctor

Mark is a qualified accountant who has been applying spreadsheet-based solutions to solve real-world problems for the last 20 years. Whilst working in the media, food, retail, and manufacturing sectors, he built extensive dashboard, reporting, and process automation tools, to achieve greater business insight and efficiency.

More recently, he has focused on Microsoft’s “Power” tools (Power Automate, Power BI, Power Query, and Power Pivot) which are now widely available but massively underutilized by most businesses.

Mark is also the owner of Excel Off the Grid (https://exceloffthegrid.com) which started in October 2016. The site focuses on teaching intermediate and advanced Excel techniques so that workplace warriors can become more efficient in Excel.

Find more about Mark's work and connect with him:
LinkedIn: https://www.linkedin.com/in/markstephenproctor
Website: https://exceloffthegrid.com
Twitter: https://twitter.com/exceloffthegrid
YouTube: https://www.youtube.com/c/exceloffthegrid

---------------------
AGENDA: (Eastern Time)

5:30 PM - 5:40 PM- Introduction
5:40 PM - 6:40 PM - " Office Scripts and Power Automate " by Mark Proctor
6:40 PM - 7:00 PM - Q&A + Closing by Celia Alves and MS Excel Toronto Team

We are looking forward to meeting you there!