MS Excel Formula and Calculation Tips
CORPORATE FINANCE MODELS MEMBERSHIP SITE HAS LAUNCHED!! - CLICK HERE
NOTE: You will need your Subscriber Username & Password to be able to view the web pages with the tips. Not yet a Subscriber? Click here - the Username & Password will be emailed to you.
MS EXCEL SPREADSHEET TIPS
MS EXCEL TRIVIA: Questions you are too embarrassed to ask about MS Excel!. Click Here
FINANCIAL MODELING TIPS
HLOOKUP and ROWS Function Calculations: How to set up your HLOOKUP Function Calculation so that it doesn't "disintergrate" when a row is inserted within the calculation table/array. Click Here
Dynamic IRR Calculation: How to set up your IRR Calculation so that it is very interactive by using HLOOKUP Function + Running IRR Calc + ROWS Function. Click Here
Please help us serve you better - complete the Poll/Survey
on the Surveys page. It takes less than 3 seconds to complete. Click the image below.
Member Website Updates: Newly Uploaded Info/Files
Web Site Statistics - Registered Members By Country
Click here or the image below to go to the Power web page for information and links to the membership website sales copy.
NOTE: MS Excel is a Registered Trademark and Copyright of Microsoft Corporation.
Corporate Finance Models