Instructions:
1) Download all files
2) Open files
3) Click on video and watch
4) Complete project as seen in video
5) Then do homework in textbook (Homework list in syllabus).
Downloads:
1st Excel Workbook: Excel2010BusnMathCh03.xlsm
(Selected homework solutions at end of workbook)
2nd Excel Workbook: Excel2010BusnMathCh03-SECTION-3.5.xlsm
Chapter 3 Review Workbook (Extra Practice if you want): Chapter3ReviewExercise.xlsm
If file downloads as ".zip", watch this video: Download Excel File Shows Up As Zip?
BusnMathCh03-Final.pdf (Handwritten notes)
Ch 3 Percent Video Drawings Sections 3.1 & 3,2 & 3.3 & 3.4.pptx (Drawings from video for sections 3.1, 3.2, 3.3, 3.4
Ch03 Video Drawings Fractional Percentages To Decimals.pptx
Chapter 3 Section 3.5 Video Drawings IncreaseDecreaseRateOfChange.pptx
Videos To Watch:
Excel 2010 Business Math 25: Excel Percent Basics (17 mins) (Section 3.1)
Excel 2010 Business Math 26: Percent Conversions: By Hand and In Excel (33 mins) (Section 3.1)
Excel 2010 Business Math 26.5: Rounding Percentages (5 mins) (Section 3.1)
Excel 2010 Business Math 27: Part = Percent * Base: Solve for Part (24 mins) (Section 3.2)
Excel 2010 Business Math 28: Base = Part/Rate: Solve For Base (25 mins) (Section 3.3)
Excel 2010 Business Math 29: Rate = Part/Base (18 mins) (Section 3.4)
Excel 2010 Business Math 30: Fractional Percentages To Decimals (12 mins) (Section 3.5)
Excel 2010 Business Math 31: Increase Decrease Problems & Rate Of Change 12 Formulas (45 mins) (Section 3.5)
Excel 2010 Business Math 32: Rate Of Change Word Problem (13 mins) (Section 3.5)
Excel 2010 Business Math 33: Markup and Markdown Calculations (4 mins) (Section 3.5)
Excel 2010 Business Math 34: Begin Amount = (Amount of Change)/(Rate of Change) (14 mins) (Section 3.5)
Excel 2010 Business Math 35: Stock Value Percentage Change & Web Query For Current Stock Values (7 mins) (Section 3.5) Video no longer required for this class becasue Microsoft took this feature out... : (
Excel 2010 Business Math 36: Memorization Trick For Percentage Math Problems (14 mins) (Sections 3.2, 3.3, 3.4, and 3.5)
** Different colors above have no meaning (I just couldn't get rid of it...).
**Section numbers refer to sections in textbook.