For example, the SUM function is a popular choice for quickly adding numbers. Instead of writing =A1+A2+A3+A4+A5, you can simply use =SUM (A1:A5). Note that these are both formulas, but only the ...

Formulas and functions, the nuts and bolts of Excel, both enable you to perform calculations, but they differ in how they're created, what they do, and how they work.

Learn the difference between formulas and functions and how the two can be combined to unlock the data-crunching potential of Microsoft Excel. The MSU Libraries offer three different Excel workshops: ...