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 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.
In this tutorial you are going to learn how to hide worksheet Excel. This tutorial has been made on Excel 2010 and applies to this versions, as well as 2007.
In this tutorial, we will teach you how in Excel, the format date feature can be applied using Visual Basic. Basically, there are many vba excel format date keywords that can be used in your code to display the date in the format you want.
In this tutorial, we will guide you on how to search in Excel using visual basic. Visual Basic is a simple programming language developed by Microsoft. It is also integrated into several Microsoft Office applications. By using Visual Basic, we can add advanced functions using VBA scripts called macros. Usually macros are used to perform that needs to be carry out repeatedly.
As we have a very limited functionality of Search function in Excel therefore we can use the VBA macros to enhance search results as per our requirements. VBA Excel find script can be written in many ways depending on your needs. Here we are guiding you on creating a simple search in Excel VBA code.
In this tutorial we will guide you on how to save files in Excel using VBA. Visual Basic for applications (VBA) is a powerful programming language designed and developed by Microsoft. It is integrated in many Microsoft Office applications like Excel, Access etc. to helps users to create their own functions to perform specific tasks. Here we are showing you how a “Save as” option works by using Excel VBA. Instead of using the “Save as” button, we will record a macro and use the double click option in VBA Excel for save as function.
In this tutorial we will guide you on how to open an Excel file via VBA. Visual Basic for applications or VBA is designed by Microsoft to be used along with handful of Microsoft applications such as Excel or Access. It comes up with Microsoft Excel 2007 and 2010 as built in tool. By using VBA, we can record our own macros and write scripts for performing specific tasks as per our requirements. If you are working with Excel and you need to open a particular file over and over again then you may take help from VBA and write up a simple code to let VBA open the Excel File for you in a single click.
In this tutorial we will guide you on how to export Excel data to word using VBA.
For this tutorial, we will be working with this sheet over here. What we’re going to do is create a macro that allows the user to specify a separator and then export using VBA from Excel to Word file. In order to Export Excel Data, we will use some objects with multiple combinations and data range to export into a new Word Document. If Word document is already existed then the selected data will be added at the end of the existing document instead of creating a new one.
Home