Excel can be tricky to learn. To make the data relatable I'll be demonstrating 21 of the most important excel formulas using the 2023 Formula One race data. We'll be doing Index-Match lookups to find Max Verstappen's points scored in Monaco, comparing the sum, average, and maximum points scored by the two Ferrari drivers to find why Sainz was dropped for the 2025 season, and performing Offset formulas to locate specific race data from a larger table. If you're interested in Formula One and wanting to learn Excel, this is the video for you!
// SOCIAL
🌏 Follow Me On Instagram @brentcolemaninvesting
// USEFUL LINKS
✅ Sharesight (NZ/AU/US/UK) 4 Months Free: sharesight.com.au/brentcoleman
✅ Dosh NZ - Best Way To Pay: dosh.nz/app and use my referral code 00030886
✅ Get $5 FREE with Sharesies (NZ/AU): sharesies.com/r/C744KD
✅ Get $45 with DoorDash: drd.sh/yzemFEO8gYRTjiKt
✅ Free Month Car Insurance coveinsurance.co.nz/referred/...
✅ Get $10 FREE with Hatch Invest (NZ): app.hatchinvest.nz/share/hmwy...
✅ Hnry (NZ) Free $25 Freelance Accountant: app.hnry.io/r/BRENT82488
I include these links as they often provide a benefit to my viewers. I might receive a commission from these companies, or other third parties, in the case a purchase is made either using a link or signing up for a service via a code. This helps me create high-quality content and I thank you for your support.
// TIMESTAMPS
► 0:00 Intro
► 0:14 Lookups Intro
► 0:37 1 Index-Match
► 1:17 2 XLOOKUP
► 1:45 3 Index-Match (2+ Conditions)
► 2:44 4 Index-Match-Match
► 4:07 5 Data Validations
► 4:39 6 If Statement
► 5:12 7 Nested If Statements
► 6:14 8/9/10/11/12 Min/Max/Sum/Average/Count
► 7:37 13/14/15/16/17 Minifs/Maxifs/Sumifs/Averageifs/Countifs
► 9:09 18 Offset
► 10:40 19/20/21 Left/Mid/Right Formulas
► 12:39 Outro
Disclaimer:
I am not a financial adviser. This video is for education and entertainment purposes only. Seek professional help before making any investment decision.
Song: Too Fast - Ooyy
Epidemic Sound
share.epidemicsound.com/g93nl2
25 июл 2024