Back To Busn 135  Home Page

 

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