Back to Excel course main page

The Basics of Excel Formulas

In the basics of Excel formulas lecture we’ll first mix numbers and text to create generic sentences from the observations and try simple mathematical operations. The formulas in this example are IF() and SUM().

Exercises

Try the formulas seen in the video. Some other easy formulas to try are also COUNT(), COUNTA(), LEN(), RAND(), TODAY() and UPPER().

Lecture materials

Lecture 3 - The Basics of Excel Formulas

Video