- NY Credits : 5.0
- TX Credits : 5.0
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.
This intermediate level course is most appropriate for the professional with detailed knowledge in this topic or the professional seeking to expand his or her knowledge base and who may be at a mid-level position within an organization with operational or supervisory responsibilities, or both.
Upon successful completion of this course, the user should be able to:
identify the guidelines for a well-organized data range; select ways to create, sort, and test validation rules; select the Data Form for data entry, and
identify data range and table differences; identify multiple ways to define an Excel table using buttons on the Home and Insert tabs, the Quick Analysis feature, a keyboard shortcut, and by formatting a data range as a table.