Sometimes plunging in headfirst and barehanded is just the most efficient way to nab the nuisance lizard, says Mike Kimmel, ...

Excel Anonymizer is a python script that helps to ensure sensitive data is properly managed and governed. It provides fast identification and anonymization for private entities in text such as credit ...

Excelbind is a free open-source Excel Add-in, that expose your python code to Excel users in an easy and userfriendly way. Excelbind uses the Excel xll api together with an embedded python interpreter ...

Excel comes prepackaged with the VBA programming language. VBA is a straightforward programming language. A natural first step to learning VBA and coding in general is to rebuild models that are in ...

This week we cover dplyr, the grammar of data. Dplyr is complicated at first but the payoff is worth the effort. dplyr allows for easy manipulation of data and easy to read code. It can be combined ...

Programming-by-Examples (PBE) involves synthesizing an intended program from a small set of user-provided input-output examples. A key PBE strategy has been to restrict the search to a carefully ...