Now we are going to see how works the OFFSET function. With the OFFSET function you can returns a reference that is a number of rows and a number of columns from a cell or range of cells selected With this function you can get the specific value in a database, that allows you to search information in big lists of data Let’s see the video and learn how to use the OFFSET function, you can use it with the MATCH function explained in the last video and search specific values in a Database. You can learn more about Microsoft Excel functions and applications here: Excel Training Videos
In the following video, we are going to use the MATCH function, this functions used with another useful function the OFFSET function, allows you to search specific values in a database
These two functions are really easy to use, and when you learn to use it very well you can get the most out of the manipulation of data in large lists Let’s see the video and learn how to use initialy the MATCH function and let’s begin to get data of big lists and databases.
Excel has more and less 300 functions and you can make a lot of formulas to simplify your work. Learn how to construct formulas with the following tool: Excel Formula Helper E-Book
In Microsoft Excel, you can manage all your tasks, or to-do lists in an easy way. With the following video you can see how easy you can manage your time. You now can see that Excel is a place where you can make a lot of things, including some simple applications that allows you to save time.
One of the most commonly used financial functions in Excel are Present value (PV) and Future Value (FV). Both functions use similar arguments so it is only necessary to understand the terminology to use them properly.
The PV() and FV() functions in Excel The arguments for those functions are:
– Nper: The total number of periods. For example, if a monthly payment is made for one year periods total will be 12. If a payment is made monthly for 3 years we will have a total of 36 periods.
– PMT: The payment made each period.
– Rate: The constant interest rate for each period. When we use financial functions must remember that the values can be positive or negative depending on whether you are receiving money or if you are paying. Another important thing to note is that generally interest rates are expressed on an annual basis, so if you’re doing a monthly calculation we divide the interest rate by 12.
The basic sintax for both functions is the following:
PV (Rate, Nper, PMT)
FV (Rate, Nper, PMT) Now, see the following calculations:
In this example I have used the same parameters for both the VA function and for the VF function. The future value helps us know how much money we will have in a future date if you start investing today the amount specified with a fixed interest rate. The present value is the value today that we will be making an investment in future payments at a fixed interest rate. Excel Total
This is an Employee Database VBA Code in Microsoft Excel. Here you can learn how to construct the code in VBA that allows you to manage the employee database in your business. Save a lot of time creating this Excel Application using VBA code and Userforms. You can change the Userform too and customize it to your needs, learn the code logic and change the parameters that you need.
Use the Microsoft Excel program to manipulate databases. You can make filters to only get one unique person. In this video, we are going to learn how to use the Advanced Filter feature
To create interactive Workbooks, to allow a good experience for the users of a Workbook or a Worksheet, create Userforms, that allows you to get data and put it in specific cells.
The main sections in Microsoft Excel are: The Workbooks and the Worksheets, there are where you are going to work.
Learn to use the Min and Max functions in Excel to find the highest and lowest values and to use the Small and Large functions to return the nth ranked value in a range of cells.
Learn how to use the Quick Access Toolbar, showed in the left upper corner of the Excel Window.
In this bar you can put every excel command that you use frequently. The most common are the Save button, Print Preview button, Undo and Redo commands, and so on.
But if you right-click you can enter to the customizing menu, and put the Excel command that you use very often. See in the following video how to customize the Quick Access Toolbar: