Excel - Tips for Solving Algebraic Equations in Excel - Excel - Episode 1439

2,764 views · Published 30 September 2011 · 8:36 · Indexed 24 October 2026

Channel: MrExcel.com · 2011 · Education

Watch on YouTube

Microsoft Excel Tutorial: Baseball problem from his algebra class. Bill "MrExcel" Jelen and Mike "ExcelisFun" Girvin differ over whether the problem actually requires Algebra, Goal Seek, or simply a visit with Bob Barker. 

Welcome to another exciting episode of Dueling Excel, where we pit our Excel skills against each other to solve real-life problems. In this episode, we tackle a question sent in by Dennis, a 15-year-old student who is struggling with algebra. The question involves calculating the number of runs a baseball player needs to hit in the next year to maintain an average of 60 runs over the past 11 years. As always, I am joined by my co-host, Mike Girvin from Excel Is Fun, and together we will show you two different ways to solve this problem.

First, we will use the traditional method of setting up a spreadsheet and manually calculating the numbers. We will input all the data we have and use formulas to calculate the total runs and the average. Then, we will use trial and error to guess the number of runs needed in the 12th year to reach an average of 60. This method may seem tedious and time-consuming, but it is a great way to understand the concept of averages and how they are calculated.

But wait, there's a faster way! Mike will show us how to use the Goal Seek feature in Excel to solve this problem in a matter of seconds. By setting the cell we want to change (the number of runs in the 12th year) and the cell we want to reach (an average of 60), Excel will automatically calculate the number of runs needed. This feature is a game-changer and can save you a lot of time and effort, especially when dealing with more complex equations.

However, as I always say, it's important to understand the concept behind the solution. So, while Goal Seek may be a handy tool, it's essential to know how to solve the problem manually as well. Plus, you never know when you might find yourself in a situation without access to a computer and need to solve a problem like this using good old-fashioned algebra. So, don't give up on algebra just yet, Dennis. It may come in handy someday.

In this episode, we also discuss the importance of using the COUNTA function instead of the COUNT function when dealing with non-numeric data. Mike also shares a useful trick for solving equations in Excel, where you need to isolate a variable by keeping all the numbers in the equation. And as always, we remind our viewers to use the undo button and keyboard shortcut (Ctrl Z) to avoid any mistakes while working in Excel.

So, whether you're a student struggling with algebra or just looking to improve your Excel skills, this episode has something for everyone. Don't forget to like, comment, and subscribe to our channel for more exciting episodes of Dueling Excel. And if you have a problem you want us to solve, send it in, and we might feature it in our next episode. Thanks for watching, and we'll see you next time for another netcast from MrExcel and Excel Is Fun.

Buy Bill Jelen's latest Excel book: https://www.mrexcel.com/products/latest/

You can help my channel by clicking Like or commenting below: https://www.mrexcel.com/like-mrexcel-on-youtube/

Table of Contents:
(00:00) Goal Seek to Avoid Algebra in Excel
(00:28) Using formulas to find the total and average
(01:03) Using Goal Seek to find the answer
(02:04) Comparing the two methods
(02:14) The use of Algebra in this problem
(02:24) Mike Girvin's solution
(02:46) Benefits of using Goal Seek
(03:40) Setting up the equation
(04:43) Solving for the unknown variable
(06:25) Building the formula
(07:05) Dynamic nature of the formula
(08:08) Clicking Like really helps the algorithm

#excel #microsoft #microsoftexcel #exceltutorial #exceltips #exceltricks #excelmvp #freeclass #freecourse #freeclasses #excelclasses #microsoftmvp #walkthrough #evergreen #spreadsheetskills #analytics #analysis #dataanalysis #dataanalytics #mrexcel #spreadsheets #spreadsheet #excelhelp #accounting #tutorial


This video answers these common search terms:
Algebra
Algebra class
Algebra teacher
Average of 60
Baseball player
Episode 85
Equation solving
Excel Is Fun
Goal Seek
Math class


Join the MrExcel Message Board discussion about this video at https://www.mrexcel.com/board/threads/1153117/

Pick up tips on solving Algebra Equations with Excel, using =AVERAGE, COUNTA, Goal Seek and more!

More from this channel