3. Select a function from a group (Formulas tab) Narrow your search a bit and choose a formula subset for Financial, Logical, or Date/Time, for example. =TODAY () Inserts today’s date.

Excel 2019 adds six new functions for doing calculations. TEXTJOIN and CONCAT let you combine text strings from ranges of cells with or without using a delimiter separating each item, such as a comma.

Here’s a rundown of the tabs and what each one does: Home: This contains commonly used Excel features, such as inserting formulas, formatting tables, rows, cells and text, and sorting and filtering.