Download Start Excel File: http://ift.tt/2DlvCfj
Download pdf Notes: http://ift.tt/2mEjwna
Download Word File for Word Problem Example #1 in Video: http://ift.tt/2Dp6sw4
Download Finished Excel file for Word Problem Example #1 in Video: http://ift.tt/2mEtg0s
Entire Class Web Site: http://ift.tt/2BjafuY
In this video learn how to use five steps to create Excel solutions for Excel Math Problems.
Excel & Business Math Class (Busn 135) taught by Michael Girvin at Highline College / Mike Girvin at excelisfun Channel at YouTube Channel.
Topics in Video:
1. (00:01) Introduction
2. (01:20) Five Steps to Solve Math Word Problems in Excel:
3. (02:44) Formula Efficiency Rules from Video 07:
4. (03:03) Translating English words into math symbols
5. (05:40) Math Word Problem 01: Calculate Number of Seats in Theater Balcony. We Download Word File, Read Problem and create a new Excel file.
6. (19:46) FORMULATEXT Function to show formula.
7. (26:05) Terms used in Retail Stores and examples of formulas
8. (29:50) Math Word Problem 02: Retail Store Selling Boomerangs and we need to calculate Gross Profit
9. (32:38) Cell Reference in Formula Can Pull Number Formatting from the Formula Input Cells
10. (38:40) Math Word Problem 03: How Much Water Saved in One Year with New Toilet.
11. (45:05) Math Word Problem 04: Mad Dog Trucking Average Miles Driven Example.
12. (46:05) Discuss Division with Different Units in Numerator and Denominator
13. (51:18) Look at Homework Problems
14. (51:33) Summary
Next Video: 10 Excel & Business Math