“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 ratiosfilter 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.

About Samir Abid | Your Data Driven