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 and Mr. Excel, the 24th installment in their joint series of digital spreadsheet magic tricks, you'll learn 5 different methods for calculating a bonus using VLOOKUP, MAX, Boolean, and 2 IF formulas.
 Hot
 Latest

How To: Find a PValue with Excel

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

How To: Create a Basic Attendance Sheet in Excel

How To: Sum only certain columns in Microsoft Excel

How To: Use Excel for daily interest and monthly deposits

How To: Update inventory records by formula in Microsoft Excel

How To: Graph the probability density function in an Excel file

How To: Use conditional formatting for a student grading report in Microsoft Excel

How To: Calculate monthly retirement income in Microsoft Excel

How To: Create an Excel spreadsheet to calculate your GPA

How To: Create sequential numbers in Excel formulas with ROWS

How To: Sum dollar amounts from a column in Micrsoft Excel

How To: Create a dynamic weekly chart in Microsoft Excel

How To: Create a cumulative frequency distribution in MS Excel

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

How To: Build frequency tables & histogram charts in MS Excel

How To: Calculate child support payments in Microsoft Excel

How To: Create envelopes with the Mail Merge tool in Microsoft Word 2010

How To: Use VLOOKUP in Microsoft Office Excel 2007

How To: Retrieve cell references with INDEX & MATCH in Excel

How To: Find a PValue with Excel

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

How To: Create a Basic Attendance Sheet in Excel

How To: Sum only certain columns in Microsoft Excel

How To: Use Excel for daily interest and monthly deposits

How To: Update inventory records by formula in Microsoft Excel

How To: Graph the probability density function in an Excel file

How To: Use conditional formatting for a student grading report in Microsoft Excel

How To: Calculate monthly retirement income in Microsoft Excel

How To: Create an Excel spreadsheet to calculate your GPA

How To: Create sequential numbers in Excel formulas with ROWS

How To: Sum dollar amounts from a column in Micrsoft Excel

How To: Create a dynamic weekly chart in Microsoft Excel

How To: Create a cumulative frequency distribution in MS Excel

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

How To: Build frequency tables & histogram charts in MS Excel

How To: Calculate child support payments in Microsoft Excel

How To: Create envelopes with the Mail Merge tool in Microsoft Word 2010

How To: Use VLOOKUP in Microsoft Office Excel 2007

How To: Retrieve cell references with INDEX & MATCH in Excel
2 Comments
I like this kind learning
Good job Sir, Its really very impressive... Now i always keep an eye on your work. So, that I learn more. Thank you so much.. :)
Share Your Thoughts