New to Microsoft Excel? Looking for a tip? How about a tip so mindblowingly useful as to qualify as a magic trick? You're in luck. In this MS Excel tutorial from ExcelIsFun, the 202nd installment in their series of digital spreadsheet magic tricks, you'll learn how to create a formula that calculates the number of vacation days an employee gets based on hire date using the TODAY, YEAR and IF functions.
 Hot
 Latest

How To: Find a PValue with Excel

How To: Create a relative frequency distribution in MS Excel

How To: Enter formulas in Excel with a macro

How To: Update inventory records by formula in Microsoft Excel

How To: Calculate proportions and percentages in Excel

How To: Create projections for sales numbers in MS Excel

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

How To: Create a Basic Attendance Sheet in Excel

How To: Extract records that meet certain criteria in Excel

How To: Create a passfail grade formula in Microsoft Excel

How To: Calculate a bonus in Microsoft Excel

How To: Create an Excel spreadsheet to calculate your GPA

How To: Do bank reconciliation in Microsoft Excel

How To: Create a sudoku puzzle in Excel with array formulas

How To: Create a savings plan with Excel's FV & PMT functions

How To: Apply accounting & percentage formatting in Excel

How To: Calculate quartiles with the Microsoft Excel 2010 QUARTILE function

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

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

How To: Cross tabulate categorical data in Microsoft Excel

How To: Find a PValue with Excel

How To: Create a relative frequency distribution in MS Excel

How To: Enter formulas in Excel with a macro

How To: Update inventory records by formula in Microsoft Excel

How To: Calculate proportions and percentages in Excel

How To: Create projections for sales numbers in MS Excel

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

How To: Create a Basic Attendance Sheet in Excel

How To: Extract records that meet certain criteria in Excel

How To: Create a passfail grade formula in Microsoft Excel

How To: Calculate a bonus in Microsoft Excel

How To: Create an Excel spreadsheet to calculate your GPA

How To: Do bank reconciliation in Microsoft Excel

How To: Create a sudoku puzzle in Excel with array formulas

How To: Create a savings plan with Excel's FV & PMT functions

How To: Apply accounting & percentage formatting in Excel

How To: Calculate quartiles with the Microsoft Excel 2010 QUARTILE function

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

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

How To: Cross tabulate categorical data in Microsoft Excel
Be the First to Comment
Share Your Thoughts