Learn how to solve math word problems in Excel using five steps. This course covers translating English words into math symbols, formula efficiency rules, and practical examples such as calculating the number of seats in a theater balcony and determining gross profit in a retail store. The teaching method includes step-by-step problem-solving demonstrations using Excel. This course is intended for individuals interested in improving their Excel skills for business math applications.
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
