## 17 Excel functions to master in 2017

17 Excel Functions to use in 2017.

Versatility of Excel’s built-in functions is undeniably one of the main reasons behind this program’s popularity. As users, we have the flexibility to compose complex formulas incorporating multiple functions in our solution to achieve substantial gains in productivity. Most people have their own go-to Excel functions, be it: financial, date & time, math & trigonometry, statistics, look up & reference, database, text (manipulation), or logical. We’ve covered some of these functions already, but below is a compilation of 17 relatively under-used Excel functions you might want to add to your professional repertoire in the new year. Fair warning, you might need to have Office 365 version of Excel for all of the functions to work.

1. PMT
2. DATEDIF
3. LARGE
4. REPT
5. LEN
6. TRIM
7. SUBSTITUTE
8. TEXT
9. IFS
10. CONVERT
11. NETWORKDAYS
12. HLOOKUP
13. INDIRECT
14. OFFSET
15. TRANSPOSE
16. DSUM
17. RAND
BONUS: SUMPRODUCT

## Calculating age without DateDif function – Mission Impossible?

Calculate your age, WITHOUT using Excel’s DateDif function.

My previous post on using Excel’s DATEDIF function resulted in rather productive discussions on LinkedIn. First of all, some users are concerned that the DATEDIF function will no longer be supported in Excel and will cease to exist at some point in the future. Microsoft openly states that “this function is provided for compatibility with Lotus 1-2-3.” , and given the history of this support, I don’t see why it will be discontinued. Nonetheless, I will make an attempt to replace DATEDIF function with other functions readily available in the program. Secondly, as a reminder that English is not the only language in the world, Microsoft created “local” versions of this function. A user confirmed existence of the SIFECHA function, but the syntax to use it, involves using semicolons, instead of commas. If you are using Spanish version of Excel, you might want to try both versions:

```SIFECHA(fecha_inicial,fecha_final,unidad)