“That analysis software is rubbish. How can I get this into Excel?” You say … yet again!!!
Excel VBA For Motorsports
Confident with Excel? This Excel VBA for motorsports course will enable you to level-up. Yes, Excel is a dinosaur but it is everywhere! Learn 70-80% of all the Excel VBA you will ever need!
1.5hrs of lessons – 4 Parts – 33 Videos -example workbooks + handouts included.
Price Ā£49.95 FREE š
Yes spreadsheets, Excel and specifically the Visual Basic for Applications [VBA] language are dinosaurs. However they remain wildly popular in motorsports.
In motorsports, the need for calculations pops up everywhere. You might want to work out your ideal gear ratios, filter some noisy data or simply add up your expenses! š¬
What you need are robustly calculated solutions that are accurate, flexible and easy to update – and you want them quickly!
You might be the go-to person for all things spreadsheets. The very best person you know at Excel – but how can you take the next step?
Excel is your adjustable spanner for anything that requires more than a calculator …
You know Excel can do more. You have tried. You’ve got stuck. Then you’ve lost hours (and hours!) of your life trying to rephrase your issue to get a decent answer from Google … š¤·āāļø
Unfortunately, what you might have found when getting more ambitious is that your data can quickly overwhelm the spreadsheet.
With motorsports data logs especially, you might be dealing with thousands of rows of data. Once you start adding cell calculations for every row, multiple tabs of data, charts, formatting, lookups etc, your sheet will become slow and cumbersome.
VBA To Your Rescue!
With a little VBA code you can transform your spreadsheet life.
You might have heard about Excel VBA. You might have even recorded a few marcos.
What you want now, is to get more understanding and more control over your code.
You want to be clear what is really going on under-the-hood – and waste less time getting stuck …
You might even have been given someone else’s Excel sheet to unpick – and have no idea where to start.
It is well worth you investing your time to learn more about what Excel VBA can do for you.
Excel VBA For Motorsports
With over 1.5 hours of video lessons this course will quickly give you a zero BS grounding in how to use Excel VBA.
I say it is Excel VBA For Motorsports but the course deliberately focuses on simple calculations – the challenge of adding up a column of numbers!
Keeping the calculation part simple reduces your distractions.
By the end of this course, you will know 70-80% of all the fundamental things you need to learn in Excel VBA.
Within a couple of days you will rapidly be up to speed and putting your new knowledge to good use.
STOP wasting anymore of your life aimlessly searching Google!!
Good luck š
What’s included?
Lifetime Access. Lifetime Updates.
Access Anywhere. Optimised For Mobile & Tablets.
1.5hrs of lessons – 4 parts – 33 videos – 2 files – 5 text files
Contents
Introduction
Introductory video to Excel VBA course – 8mins
Introductory slide handouts
Course Answers [Excel Spreadsheet]
Part 1 – Laying Your Foundations
Introduction – Part 1
Welcome To Part 1 Video – 3mins
Environment Setup – 3mins
Subroutines – 3mins
Sheet IO – 3mins
Sheet IO Example – 5mins
Sheet IO Example Part 2 – 4mins
Message Box Introduction – 2mins
Introduction to Dimensions – 4mins
More With Dimensions – 5mins
Conclusion of Part 1 – 1min
Part 2 – The For Loop
Introduction – Part 2
Welcome To Part 2 Video – 1min
The Double Dimension – 3mins
Option Explicit – 3mins
Another Types of Cell Reference – 2mins
Introduction To The For Loop – 4mins
More For Loop – 2mins
Debug.Print – 3mins
Conclusion of Part 2 – 2mins
Part 3 – Hooray For Arrays!
Introduction – Part 3
Welcome To Part 3 Video – 2mins
Introduction To Arrays – 8mins
More Arrays – 4mins
Top Tip – How To See Inside An Array – 3mins
Finding The Last Row – 4mins
Array Debugging – 4mins
More Sophistication With UBound & LBound – 2mins
Better Sheet Referencing – 3mins
Conclusion of Part 3 – 2mins
Part 4 – Performance & Summary & Next Steps
Introduction – Part 4
Welcome To Part 4 Video – 2mins
Performance Analysis Using Timer – 2mins
IF Statements – At Last! – 3mins
Performance Improvement With ScreenUpdating – 3mins
Conclusion of Part 4 + Your Next Steps – 4mins
Final Thoughts & Links
About Your Instructor – Samir Abid
Hi š, Iām Samir Abid. Iām an engineer from Warwick, UK. I must have used Excel every week for at least the last 20 years! My work has involved building sophisticated analysis and reporting tools for world leading sports teams.
VBA was something I was able to self teach myself, but it took months and months. This is the course I wish I’d had access too when I first started using VBA. Yes Excel is old but it has been old for 20 years! Knowing VBA gives me confidence to build anything in Excel. In a couple of days that will soon be you.
