Teaching analytics with modern Excel
Eager to learn something new over the holiday weekend, I checked my email for the latest from the business analytics blogosphere. I was quite disappointed to find posts of this nature: VLOOKUP …
Continue Reading about R vs Excel? VLOOKUP vs INDEX/MATCH? Enough with the False Dichotomies! →
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 →
