Excel Showdown | Power Query vs Formulas vs Copilot vs Python

Save up to 50% off Maven Pro Plans! ➡️ https://bit.ly/4cXXTHo We're back with a new Data Drill Showdown! Data Drill 8: Splitting the Field! ⚾️ 👉 https://bit.ly/4d15EOL Four experts. Four unique Excel Solutions. One winner… 🏆 In this video, Maven Analytics instructors Aaron Parry, Enrique Ruiz, Alice Zhao, and Chris Bruehl battle it out using different methods of Excel to earn the title of Data Drill Champion. Formulas. Copilot. Power Query. Python. Who will come out on top? For Data Drill #8: “Splitting the Field”, we’ve provided a dataset containing the names of all the baseball players from the 2025 MLB season, along with their team(s) and position(s). A player qualifies for a position by starting at least 20 games at that position in the field or 5 games as a pitcher. The task at hand is to aggregate this data and return a table counting the number of players at each position, sorted from highest to lowest. Each expert will be on the clock as they solve the drill, and the best solution takes the crown. Follow along to sharpen your skills and learn how to tackle real-world data problems using some of the most popular data & AI tools! 👉 Try Data Drill #8 yourself: https://bit.ly/4d15EOL 🎉 UP TO 50% OFF SPRING SAVINGS 🎉 The LOWEST PRICING of the season starts NOW! AI is reshaping every industry, and the professionals who will thrive aren’t waiting to figure it out. They’re building real skills right now. You can, too! For Spring Savings, you can choose from 3 great offers through May 6th: 👉 Monthly plan: 25% off your first 3 months ($36.75/mo) 👉 Annual plan: 50% off your first year ($199.50/yr) 👉 Lifetime access: 50% off, forever ($849.50) All Maven Pro memberships include: ✓ Unlimited access to ALL courses & learning paths ✓ Customized learning plans ✓ Guided projects ✓ Skills assessments ✓ Showcase portfolio builder ✓ Free practice data sets ✓ Private student dashboard ✓ Live instructor chat support Plus something brand NEW, launching soon...👀 Build job-ready AI + data skills, all in one membership. SAVE NOW 👉 https://bit.ly/4cXXTHo 🔗 Helpful links: 👉 Build job-ready data skills: Generative AI Essentials Learning Path: https://bit.ly/4bDBhwn Excel Specialist Learning Path: https://bit.ly/4uHixnx 👉 Follow us on LinkedIn: Maven Analytics: https://www.linkedin.com/company/maven-analytics Chris D: https://www.linkedin.com/in/csdutton/ Aaron: https://www.linkedin.com/in/amp28/ Alice: https://www.linkedin.com/in/alicexzhao/ Chris B: https://www.linkedin.com/in/chrisbruehl/ Enrique: https://www.linkedin.com/in/enrique-ruiz-tapia/ ⏱️ Timestamps: 00:00 - Intro to Data Drill #8: “Splitting the Field” 01:02 - Meet the experts 01:36 - Formulas solution (Enrique) 07:03 - Python in Excel Solution (Chris B.) 10:00 - Edit with Copilot solution (Alice) 13:39 - Power Query solution (Aaron) 15:27 - Results & winner selection Maven Analytics is an award-winning learning platform where individuals and teams build new skills, showcase work, and connect with experts around the world. We've helped 2M+ people build job-ready data literacy & AI skills, master tools like Excel, SQL, Power BI, Tableau and Python, and build the foundation for successful careers. Start building life-changing skills for FREE 👉 https://bit.ly/4rk2JUx