Extras

These extra tricks are the icing on the cake. Don’t underestimate the power of these time-saving formulas.

How to use the & operator

Combine content from multiple cells into a single cell.

How to use the month, day, and year functions

Simplify your survey’s timestamp data by focusing on just the details you need, like the month and day that the survey was submitted.

How to use the today and now functions

Randbetween

Generate random numbers.

Lower, upper, and proper

Use =lower to transform uppercase letters to lowercase letters, use =upper to transform lowercase letters into uppercase letters, and use =proper for proper names.

Left, right, and mid

Use the left, mid, and right formulas to parse your ID numbers.

How to transpose data

How to find out which formulas are available in Excel

Students have been asking how I find out which formulas are available in Excel. In this video, you’ll learn three ways to find out which formulas are available in Excel: 1) the autosum icon, 2) the formulas tab, and 3) the function bar.