A function in Excel is a predefined program operation that allows you to perform advanced calculations with numeric and alphanumeric data. It is executed using specific values known as arguments. To put this tool into use, you have to press the Fx button placed in the Excel formula bar.
By mastering Excel functions, you can create advanced formulas, allowing you to work more efficiently since the information you need will be processed more quickly. It is one of the most demanded skills in the labour sector and can make a difference when facing new professional and personal challenges. They offer a basic guide to learn more about the main Excel functions, formulas, and shortcuts, but you can expand your knowledge with courses. In Excel, simple formulas can be used to perform mathematical operations. You can try Excel Search Function method. The most common are the following
Add
To add with Excel formulas, you have to write the = sign, select the SUM function and then write the reference to the cells you want to add. The formula would look like this: =SUM(B2:B9). If you're going to perform a simple addition between cells, you can do it by adding the = sign and then writing the reference to the cells you want to add: =B2+B3.
Subtract
In Excel, there is no SUBTRACT function. The SUM function is used, and the numbers to be subtracted are converted to their negative values. To do a simple subtraction, you can do it by putting the subtraction symbol (-) between references. Excel Filter Function filters the amount according to your preference.
Multiply
Write the equals symbol, then the cells that you want to multiply are separated by the * symbol, which is the one that will make the multiplication effective. Excel Today Function can automatically make your row and column with a date formula.
VLOOKUP
It is one of the most used functions in Vlookup Excel and is used to find items in a table or a range by row. It consists of the following elements: =VLOOKUP (lookup value; lookup_array_in; column indicator; [sorted])
Excel is a program with numerous features and tools, all very useful for working with data of all kinds. Whether you're just starting to master Excel or you're already an expert, write down these tricks and shortcuts to improve and master the program completely:
Highlight duplicates. If several cells are in a sheet with duplicate content, you can insert a formula so that the program returns those duplicate results differently. To do this, select the rows or columns you want to analyze. Then click conditional formatting. There, select rules for highlighting cells, choose duplicate values , and hit ok. In this way, the repeated values will appear in another color.
Change rows to columns. While working in Excel, you decide to change the axes of a table and change rows to columns; to do so, you must select all the rows and columns and copy them to the clipboard with CTRL + C. In your chosen cell, right-click the mouse and select paste special. Once there, choose Transpose in the displayed menu, and you will have changed the rows by the columns of your table.
No comments yet