Chapter 12. Working with Worksheet Data

No matter what you use your worksheets for, it’s important that you be able to easily extract meaning from the information and data they contain. Effective formatting is a must because it helps you find what you need at a glance and it makes your data stand out and be easily read.

Besides formatting, functions and formulas are the ways that take the data you’ve entered in your worksheet and perform calculations on it. You enter raw data, format it as you will, then tell Excel how to crunch the numbers. Excel provides you with a library of hundreds of predefined functions that will meet most of your calculation needs.

In this chapter, you’ll see how to format your data to derive easy meaning at a glance, ...

Get Microsoft Office for iPad: An Essential Guide to Microsoft Word, Excel, PowerPoint, and OneDrive now with the O’Reilly learning platform.

O’Reilly members experience live online training, plus books, videos, and digital content from nearly 200 publishers.