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
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
-
2:13
Excel Calculate Decimal Hours from two Time Cells - Episode 902
-
3:57
Excel 2007 - Color of Selected Sheets is too much like unselected sheets - Episode 907
-
2:48
Excel - Adding Equals Icon to Excel QAT - Build Formula with Mouse - Episode 911
-
3:30
Excel Grouping Percentages into Buckets for a Pivot Table - Method 2 - Episode 913
-
2:04
Excel Change Color of Selected Cells - Episode 914
-
4:38
Excel - Auto Numbering a List with Frequent Inserts & Deletes - Episode 916
-
2:00
Excel Hiding Data in Plain Site - Episode 919
-
2:20
Excel - Bring Back The Full Excel 2003 Dialogs In Excel! - Episode 920