In this tutorial, you will learn how to use the OFFSET function in Excel.
The offset function returns a reference to a range that is a given number of arrows and columns away from a given reference.
In our example, we will want to check the last entries of column A and column B, the Date and the Closing Rate respectively.
In this tutorial, you will learn to calculate Net Present Value, or NPV, in Excel.
Net Present Value is a financial function that is calculated for an investment, and it represents the present value of the investment minus the amount of money that costs to buy in. Excel offers a preset function for this called NPV.
Please be aware that all the investment cash flows must occur at the same interval for the calculation to be accurate.
NPV has two arguments: rate – which refers to the discount rate, and the range of values that contains future cash flows.
In this tutorial, we will show you how to create an And OR query in Microsoft Access. When you want to limit the results of a query based on the values in a field, you use query criteria. A query criterion is an expression that Access compares to query field values to determine whether to include the record that contains each value. Creating a query is easy in ms access.
Consider this sample database over here. This table contains the complete details of the customers. What if you want to view the customers of a specific city?
In this tutorial, we will teach you how to turn on or off Outlook autocorrect. We will also teach you how to disable the replace text feature. This feature replaces the typo with the correct text automatically. In this tutorial, we will disable autocorrect features in Outlook.
In this tutorial you will learn how to change the default font in Outlook 2010. This can be a useful trick for getting the precise look you want when reading your emails.
Microsoft OneNote is a Microsoft Application that allows you to take notes and clip snippets from the web. In this tutorial you will learn how to share your OneNote notes with other users in your network.
The battle between Android vs iPhone is one that has been going on for many years now. This video is going to look at how the two phones compare today. Bear in mind that Android is an operating system present on many different phones, whereas the iPhone is a single range of devices.
In this tutorial you will learn how get First Aid classes on your iPhone. We will be downloading and using the free app called First Aid by American Red Cross. This app features detailed information about various first aid situations.
In this tutorial, we will teach you how to change caps to lowercase in Excel.
Many a times, a user might type in text without realizing that the entire text was written with the Caps lock turned on. The user can either re-type everything again in the lowercase or can convert the text written in caps to lowercase.
In this tutorial, you will learn how to use the HLOOKUP function in Excel.
There are times when you want to calculate a value which resides in a separate table, but don’t want to use IF commands for this. Lookups, vertical and horizontal, provide you with just the means to do it.
In our example, we have our Horizontal Table in the same spreadsheet, but it could easily be in a separate one, or even in a separate workbook. As you can see, the table is an index of tax rates according to the offered salary. If such rules change along the way, we will need only to modify the Horizontal Table.
Home