June 2022
Beginner
400 pages
8h 35m
English
Spreadsheet Tips
The chart and function spreadsheet tips in this appendix complement the Spreadsheet Solutions that appear throughout this book. These tips enable you to learn more about creating or customizing charts and help you better understand the advanced statistical Excel functions that some solutions use. Tips apply equally to Microsoft Windows Excel and Microsoft Excel for Mac, except as noted.
The ordering of the data in a worksheet affects the ordering of the data in a visualization. Use the Excel sort command to reorder the rows of data based on a specified condition. In Windows Excel, select Home → Sort & Filter → Custom Sort. Then make the appropriate entries in the ...
Read now
Unlock full access