New to Microsoft Excel? Looking for a tip? How about a tip so mind-blowingly 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.
Follow WonderHowTo on Facebook, Twitter, Pinterest, and Flipboard
How To:
Find a P-Value with Excel
How To:
Create a Basic Attendance Sheet in Excel
How To:
Conditionally format at every change in value in Excel
How To:
Calculate proportions and percentages in Excel
How To:
Create a dynamic weekly chart in Microsoft Excel
How To:
Generate random numbers (with decimals) in Excel
How To:
Clear data & cell contents in Excel using a macro
How To:
Do bank reconciliation in Microsoft Excel
How To:
Create dynamic sub tables in Microsoft Excel
How To:
Calculate commissions with Excel's VLOOKUP function
How To:
Summarize survey results with a pivot table in Excel
How To:
Save Your Word Document as PDF with One Click (Using a Macro)
How To:
Create an array formula for Bayes' theorem in Excel
How To:
Chart a categorical frequency distribution in MS Excel
How To:
Scan a document in Word 2007
How To:
Run an existing macro in Microsoft Excel 2011
How To:
Enter formulas in Excel with a macro
How To:
Instantly Change Blocks of 'CAPITALIZED TEXT' in Microsoft Word to 'Lowercase Letters'
How To:
Create an Excel spreadsheet to calculate your GPA
How To:
Extract records that meet certain criteria in Excel
How To:
Find a P-Value with Excel
How To:
Create a Basic Attendance Sheet in Excel
How To:
Conditionally format at every change in value in Excel
How To:
Calculate proportions and percentages in Excel
How To:
Create a dynamic weekly chart in Microsoft Excel
How To:
Generate random numbers (with decimals) in Excel
How To:
Clear data & cell contents in Excel using a macro
How To:
Do bank reconciliation in Microsoft Excel
How To:
Create dynamic sub tables in Microsoft Excel
How To:
Calculate commissions with Excel's VLOOKUP function
How To:
Summarize survey results with a pivot table in Excel
How To:
Save Your Word Document as PDF with One Click (Using a Macro)
How To:
Create an array formula for Bayes' theorem in Excel
How To:
Chart a categorical frequency distribution in MS Excel
How To:
Scan a document in Word 2007
How To:
Run an existing macro in Microsoft Excel 2011
How To:
Enter formulas in Excel with a macro
How To:
Instantly Change Blocks of 'CAPITALIZED TEXT' in Microsoft Word to 'Lowercase Letters'
How To:
Create an Excel spreadsheet to calculate your GPA
How To:
Extract records that meet certain criteria in Excel
Be the First to Comment
Share Your Thoughts