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:
Excel2010BusnMathCh06.xlsx
(Selected homework solutions at end of workbook)
Videos To Watch:
Excel 2010 Business Math 43: Excel Time Number Formatting & Excel Time Math (18 mins) (section 6.1)
Excel 2010 Business Math 44: Payroll Time Sheets, IF Function For Overtime &Gross Pay Calculations (20 mins) (section 6.1)
Excel 2010 Business Math 45: Overtime Calculations 4 Examples (13 mins) (section 6.1)
Excel 2010 Business Math 46: Calculating Equivalent Earnings For Different Pay Periods (15 mins) (section 6.1)
Excel 2010 Business Math 47: Incentive Pay: Piece Work (3 mins) (section 6.2)
Excel 2010 Business Math 48: Incentive Pay: Variable Piece Work Rates (14 mins) (section 6.2)
Excel 2010 Business Math 49: Piecework With A Guaranteed Hourly Wage, MAX function (Incentive Pay) (3 mins) (section 6.2)
Excel 2010 Business Math 50: Overtime Earnings For Piecework (Incentive Pay) (2 mins) (section 6.2)
Excel 2010 Business Math 51: Commission Rates as Incentive Pay, Calculate Commission on Sales (3 mins) (section 6.2)
Excel 2010 Business Math 52: Variable Commission Rates, Multiple Step Method (13 mins) (section 6.2)
Excel 2010 Business Math 53: Calculate Gross Pay for Salary and Commissions (2 mins) (section 6.2)
Excel 2010 Business Math 54: Calculate Social Security and Medicare Deductions (17 mins) (section 6.3)
Excel 2010 Business Math 55: Federal Income Tax Deduction Wage Bracket Method (8 mins) (section 6.4) For videos use tax tables as shown in video. For homework, use tax tables shown in textbook.
Excel 2010 Business Math 56: Federal Income Tax Deduction Percentage Method (15 mins) (section 6.4) For videos use tax tables as shown in video. For homework, use tax tables shown in textbook.