Overview
Explore how to automate Excel tasks using Jupyter Notebooks and PowerShell in this conference talk from PASS Data Community Summit. Learn to create self-service solutions for users to generate Excel workbooks efficiently. Discover the power of combining Jupyter Notebooks, PowerShell, and the ImportExcel module to streamline common requests for Excel-based information. Gain insights into implementing run-books and automating regular tasks, drawing from real-world client experiences. Master tactics for empowering users to create their own Excel workbooks through automation, enhancing productivity and data management processes.
Syllabus
Notebooks, PowerShell, and Excel Automation - Rob Sewell
Taught by
PASS Data Community Summit