In this video, ExcellsFun takes you step by step on how to calculate your employee payroll using an excel spread sheet. ExcellsFun teaches you how to take the base pay of various employees' salaries and determines how much you are paying them over a week, month, and year. Excellsfun also shows you how to incorporate various pay periods including weekly, semiweekly, biweekly, and monthly on the same form using the same calculation for the entire spread sheet. After watching this video, you will be familiar not only with the formula but also with how to use the function keys to switch your calculations between rows and columns.
 Hot
 Latest

How To: Create a Basic Attendance Sheet in Excel

How To: Instantly Change Blocks of 'CAPITALIZED TEXT' in Microsoft Word to 'Lowercase Letters'

How To: Clear data & cell contents in Excel using a macro

How To: Create a simple database in Excel with a list or table

How To: Multiply column times row with Transpose in MS Excel

How To: Find a PValue with Excel

How To: Enter formulas in Excel with a macro

How To: Create an Excel inventory template with running totals

How To: Calculate a bonus in Microsoft Excel

How To: Calculate expected returns for a portfolio in Microsoft Excel

How To: Create a passfail grade formula in Microsoft Excel

How To: Extract records that meet certain criteria in Excel

How To: Generate random numbers (with decimals) in Excel

How To: Build a 15minute schedule in Microsoft Excel

How To: Calculate incentive rates by formula in MS Excel

How To: Turn off AutoCorrect symbols in Excel

How To: Create a relative frequency distribution in MS Excel

How To: Remove empty space when converting an Excel file to a PDF document

How To: Create collapsible and expandable cell ranges in Excel

How To: Calculate future value for a sinking fund in MS Excel

How To: Create a Basic Attendance Sheet in Excel

How To: Instantly Change Blocks of 'CAPITALIZED TEXT' in Microsoft Word to 'Lowercase Letters'

How To: Clear data & cell contents in Excel using a macro

How To: Create a simple database in Excel with a list or table

How To: Multiply column times row with Transpose in MS Excel

How To: Find a PValue with Excel

How To: Enter formulas in Excel with a macro

How To: Create an Excel inventory template with running totals

How To: Calculate a bonus in Microsoft Excel

How To: Calculate expected returns for a portfolio in Microsoft Excel

How To: Create a passfail grade formula in Microsoft Excel

How To: Extract records that meet certain criteria in Excel

How To: Generate random numbers (with decimals) in Excel

How To: Build a 15minute schedule in Microsoft Excel

How To: Calculate incentive rates by formula in MS Excel

How To: Turn off AutoCorrect symbols in Excel

How To: Create a relative frequency distribution in MS Excel

How To: Remove empty space when converting an Excel file to a PDF document

How To: Create collapsible and expandable cell ranges in Excel

How To: Calculate future value for a sinking fund in MS Excel
Be the First to Comment
Share Your Thoughts