How to Calculate Net Present Values in Excel

Introduction Net Present Value (NPV) is a widely used financial metric that helps investors and business managers to evaluate the profitability of an investment or project. NPV calculates the difference between the present value of cash inflows and the present value of cash outflows over a certain period. A positive NPV indicates that the investment … Read more

Excel Tips and Tricks for Financial Modeling

Financial modeling is an essential skill for finance professionals, allowing them to project financial performance, evaluate investment opportunities, and make informed decisions. Microsoft Excel is the go-to software for building financial models, thanks to its flexibility, functionality, and ease of use. In this blog post, we’ll share tips and tricks for maximizing efficiency and accuracy … Read more

Shortcut Key to Paste Values in Excel

If you came here looking for an easy shortcut key to paste values in Excel then it’s bad news I’m afraid – there just isn’t a simple keyboard shortcut in the same way there is to cut, copy or paste normally. However there is a way to paste values using the keyboard, which this tip … Read more

Display the Weekday as Text in Excel

I often want to know what day of the week a date is. The obvious choice in Excel is the WEEKDAY() function for this; however it only returns an integer. For example, the formula: =WEEKDAY(“01/02/2009”) returns 1 (which represents Sunday). In this article, I’ll describe the various ways which you can display the weekday as … Read more

Set Read Only Recommended in Excel

In this guide, we’ll explain how to set read only recommended in Excel. That means that whenever someone opens it, Excel will suggest they open it as read only. While setting read only recommended can prevent accidental modifications, users can still choose not to open as read only, so we’ll also cover adding passwords to … Read more