Excel 2007: Intermediate

Who it's For:

Office workers, business people, teachers, support staff, and anyone who wants to use the computer to track, figure out, and report information.

What it is:

Excel is the world's most popular spreadsheet program. Millions of people use it to track, store, arrange and calculate data.

What You'll Learn:

Our Excel course is designed for beginners and advanced users alike. Students learn how to easily work with data and use Excel's hidden features. You'll learn about spreadsheet design, manipulating data, and about how to utilize the world's most popular business tool.

Topics

Excel 2007 Intermediate Part 1

  • Well Defined List
  • Sorting
  • Sort by Multiple Fields
  • Auto Filters
  • Checkbox Filters
  • Removing Duplicates
  • Subtotal by One Field
  • Subtotal 2nd field
  • Subtotals at top
  • Format as Table
  • Color to Table
  • Total Row
  • Column Chart
  • Row Vs. Column
  • Format Series vs. Point
  • Color Gradient
  • Add Chart Title
  • Deleting Columns
  • Line chart
  • Data labels
  • Making pie charts
  • Saving Chart Template
  • Using Chart Template
  • Printing Charts

Excel 2007 Intermediate Part 2

  • Import from Access
  • Update in Access
  • Update in Excel
  • MS Query
  • Import Link to Text
  • Pivot Table
  • Multiples in pivot table
  • Formatting Pivot Tables
  • Report Filter
  • Table and Pivot Table
  • Filtering in Pivot Tables
  • Linking cells between Workbook
  • Link by Sheet
  • Link by formula
  • Link by pasting
  • Totals From Other Workbook
  • Custom views
  • Finding Top 3
  • Thresholds
  • Color Scales
  • Traffic Light Icons
  • Data Validation
  • Validation Boundaries
  • Conditional Format
  • Protect Sheet
  • Password protect the Excel file
  • Review