Excel 2007 Intermediate

CW-052B Excel 2007 Intermediate

Synopsis: This course introduces skills for using large or multiple worksheets, advanced charting and conditional formatting, data table design and management of files. Students should understand the basics of creating simple worksheets and charts prior to taking this class.

Prerequisite: Successful completion of Excel 2007 Basic class or equivalent experience.

Length of Course: Self-paced, average 12-18 hours per course

Required Text: Clackamas Community College custom courseware will be provided at the first class.

Chapter 1 Working with Large Worksheets and Tables

  1. Freeze rows and columns
  2. Hide and unhide rows, columns, and worksheets
  3. Protect a cell, a worksheet, and a workbook
  4. Control calculation
  5. Print large worksheets
  6. Explore basic table management
  7. Sort data
  8. Filter and total data

Chapter 2 Data to Information

  1. Design tables based on data table theory
  2. Import data from text files and other sources
  3. Apply conditional formatting
  4. Apply advanced filtering and sorting methods
  5. Create and use range names
  6. Use database functions
  7. Create and delete PivotTables and PivotCharts
  8. Format, sort, filter, subtotal, and refresh a PivotTable

Chapter 3 Data Tables and Amortization Tables

  • Separate and combine text
  • Manipulate text with functions
  • Identify and remove duplicate rows
  • Group and subtotal data
  • Work with windows
  • Use conditional functions
  • Create nested IF functions
  • Use AND, OR, NOT, and IFERROR functions
  • Define the amortization table
  • Use functions in amortization tables