Rob Sewell

Information & Communications Technology

PowerShell Azure DevOps Azure Arc Data Services Azure Bicep Bicep Infrastructure as Code

Exeter, England, United Kingdom

Notebooks, PowerShell and Excel Automation

Everyone loves Excel. A common request that I hear is can you put that into Excel for me, please. I love automation and so have combined two of my favourite tools PowerShell and Notebooks. Using Jupyter Notebooks to accomplish regular tasks and run-books has become common over the past year.

A particular use-case that my clients have found very useful is to quickly create Excel sheets of information using Notebooks, PowerShell, and the ImportExcel module.

Let me share my experience with you and show you how to create your own Notebooks for your users and the tactics I have learned to enable users to self-service and create their own Excel Workbooks.


Rob Sewell

Be-Whiskered Maker of Things

Rob was a SQL Server DBA with a passion for PowerShell, Azure, Automation, and SQL (PaaS geddit?). Now he just helps people make things. He is a Cloud and Data Center MVP and a Data Platform MVP, co-leader of Data South West UK User Group and PSConf EU organiser and has spoken at and volunteered at many Data and PowerShell events all over the world. He is a proud supporter of the Data and PowerShell communities.

He relishes sharing and learning and can be found doing both via Twitter and his blog. He spends most of his time looking at a screen and loves to solve problems. He knows that looking at a screen so much is bad for him because his wife tells him so. Thus, he is often out riding his bike as his eyes are not good enough to play cricket any more

He has a fabulous beard

Rob's full speaker profile