Excel

Automation with Complex, Pre-Formatted Excel Templates by Robert Walker

I recently had the pleasure of automating a reporting system for a client that required the use of an existing complex and pre-formatted Excel template with specific page breaks, merged cells, borders, and more.  Here I describe how I was able to use Python and Excel together while maintaining the original template structure and formatting.

Read More

Time-Series PivotCharts with Dynamic Date-Axis by Robert Walker

Using PivotCharts in Excel is a powerful analysis, automation, and visualization tool - however, they are lacking when it comes to Time-Series charts and require a bit of trickery to work as expected.  Here I describe some of those tricks and provide a working example of how to make dynamic time-series PivotCharts.

Read More

How to Quickly Create Time-Series PivotCharts by Robert Walker

Time-Series charts are a staple data visualization tool in many industries.  Creating easy to manipulate time-series charts has been done for a while online (i.e., Plotly.js, Tableau), many clients require their data to stay "local" - either Excel or a secured database - nothing online or 3rd party.  That's where Excel PivotCharts can fill the gap.  This tutorial will show you how to accurately present time-series data using a PivotChart.

Read More

Microsoft Professional Program Certificate in Data Science by Robert Walker

I'm happy to announce that I've completed the Microsoft Professional Program Certificate in Data Science!  After six-months of courses capped off by a challenging machine learning problem issued by Microsoft data scientists, I've learned a lot and am excited to use my new skills.  As proof of my accomplishment Microsoft has issued this official certificate!