Topics: Fractions, Decimals, Percentages
Fractions are covered in videos 11 - 17
Handwritten pdf Notes for Videos 11 to 17: ExcelBusinessMathFractionHandwrittenNotes.pdf
Video/Class Project
11:
Video to watch: Excel
& Business Math 11: Types Of Fractions & Fraction Number Formatting ( 21:47 min)
Start file for Video/Class Project to download: ExcelBusinessMathVideo11TypesFractions.xlsx
Handout to download: ExcelBusinessMathVideo11TypesFractions.pdf
Assigned Homework: HW #1 - 2 at end of Excel Workbook for this video.
Video/Class Project
12:
Video to watch: Excel
& Business Math 12: Reducing Fractions, Prime Factors and Understanding &
Calculating Ratios ( 36 min)
Start file for Video/Class Project to download: ExcelBusinessMathVideo12ReducingFractions.xlsx
Handout to download: ExcelBusinessMathVideo12ReduceFractions.pdf
PowerPoint Fraction Drawings as seen in video:
Video12-Fractions.pptx
Assigned Homework: HW #1 - 5 at end of Excel Workbook for this video.
Video/Class Project
13:
Video to watch: Excel
& Business Math 13: Mixed Number to Improper Fraction, Improper Fraction to
Mixed Number ( 14:42 min)
Start file for Video/Class Project to download: ExcelBusinessMathVideo13MixedToFraction.xlsx
Handout to download: ExcelBusinessMathVideo13MixedToFraction.pdf
PowerPoint Fraction Drawings as seen in video:
Video13-Fractions.pptx
Assigned Homework: HW #1 - 4 at end of Excel Workbook for this video.
Video/Class Project
14:
Video to watch: Excel
& Business Math 14: Convert Decimal To Fraction & Convert Fraction To Decimal ( 21:17 min)
Start file for Video/Class Project to download: ExcelBusinessMathVideo14DecimalFraction.xlsx
Handout to download: ExcelBusinessMathVideo14DecimalFraction.pdf
PowerPoint Fraction Drawings as seen in video:
Video14-Fractions.pptx
Assigned Homework: HW #1 - 4 at end of Excel Workbook for this video.
Video/Class Project
15:
Video to watch: Excel
& Business Math 15: Multiplying and Dividing Fractions By Hand & In Excel ( 08:52 min)
Start file for Video/Class Project to download: ExcelBusinessMathVideo15MultDivFractions.xlsx
Handout to download: ExcelBusinessMathVideo15MultDivFractions.pdf
PowerPoint Fraction Drawings as seen in video:
Video15-Fractions.pptx
Assigned Homework: HW #1 - 4 at end of Excel Workbook for this video.
Video/Class Project
16:
Video to watch: Excel
& Business Math 16: Fun With Adding & Subtracting Fractions & Least Common
Denominator ( 33:01 min)
Start file for Video/Class Project to download: ExcelBusinessMathVideo16AddSubFractions.xlsx
Handout to download: ExcelBusinessMathVideo16AddSubFractions.pdf
PowerPoint Fraction Drawings as seen in video:
Video16-Fractions.pptx
Assigned Homework: HW #1 - 4 at end of Excel Workbook for this video.
Video/Class Project
17:
Video to watch: Excel
& Business Math 17: Solve Fractional Business Math Problems using Excel ( 12:40 min)
Start file for Video/Class Project to download: ExcelBusinessMathVideo17FractionWord.xlsx
Handout to download: ExcelBusinessMathVideo17FractionWord.pdf
Assigned Homework: HW #1 - 3 at end of Excel Workbook for this video.
Percentages are covered in videos 18 - 26
Video/Class Project
18:
Video to watch:
Excel & Business Math 18 Percents & Percentage Number
Formats (including Fractional Percents) ( 37:44 min)
Start file for Video/Class Project to download: ExcelBusinessMathVideo18Percents.xlsx
Handout to download: ExcelBusinessMathVideo18Percents.pdf
Assigned Homework: HW #1 - 25 at end of Excel Workbook for this video.
Video/Class
Project 19:
Video to watch:
Excel & Business Math 19: Round a Percent using ROUND
Function & Rate of Change Formula ( 17:05 min)
Start file for Video/Class Project to download: ExcelBusinessMathVideo19ROUNDPercents.xlsx
Handout to download: ExcelBusinessMathVideo19ROUNDPercents.pdf
Assigned Homework: HW #1 - 4 at end of Excel Workbook for this video.
Video/Class
Project 20:
Video to watch:
Excel & Business Math 20: Percent Formulas for Part,
Rate & Base (8 Example) ( 32:53 min)
Start file for Video/Class Project to download: ExcelBusinessMathVideo20PercentFormulas.xlsx
Handout to download:
ExcelBusinessMathVideo20PercentFormulas.pdf
Assigned Homework: HW #1 - 10 at end of Excel Workbook for this video.
Video/Class
Project 21:
Video to watch:
Excel & Business Math 21: Percent Formulas & Business
Math Word Problems ( 14:52 min)
Start file for Video/Class Project to download: ExcelBusinessMathVideo21PercentWord.xlsx
Handout to download:
ExcelBusinessMathVideo21PercentWord.pdf
Assigned Homework: HW #1 - 3 at end of Excel Workbook for this video.
Video/Class
Project 22:
Video to watch:
Excel & Business Math 22: Rate Formula for Common Size
Income Statement using Mixed Cell Reference ( 18:17 min)
Start file for Video/Class Project to download: ExcelBusinessMathVideo22RateCommonSize.xlsx
Handout to download: ExcelBusinessMathVideo22RateCommonSize.pdf
Assigned Homework: HW #1 problem at end of Excel Workbook for this video.
Video/Class
Project 23:
Video to watch:
Excel & Business Math 23: Important Formulas for Increase Decrease
Problems (8 Awesome Examples) ( 01:00:10 min) (1
hour)
Start file for Video/Class Project to download:
ExcelBusinessMathVideo23IncreaseDecrease.xlsx
Handout to download: ExcelBusinessMathVideo23IncreaseDecrease.pdf
Assigned Homework: HW #1 - 7 at end of Excel Workbook for this video.
Video/Class
Project 24:
Video to watch:
Excel & Business Math 24: COUNTIFS Function & Part/Base for
Probabilities & Frequency Distributions
( 24:32 min)
Start file for Video/Class Project to download:
ExcelBusinessMathVideo24COUNTIFSProbability.xlsx
Handout to download: ExcelBusinessMathVideo24COUNTIFSProbability.pdf
Assigned Homework: HW #1 - 2 at end of Excel Workbook for this video.
Video/Class
Project 25:
Video to watch:
Excel & Business Math 25: Percentage Formulas to Help Calculate a
Budgeted Forecast for Next Year
( 08:52)
Start file for Video/Class Project to download: ExcelBusinessMathVideo25Budgeting.xlsx
Handout to download: ExcelBusinessMathVideo25Budgeting.pdf
Assigned Homework: HW #1 at end of Excel Workbook for this video.
Video/Class
Project 26:
Video to watch:
Excel & Business Math 26: Is Rate of
Change Same for Increase by $10 and Decrease by $10?
( 02:47)
Start file for Video/Class Project to download: ExcelBusinessMathVideo26UpDownSameQuestion.xlsx
Handout to download: ExcelBusinessMathVideo26UpDownSameQuestion.pdf
Assigned Homework: None