Browse through the Function Library in the Formulas tab to learn more. Now let us see a few examples on how to insert and use functions.

Press F10, and small letters appear over each ribbon tab and quick access toolbar item. Alt+H takes you to the Home tab, ...

If you need to conditionally split values into multiple columns in Microsoft Excel, consider using the IF() function. Here's how.