News

Basically I was looking for a way to automate a way of using the version control offered by Git/Github with Excel files and the VBA code modules stored within an Excel file. I'm a heavy user of VBA in ...
Converts proprietary sas7bdat and/or xport files from SAS into formats such as csv, json, and Excel useable by other programs. Currently supported conversiaions are csv, Excel (xlsx format), json, ...
Learn how to combine Excel files with different sheet names using Power Query. Save time, reduce errors, and automate your ...
Python hacks to automate tasks, clean data, and perform advanced analytics in Excel. Boost productivity effortlessly in day ...