These extra tricks are the icing on the cake. Don’t underestimate the power of these time-saving formulas.
My favorite time-savers include:
- How to use the & operator
- How to use the month, day, and year functions
- How to use the today and now functions
- How to generate random numbers using randbetween
- How to use the lower, upper, and proper functions
- How to use the left, mid, and right functions
- How to transpose data
- How to find out which formulas are available in Excel
Or, watch the entire extras playlist in YouTube.
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
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.
Return to top