How to Split Data into Multiple Reports [Case Study] (Video)

by Paul Kelly | | Case Study, Vault Video

Webinar Number: W0034 In this webinar, I will be taking on a real-world Excel VBA Project. This project initially seemed like a simple task when one of my customers was trying to create it. It turned out to be much trickier than he thought so he asked for my help with...

VBA Case Study – Filtering Daily Trades (Video)

by Paul Kelly | | Case Study, Vault Video

Webinar Number: W0026 Earlier in the year, I asked for viewers to submit real-world VBA projects. In this week’s live webinar I will be building one of those projects. This application features in this webinar deals with daily trading data. The challenge is to...

VBA Case Study – Comparing Stocks (Video)

by Paul Kelly | | Case Study, Vault Video

Webinar Number: W0022 Comparing Stocks Working VersionIn this webinar, I work through a real-life Excel VBA application. One of the viewers has a list of stocks which is updated every week. They wish to use VBA code to create an application that compares the current...

VBA Case Study – A Trading Application (Video)

by Paul Kelly | | Case Study, Vault Video

Webinar Number: W0016 In this webinar, I work through a trading application sent in by a viewer. It covers setting up a framework that you can use to simulate trades. Once set up you can easily add different trading scenarios and parameters. This is done by fully...

VBA Case Study – Trophy Inventory Application (Video)

by Paul Kelly | | Case Study, Vault Video

A Trophy Inventory Application Webinar Number: W0011 On a previous webinar, I asked viewers to send in their VBA projects so I could use them as a Case Study. This webinar is the first of those case studies. I take a project sent in by Ray and work my way through it....