Introduction

Once you enter data in a worksheet, you’ll want to add formulas to perform calculations. Microsoft Excel can help you get the results you need. Formulas can be very basic entries to more complex ones. The difficulty of the formula depends on the complexity of the result you want from your data. For instance, if you are simply looking to total this months sales, then the formula would add your sales number and provide the result. However, if you were looking to show this months sales, greater than $100.00 with repeat customers, you would take a bit more time to design the formula.

Because Excel automatically recalculates formulas, your worksheets remain accurate and up-to-date no matter how often you change the data. Using absolute ...

Get Excel® 2013 On Demand now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.