Bob Flisser - Envato Tuts+ Profile

Tutorials

How to Extract Data From a Spreadsheet Using VLOOKUP, MATCH, and INDEX
There's easier ways to find and move data in a spreadsheet than copy and paste. Here's how to use the VLOOKUP, MATCH and INDEX functions to extract specific...
Bob Flisser
22 Apr 2014
Computer Skills
Tame Your Outlook Inbox With Subfolders, Rules and Filters
Outlook is the most popular business email client, and it has the powerful features you need to automatically keep your inbox clean. Here's how to use...
Bob Flisser
16 Apr 2014
Computer Skills
Spreadsheets for Finance: Calculating Internal Rate of Return
If you're going to invest your money, you'll want to make sure you're getting the most from your investment. That's exactly what the internal rate of return...
Bob Flisser
26 Feb 2014
Computer Skills
Spreadsheets for Finance: Calculating Present Value and Net Present Value
Money in the future is worth less than money today. Or, perhaps, "a bird in the hand is worth two in the bush", as they used to say. But you're not trying to...
Bob Flisser
19 Feb 2014
Computer Skills
Using Spreadsheets for Finance: How to Calculate Loan Payments
There's a lot more to your loan than just the original sticker price, or the base monthly payment. Here's how you can use spreadsheets to break down your...
Bob Flisser
11 Feb 2014
Computer Skills
Using Spreadsheets for Finance: How to Calculate Depreciation
Getting ready for tax season? Here's how to calculate depreciation on your assets using Straight-line, Declining balance, Double-declining balance, and Sum...
Bob Flisser
6 Feb 2014
Computer Skills