Download Start Excel File: http:\/\/ift.tt\/2DlvCfj
\nDownload pdf Notes: http:\/\/ift.tt\/2mEjwna
\nDownload Word File for Word Problem Example #1 in Video: http:\/\/ift.tt\/2Dp6sw4
\nDownload Finished Excel file for Word Problem Example #1 in Video: http:\/\/ift.tt\/2mEtg0s
\nEntire Class Web Site: http:\/\/ift.tt\/2BjafuY<\/p>\n
In this video learn how to use five steps to create Excel solutions for Excel Math Problems.
\nExcel & Business Math Class (Busn 135) taught by Michael Girvin at Highline College \/ Mike Girvin at excelisfun Channel at YouTube Channel.
\nTopics in Video:
\n1. (00:01) Introduction
\n2. (01:20) Five Steps to Solve Math Word Problems in Excel:
\n3. (02:44) Formula Efficiency Rules from Video 07:
\n4. (03:03) Translating English words into math symbols
\n5. (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.
\n6. (19:46) FORMULATEXT Function to show formula.
\n7. (26:05) Terms used in Retail Stores and examples of formulas
\n8. (29:50) Math Word Problem 02: Retail Store Selling Boomerangs and we need to calculate Gross Profit
\n9. (32:38) Cell Reference in Formula Can Pull Number Formatting from the Formula Input Cells
\n10. (38:40) Math Word Problem 03: How Much Water Saved in One Year with New Toilet.
\n11. (45:05) Math Word Problem 04: Mad Dog Trucking Average Miles Driven Example.
\n12. (46:05) Discuss Division with Different Units in Numerator and Denominator
\n13. (51:18) Look at Homework Problems
\n14. (51:33) Summary<\/p>\n
Next Video: 10 Excel & Business Math<\/p>\n