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. |
|