- NY Credits : 5.0
- TX Credits : 5.0
Microsoft Excel 2016 - Working with Data Ranges and Tables
This is a two-lesson intermediate level curse 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 and an Excel table; then use Table features to work the data.
Upon successful completion of this course, the user should be able to:
identify the guidelines for a well-organized data range,
recognize ways to sort, filter, and add totals to data ranges,
identify range and table differences, and
recognize ways to enter data and formulas in a table.