Excel Formulas: 10 Formulas That Helped Me Keep My Job
Don’t waste any more hours in Microsoft Excel doing things manually. There are many ways to use Excel formulas to decrease the amount of time you spend in Excel and increase the accuracy of your data and your reports. Excel Formulas You Should Definitely Know: Formula: =SUM(5, 5) or =SUM(A1, B1) or =SUM(A1:B5) The SUM formula does exactly what you would expect. It allows you to add 2 or more numbers together. The above shows you different examples. Formula: =COUNT(A1:A10) The count formula counts the number of cells in a range that have numbers in them. This formula only works with numbers though: It only counts the cells where there are numbers. **Learn more about the COUNT function in this on-demand, online course. Formula: =COUNTA(A1:A10) Counts the number of non-empty cells in a range. The COUNTA Formula works with all data types. It counts the number of non-empty cells no matter the data type. Formula: =LEN(A1) The LEN formula counts the number of characters in a cell. Formula: =TRIM(A1) 8.
Related: technology & internet
• ICT Tools etc