Loading Events

« All Events

  • This event has passed.

ImportExcel: PowerShell + Excel = Better Together! (Doug Finke)

June 16, 2021 @ 8:00 pm - 10:00 pm UTC-4

One of the most common daily tasks for an IT pro is to produce reports of company data for executives. PowerShell gives us the tools to query the data we need, but turning that data into meaningful reports can sometimes present a challenge. If you work with PowerShell and your management likes Excel spreadsheets, then you need to know about the ImportExcel module by Doug Finke!

Do you desire great looking reports, dashboards, including charts, pivot tables, filterable lists? This PowerShell module will let you do that and more. You’ll glue together data from SQL, CSV files, data from REST APIs, JSON and more to provide quality reports, providing your users’ information in one of the most ubiquitous tools, Microsoft Excel.

Plus, you don’t need to have Excel installed to make it happen.

Want to know what time this meeting is in your time zone?

Bonus demo: PSAdvantage

PSAdvantage is a GitHub Actions Automation Framework presented to you as a CLI! It leverages a powerful templating engine and the Actions REST API to perform various tasks. This enables you to make use of Continuous Integration (CI) daily for heavy time-consuming tasks to game up your productivity to the next level.

Who is Doug Finke?

Doug Finke, is a Microsoft MVP since 2009, author of the O’Reilly title “PowerShell for Developers”, builder of advanced PowerShell tools for making humans faster, more agile, and productive, and community advocate for PowerShell.

Catch up with him here:

blog: https://dfinke.github.io/
twitter: https://twitter.com/dfinke
github: https://github.com/dfinke
youtube: https://www.youtube.com/dougfinke
linkedIn: https://www.linkedin.com/in/douglasfinke

Notice of Event Recording:
We record all of our meetings and place the recordings on our YouTube channel a few days after our meetings. By attending this meeting, you agree to allow us to use any recordings of yourself for later use and posted in public forums such as YouTube and Reddit.