Appendix D. Spreadsheet Tips

These Spreadsheet Tips complement the Spreadsheet Solutions that appear throughout this book. Use these tips as a starting point to learn more about how to use Microsoft Excel or OpenOffice.org Calc 3 to obtain your own customized results. The tips are divided into three groups:

Chart Tips that assist you in creating and refining your own charts.

Function Tips that explain the worksheet statistical functions used in Spreadsheet Solutions

Analysis ToolPak Tips that review how to use selected Analysis ToolPak statistical procedures (Microsoft Excel only)

CT: Chart Tips

CT1 Arranging Data in Categorical Charts

You can sort your data to display categories in largest to smallest order. ...

Get Math for the Non-Math Lovers (Collection) 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.