Power Query and Power Automate both aim to streamline Excel workflows and simplify data manipulation, yet they serve unique purposes and tackle distinct challenges in the battle against slow, …
How to write your first Office Script for 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 →
How to compare Office Scripts and VBA 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 →
How to format a column as percentage in Excel using openpyxl
Excel's popularity is attributed to its user-friendly data formatting and presentation features. Although Python offers distinct advantages for Excel, its raw data output is often unsuitable for …
Continue Reading about How to format a column as percentage in Excel using openpyxl →
How to understand the relationship between pandas, openpyxl and Power Query
In an earlier post I provided an overview of how to use the pandas and openpyxl packages together to automate the production of Excel workbooks. In that post, I likened pandas as the "Power Query of …
Continue Reading about How to understand the relationship between pandas, openpyxl and Power Query →
Renaming all files in a folder in R
I hate the way files are run in a camera. While it was cool to learn for this post that DSCN stands for "Digital Still Capture - Nikon," it means nothing to me! For this post, I will be renaming the …
Continue Reading about Renaming all files in a folder in R →