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.