What is the DISC Function? DISC is a financial function that allows you to calculate the discount rate of a bond. DISC Formula & Parameters The Excel function is written in the following manner: =DISC(settlement, maturity, pr, redemption, [basis]) Parameters Basis Day Count basis 0 or blank US(NASD) 30/360 1 Actual/actual 2 Actual/360 3 Actual/365 4 European 30/360 … Read more
What is MAC address? A media access control address (MAC address) is a unique identification assigned to a device network interface controller (NIC) for communication at the data link layer of a network segment. In simple words, this is a unique identification for a device or computer in a network for communication. You can get … Read more
In this article, you’re going to learn how to use the Excel Functions Index and Match. What Index Does This function gives you the value of a cell in a range based on its row and column number. What Match Does This function finds the position of a value in a range. It tells you … Read more
The LEFT RIGHT function is compatible with all versions of Excel right the way back to 2007. About LEFT and RIGHT functions The LEFT and RIGHT functions let you extract a number of letters from a string of text, starting from the left most character or right most character respectively. LEFT and RIGHT are Worksheet functions that … Read more
When you have large amount of data in multiple sheets and you want to get the search results dynamically as you type , you can add a user form in excel vba and create a search box as below. Display search result in listbox from all sheets as you type To create this search box, … Read more
In VBA we can assign the color property of the object by changing or assigning the color index. There are 56 color index which you can use in vba. Below are the list of color indexes you can use in vba. Below is the VBA code to list out the color and color codes in … Read more
When you move your mouse pointer over a ribbon command, you will see a pop-up box that contains the command’s name, as well as a brief description. For the most part, the commands in the Ribbon work just as you would expect them to. Below are the different style of commands on the Ribbon: Simple buttons Click the … Read more
How to write Macro to create bulk pdf in Excel ? Excel vba pdf : Excel VBA programming is a powerful tool to automate the task. We can automate the repetitive task and save lot of time in work. Mastering excel vba will definitly help us in improving the work efficiency. In this post you can … Read more
Excel is a spread sheet software developed by Microsoft, used for numerical calculations data analysis. This is a widely used user friendly software which helps in storing the data, numerical calculation, graphs and charts, dashboard reporting etc. Below are the top 8 best Uses of Excel spread sheet software:- 1. Numerical calculations:- This type of software … Read more