50 Excel Functions You Need to Know

Microsoft Excel is one of the most complete office automation software. It allows you to create complex spreadsheets and supports many functions. To perform certain actions, you have to go through quite complicated formulas. The Excel functions presented here are all available within Microsoft Excel 2010 in French. Very few differences exist with the other versions of the software, but you will have to translate these functions if you use Excel in English or in another language. If you use other functions on a daily basis, do not hesitate to present them in the comments! To go further, you can also train yourself to become an Excel expert . Mathematics and trigonometry RAND BETWEEN TERMINALS – In Excel, to get a random integer between two specified bounds. Example: RANDBETWEEN(1;42) returns a random number between 1 and 42. ROUND – Allows you to round a number, according to the number of digits after the specified comma.

Mathematics and Trigonometry

 

You can use another parameter instead of 2 to calculate . Allows you to test a condition and return a certain value if it is true, another if it is false. Example: IF(average(A1:A15) “I have the average”; “I don’t have the average”) allows to know if we have the average, when the scores are between cells A1 and A15. Research and matrices COLUMN – Gets the column number. Example: COLUMN(A42) returns Canada Business Fax List the value 1 because column A is the first column. Variant: COLUMN() returns the value corresponding to the column where the Excel formula is located. SEARCH – In some cases, search formulas can save lives. Example: SEARCH(42;A:A;B:B) will look for the value 42 in column A, then transcribe its equivalent in column B (on the same line). SEARCH can also be used to search in a matrix or a vector.

Research and Matrices

Canada Business Fax List
Canada Business Fax List

 

Same principle as LOOKUP, but to search for values ​​according to the first row of a matrix. Example: is used to return the second row of a column whose first row is city within a table. VLOOKUP – Same principle as HLOOKUP, but to search for values ​​according to the first column of a matrix.  is used to return the second column of a row whose first column is city within a table. TRANSPOSE – Transposes a matrix (transforms rows into columns and vice versa). Just remember to validate your formula using,  since it is a matrix calculation. Date and hour YEAR – To obtain the corresponding year at a more precise date. TODAY – As the name suggests, this feature displays today’s date. Example: TODAY() to display today’s date. You can also display the next day using TODAY()+1 and so on. NOW – Even more precise, this function allows you to obtain the exact date (year, month, day, hour, minute, second). The display depends on the format of the cell. Example: NOW() to display the exact date and time. END.MONTH – Returns the last day of the current month.

Leave a comment

Your email address will not be published.