Get Real-Time Cryptocurrency Prices from Yahoo! Finance to Excel

I’ve been a casual student and advocate of cryptocurrencies since ca. 2014, but recent news has attracted me (along with everyone else and their Uber driver) to them more seriously. Subscribe to my newsletter for your free ebook, “The Beginner’s Guide to Getting Hired with Excel.” This afternoon, I wanted to find a way to […]

Review of Sensemaking. (What Makes a Good Analyst? Hint: Not Just Excel.)

An old professor of mine used to quip that, for proof of the permanent income hypothesis, observe how engineering majors often drive nicer cars than philosophy majors. May it be because, he jested, the top five engineering firms are hiring at more competitive salaries than the top five philosophy firms?   Christian Madsbjerg’s Sensemaking: The […]

So Long as There’s Small Business, There Will Be Small Data (and Excel)

This week, with a little time off between semesters, I’ve been helping a family member with financial reporting & analysis for his business. It’s been over a year since I worked in finance and this exercise reminds me how frustrating this can be and how critical a strong command of Excel is to modern data […]

Grouping PivotTable Data by Week

I must admit, my Excel use has declined significantly since returning to school full-time. But, I still find plenty of uses – and, because they are not my routine office tasks, sometimes they are more interesting and I have more to write about. This one comes from a project I am helping a family member […]

R Explained for Excel Users: What is a Data Frame?

Like in Excel, data in R comes in different shapes and sizes. In Excel, there are cells, ranges, worksheets and so forth. R does things a bit differently. Ultimately, these difference come down to the use of a vector as its information building block.  Picture a table in Excel. If you know how to design […]