Microsoft Excel VBA Tutorials

Need to impress your boss? Learn how to increase your analysis productivity by learning Excel Visual Basic for Applications. Each tutorial comes with a downloadable Excel workbook and a script of the VBA code from the video.

Featured Tutorial: Create a Summary Report from Raw Data (HD)

Featured Blog Posts

The Steve Nash/Paleo Diet Debate

Read my thoughts on Steve Nash’s diet and the comparison to the Paleo Diet (“Caveman” diet). What is a Paleo Diet? How does Steve Nash’s compare? I also debate the scientific vs. the practical implications.

Become an Overconfident Sucker with Fidelity’s Green Line

The marketing efforts of fidelity strike a chord with me and cause a rant about the abilities of any individual investor and how financial institutions are doing a dis-service to the public by making it look easy to trade securities.

Latest Book Review – Moonwalking with Einstein

In my latest book review, Joshua Foer takes us inside the World Memory Championships and asks the question: Is a great
memory a matter of practice or innate ability? Foer attempts to answer the question by training and competing in the U.S. Memory Championships. He must complete seamingly super-human feats like memorizing the order of a deck of cards in under a minute.