Analytics & AI for Modern Excel
Have you ever used an Excel add-in? There are lots of awesome Excel add-ins. My favorite is Jon Acampora's Pivot Pal add-in. At its most basic, Excel add-ins are programs that augment the …
Continue Reading about R Packages Explained for Excel Users →
Never listen to the Excel haters -- it's not going anywhere. Choosing to use R "instead of" Excel is like naming a favorite child! Each has its advantages, and a savvy analyst is able to use them in …
Continue Reading about Generating Unique Random Numbers in R For Excel →
I've picked up an unusual habit lately -- when I am about to make a programming-related internet search, I open a private tab in my browser. What am I up to? Just trying to keep my cool. You see, …
Continue Reading about Out of the Hot Seat: Reimagining Code Forums →
"Hey, George. We have this spreadsheet we use to create our financial models. It is really complex. Some nights when we need to get projections to the CFO the model breaks and we are here until …
Continue Reading about Review: Financial Modeling in Excel for Dummies →
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 →
The blog has been quiet lately because I've been busy learning R and Python to complete a research project. And I've been missing Excel. But today I found a nice diversion. A Python Magic 8 …
