Your spreadsheet expertise is a secret tech superpower.

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 ...

Before it took over her life, Leila Gharani mostly took Microsoft Excel for granted. She was working on a process optimization project for a large paper-products manufacturer—a job that, to hear her ...

VBA based but will work on non-macro workbooks if you save it to your Personal workbook (see below). This works by replacing the colour definitions for styles already defined in the workbook (rather ...

Custom pharmacy functions enabling a user to calculate patient metrics, lab values, and drug dosing. With the Pharmacy Function Library, you can perform commonly used clinical pharmacy calculations.