Teaching analytics with modern Excel
In a previous post we delved into the distinctions between VBA (Visual Basic for Applications) and Office Scripts for Excel: To summarize, although many Excel automation tasks can be …
Continue Reading about How to write your first Office Script for Excel →
If you've spent any time in Excel as an analyst, you're well aware of the significant amount of busywork involved. Manually adding different formats, PivotTables, removing unwanted columns, creating …
Continue Reading about How to compare Office Scripts and VBA for Excel →
pandas and openpyxlIn an earlier post I wrote about the role of Python in modern Excel and what spreadsheets users stand to gain by learning the programming language: In this post, we'll compare and contrast two …
Continue Reading about How to use Python and Excel together with pandas and openpyxl →
Special thanks to Alan at Computergaga for inspiration on this post. One of the first days at a new job, I was sitting with a coworker going over a spreadsheet. As I went to type in =SUM( to add a …
Continue Reading about Bottom Line: Customizing Excel’s Status Bar →
When exploring a workbook, I like to color-code cells so that I remember what I need to do with that information. Red cells indicate I need to take action on something, while green means all …
Continue Reading about Assign Cell Color Fills to Custom Keyboard Shortcuts in Excel →
They say a picture is worth a thousand words... so how many does an animated graph get us? This morning I was working on a research proposal presentation. Essentially, the research aims to develop a …
Continue Reading about Visualizing Movements Along a Line in Excel →
