After completing this chapter, you will be able to:
| SLO 4.1 | Import data into Excel from a text file, database file, or a web site and use Flash Fill and data connections. |
| SLO 4.2 | Create and format an Excel table and a PivotTable and export data for use in other programs. |
| SLO 4.3 | Sort data by text, number, color, or icon. |
| SLO 4.4 | Apply an AutoFilter or an Advanced Filter to data. |
| SLO 4.5 | Use the Subtotal command and create groups and outlines. |
| SLO 4.6 | Apply and manage Conditional Formatting using cell rules, Color Scales, Icon Sets, and Data Bars. |
| SLO 4.7 | Use Goal Seek and protect a worksheet. |