Download Start Excel File: http://ift.tt/2F21S4D
Download pdf Notes: http://ift.tt/2owePNU
Entire Class Web Site: http://ift.tt/2BjafuY

In this video learn how to use VLOOKUP & MAX Functions to make Federal Income Tax Withholding Deduction formulas.
Excel & Business Math Class (Busn 135) taught by Michael Girvin at Highline College / Mike Girvin at excelisfun Channel at YouTube Channel.
Topics in Video:
1. (00:01) Introduction
2. (00:31) Federal Income Tax Withholdings Deducted from Employees Paychecks
3. (02:42) IRS web site with 2018 Percentage Method Tax Tables.
4. (04:00) 2018 Percentage Method Federal Income Tax Withholding Tables in Excel
5. (06:19) Video Example 1: Calculate Federal Income Tax Withholdings for Marital Status “Single” and Pay Period Weekly. Calculations made by Hand and with MAX and VLOOKUP.
6.
7. (17:05) Use Formula Evaluator to verify that VLOOKUP Formula is working correctly
8. (18:38) Video Example 2: Calculate Federal Income Tax Withholdings for Marital Status “Married” and Pay Period Weekly. Calculations made by Hand and with MAX and VLOOKUP.
9. (21:36) Video Example 3: Calculate Federal Income Tax Withholdings for Marital Status “Single” and Pay Period Weekly for an Entire Payroll Table. Calculations made with MAX and VLOOKUP.
10. (27:33) Video Example 4: Calculate Federal Income Tax Withholdings for Marital Status “Married” and Pay Period Weekly for an Entire Payroll Table. Calculations made with MAX and VLOOKUP. See how to copy a Whole Table for formulas to a new template.
11. (28:28) Summary

Next Video: 36 Excel & Business Math

View on YouTube

Download Start Excel File: http://ift.tt/2HLKjrj
Download pdf Notes: http://ift.tt/2GJRY88
Entire Class Web Site: http://ift.tt/2BjafuY

In this video learn all about the VLOOKUP Function, How to Build Lookup Tables and all about Incentive Pay such as Piecework and Commission Pay.
Excel & Business Math Class (Busn 135) taught by Michael Girvin at Highline College / Mike Girvin at excelisfun Channel at YouTube Channel.
Topics in Video:
1. (00:01) Introduction
2. (02:25) Incentive Pay such as: Straight Piecework, Variable Piecework, Straight Commission, Variable Commission Rates, Commission Rate Based on Amount of Sales
3. (06:42) Straight Piecework Example
4. (08:24) Variable Piecework Example Making the Calculations Long-Hand
5. (11:28) Why Excel is so Helpful AND why we must be REALLY Knowledgeable with Excel.
6. (12:00) Variable Piecework Example Making the Calculations with the “Lookup Table Method”
7. (20:04) Creating the Lookup Table from Scratch
8. (30:31) Variable Piecework Example Making the Calculations with the “Lookup Table Method & VLOOKUP Function using Approximate Match”
9. (40:19) Variable Piecework & VLOOKUP & Approximate Match Lookup for Entire Payroll Table:
10. (44:10) What is VLOOKUP Function?
11. (44:42) “Mash” all 3 VLOOKUP Functions into Single Formula using Clipboard:
12. (not in video look in pdf notes) VLOOKUP Function Arguments (Full Details):
13. (49:00) Lookup Tables are Everywhere
14. (51:55) Straight Commission Rates
15. (52:51) VLOOKUP & Exact Match Lookup for Straight Commission Rates When each Employee has Different Rate
16. (59:00) VLOOKUP & Approximate Match Lookup for Variable Commission Rates; Make Lookup Table and use VLOOKUP
17. (01:15:25) VLOOKUP & Approximate Match Lookup for Commission Rate Based on Amount of Sales Made by the Employee
18. (01:20:02) Summary

Next Video: 34 Excel & Business Math

View on YouTube

Download Start Excel File: http://ift.tt/2EHj4jT
Download pdf Notes: http://ift.tt/2CCS6DT
Entire Class Web Site: http://ift.tt/2BjafuY

In this video learn about three different formulas for n Excel Payroll Time Sheet with the Night Shift Employees work past midnight and have a Time Out that is smaller than the Time In.
Excel & Business Math Class (Busn 135) taught by Michael Girvin at Highline College / Mike Girvin at excelisfun Channel at YouTube Channel.
Topics in Video:
1. (00:01) Introduction
2. (00:13) What is Night Shift?
3. (01:12) Look at Time Values for Night Shift and Negative Times in Excel
4. (05:18) Formula # 1 using IF Function
5. (09:41) Formulas #2 using Logical Formula or Boolean Formula
6. (13:29) Formula #3 using MOD Function
7. (14:57) Complete Payroll Time Sheet for Day or Night Shift using all three formulas and the ROUND Function.
8. (19:43) Summary

Next Video: 32 Excel & Business Math

View on YouTube

Download Start Excel File: http://ift.tt/2ol0qmU
Download pdf Notes: http://ift.tt/2C9onHg
Entire Class Web Site: http://ift.tt/2BjafuY
In this video learn about Time Number Formatting and learn about Time Calculations in Excel to calculate Total Number Of Hours between two time values. Also see a Payroll table that allows us to calculate Hours Worked, Gross Pay, Deductions and Net Pay.
Excel & Business Math Class (Busn 135) taught by Michael Girvin at Highline College / Mike Girvin at excelisfun Channel at YouTube Channel.
Topics in Video:
1. (00:01) Introduction
2. (00:51) What is Excel Time Number Format?
3. (07:40) Excel Formula for Total Hours between two-time values
4. (11:27) Excel Formulas for Total Hours between four-time values, Time In and Time Out including Lunch break
5. (15:20) Payroll table with formulas for: Hours Worked, Gross Pay, Deductions, Net Pay, including the correct use of the Round Function
6. (18:51) Summary

Next Video: 30 Excel & Business Math

View on YouTube

Download Files: Start Excel File: http://ift.tt/2FaY1mx
Entire page with all Excel Files for All Videos: http://ift.tt/1zHY6GI about how to
In this video learn how to use the COUNTIFS and AND Functions to create a Logical Formula that will deliver a TRUE when the Event Key is a Duplicate AND the Task Column equals “Special”.

View on YouTube

Excel & Business Math 27: Bank Reconciliation Made Easy
Download Start Excel File: http://ift.tt/2Bxb4zg
Download pdf Notes: http://ift.tt/2o0wqgO
Entire Class Web Site: http://ift.tt/2BjafuY

In this video learn about checks and Bank Reconciliation. Learn about the concepts of why and how we perform bank reconciliation. Also learn about how to show two worksheets from the same workbook side-by-side. Also learn hoe to create Conditional Formatting and data Validation to format or highlight a row in a checkbook register.
Excel & Business Math Class (Busn 135) taught by Michael Girvin at Highline College / Mike Girvin at excelisfun Channel at YouTube Channel.
Topics in Video:
1. (00:01) Introduction
2. Parts of a Checks
3. Types of Endorsements
4. Bank Services & Fees
5. Bank Reconciliation Example 1: Make sure both sides are actually Equal.
6. Bank Reconciliation Example 2: Make sure both sides are actually Equal and enter the bank statement entries that are not in our records, into our records
7. Bank Reconciliation Example 3: Bank Reconciliation with a Bank Reconciliation Form
8. How to show two worksheets from the same workbook side-by-side: View, New Window, Arrange All
9. How to use Conditional Formatting and Data Validation to format or highlight row that has an “X” for “item has been reconciled”.
10. () Summary

Next Video: 28 Excel & Business Math

View on YouTube