“That analysis software is so restrictive. How can I get this into Excel?”… You say … again!!!
Excel VBA For Motorsports
Upgrade your Excel skills with Excel VBA For Motorsports, the ultimate course for Excel enthusiasts. In just 1.5 hours, learn 70-80% of all the Excel VBA you’ll ever need and take your skills to the next level with VBA. Get accurate and flexible solutions to your motorsports calculations, and stop wasting time searching Google.
1.5hrs of lessons – 4 Parts – 33 Videos -example workbooks + handouts included.
Price £49.95
Do you find yourself frustrated with analysis software and wishing you could get your calculations into Excel? Are you a motorsports enthusiast who wants to level-up your Excel skills? Look no further than Excel VBA For Motorsports!
Learn 70-80% of All the Excel VBA You’ll Ever Need in Just 1.5 Hours!
Excel may be a dinosaur, but it remains wildly popular in motorsports. With the need for calculations popping up everywhere, it’s essential to have robust and accurate solutions that are flexible and easy to update. This course will teach you 70-80% of all the Excel VBA you’ll ever need in just 1.5 hours of video lessons, divided into four parts with 33 videos, example workbooks, and handouts included.
Take Your Excel Skills to the Next Level with VBA
You may already be a go-to person for all things spreadsheets, but it’s time to take your skills to the next level. You know Excel can do more, but you’ve probably gotten stuck and lost hours of your life trying to rephrase your issue to get a decent answer from Google. 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.
Get Accurate and Flexible Solutions for Your Motorsports Calculations
That’s where Excel VBA comes to your rescue! With a little VBA code, you can transform your spreadsheet life. This course will give you a zero BS grounding in how to use Excel VBA, focusing on simple calculations – the challenge of adding up a column of numbers! Keeping the calculation part simple reduces distractions and helps you learn more quickly. You’ll gain a clear understanding of what’s going on under the hood, waste less time getting stuck, and have the tools to unpick someone else’s Excel sheet with ease.
Master Simple Calculations with Ease
Invest your time in learning more about what Excel VBA can do for you with Excel VBA For Motorsports. Don’t waste any more time aimlessly searching Google. Get your calculations into Excel and take your skills to the next level with this course.
Stop Wasting Time Searching Google For Answers…
Sign up now and start learning Excel VBA for motorsports.
What’s included?
Unlimited Access. Life of the product 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.
