PowerShell+ 2019 - Look smarter: deliver your work in Excel by James O'Neill

PowerShell is the go-to tool for getting information - particularly about IT systems that we manage. But presenting that information isn't always easy. But there is a module which reads and writes Excel files from PowerShell. Being able to chart resource usage helps us to see resource hogs. Being able to highlight differences in system configuration can help troubleshooting. A well presented report showing key aspects of system state helps other people in the organization to understand the work that has been done. The module allows people who naturally work in Excel to provide input in Excel format for a task that is carried out in PowerShell. This session introduces the module, explains its background and will concentrate on real world examples of how it is being used as a key tool in Dev-Ops environments, from auditing system state, to collecting the results of Pester tests, to highlighting possible configuration errors. PowerShell Summit videos are recorded on a "best effort" basis. We use a room mic to capture as much room audio as possible, with an emphasis on capturing the speaker. Our recordings are made in a way that minimizes overhead for our speakers and interruptions to our live audience. These recordings are meant to preserve the presentations' information for posterity, and are not intended to be a substitute for attending the Summit in person. These recordings are not intended as professional video training products. We hope you find these videos useful - the equipment used to record these was purchased using generous donations from members of the PowerShell community.