Learn a five-step approach to solving math word problems in Excel in this comprehensive 53-minute video tutorial. Master the art of translating English words into mathematical symbols and apply formula efficiency rules. Work through practical examples, including calculating theater balcony seats, determining retail store gross profit, estimating water savings with new toilets, and computing average miles driven for a trucking company. Explore the FORMULATEXT function, understand retail store terminology, and discover how cell references can inherit number formatting. Gain insights into handling division with different units and prepare for homework assignments. Download accompanying files to follow along and reinforce your learning.
Overview
Syllabus
) Introduction.
) Five Steps to Solve Math Word Problems in Excel:.
) Formula Efficiency Rules from Video 07:.
) Translating English words into math symbols.
) Math Word Problem 01: Calculate Number of Seats in Theater Balcony. We Download Word File, Read Problem and create a new Excel file..
) FORMULATEXT Function to show formula..
) Terms used in Retail Stores and examples of formulas.
) Math Word Problem 02: Retail Store Selling Boomerangs and we need to calculate Gross Profit.
) Cell Reference in Formula Can Pull Number Formatting from the Formula Input Cells.
) Math Word Problem 03: How Much Water Saved in One Year with New Toilet..
) Math Word Problem 04: Mad Dog Trucking Average Miles Driven Example..
) Discuss Division with Different Units in Numerator and Denominator.
) Look at Homework Problems.
) Summary.
Taught by
ExcelIsFun
