Week 4 - Formatting, Organizing, and Getting Data (Ch4)
Overview
Excel can use data from many sources, as well as provide data to other programs. When data are shared among applications, the data are usually in a list or table layout similar to a database. This chapter covers how to format data as an Excel table, how to sort and filter data, how to import data from other sources, and how to build a PivotTable.
Objectives
At the end of this week, you will be able to:
- Create and format a list as an Excel table.
- Apply Conditional Formatting rules as well as Color Scales, Icon Sets, and Data Bars.
- Sort data by one or more columns or by attribute.
- Filter data by using AutoFilters and by creating an Advanced Filter.
- Use subtotals, groups, and outlines for tabular data in a worksheet.
- Import data into an Excel worksheet from a text file, a database file, and other sources.
- Export Excel data as a text file and into a Word document.
- Build and format a PivotTable.
Learning Activities
- Read Excel Ch 4 (SIMBook) in SIMnet.
- Complete the end-of-chapter questions to check your knowledge (you are not required to submit these).
Assignments
- Complete Excel Ch 4 SIMBook 'Let Me Try' in-reading tasks.
- Complete Excel Ch 4 SIMnet Project 1.
- Complete Excel Ch 4 SIMnet Project 2.