- NY Credits : 4.0
- TX Credits : 4.0
This is a two-lesson intermediate level course designed to guide you through organizing, entering, and validating worksheet data and then effectively sorting, filtering, subtotaling, and outlining the data. You will also learn how to define well-organized data as an Excel table and then use Table features to work with the data.
Upon successful completion of this course, the user should be able to:
identify guidelines for a well-organized data range,
recognize was to sort, filter, add subtotals, and grand totals to data ranges,
identify ways to define an Excel table, and
recognize ways to enter data and formulas in a table.