Microsoft® Excel® 2013: Working with Data Ranges and Tables is published by kbuuk.com in April 2015. This book has 204 pages in English, ISBN-13 B00WMUXRRO.
Microsoft® Excel® 2013: Working with Data Ranges and Tables is a two-lesson intermediate level course that guides you through organizing, entering and validating worksheet data and then effectively sorting, filtering, subtotaling, and outlining the data. You also learn how to define well-organized data as an Excel table; then use Table features to work with the data.
In Lesson 1 you learn how to organize columns and rows of data into a range so that you can effectively sort, filter, subtotal, and outline the data. Then you learn how to protect the data from invalid data entry by setting data validation rules for specific cells. You learn how to copy these validation rules to other cells, how to remove validation rules from cells and how to use the Data Form dialog box to enter and locate data in a range.
Next you learn how to sort a data range on one column or on multiple columns and how to use a custom sort order, the Filter (AutoFilter) feature and the Advanced Filter feature to view data that meets specific criteria. Then you learn how to add and remove subtotals from a data range while viewing the data range in outline form. You also learn how to create a chart using an outline’s subtotals.