Excel 2007 Intermediate

Course Length

Full day

Prerequisites

Excel 2007 Introduction or equivalent experience

Course Description

This class is designed for the user interested in going beyond the basics of Excel. Users will learn how to use conditional formatting, create tables, sort, filter, outline, and connect cells, worksheets, and workbooks. Charting and more than twenty practical functions are included.

Course Topics

  • Use highlight cells rules
  • Clear rules
  • Use top/bottom rules
  • Apply data bars, color scales, & icon sets
  • Create, edit, & manage formatting rules
  • Create, navigate, move, & select a table
  • Change the table style option
  • Insert and delete rows and columns
  • Display calculations in the total row
  • Convert a table to a range
  • Sort rows by column(s), cell color, font color, icon, & using a built-in custom list
  • Create and remove a custom list
  • AutoFilter a list and clear an AutoFilter
  • Create a custom AutoFilter using criteria
  • AutoFilter by color or icon, top or bottom numbers, above or below average numbers, and advanced criteria
  • Convert text to columns
  • Remove duplicates
  • Manually outline a worksheet
  • Collapse, expand, ungroup, & clear an outline
  • Use Auto Outline
  • Create & remove subtotals & grand totals
  • Link cells by connecting worksheets
  • Link worksheets using a connecting formula and a connecting function
  • Link workbooks using a connecting formula and using a connecting function
  • Return the current date using TODAY
  • Return the current date & time using NOW
  • Return any date using DATE
  • Change the case of text using UPPER, LOWER, and PROPER
  • Remove excess spaces using TRIM
  • Repeat text using REPT
  • Extract with LEFT, RIGHT, & MID
  • Join text strings using CONCATENATE
  • Use VLOOKUP & HLOOKUP
  • Calculate a payment using PMT
  • Return the future value using FV
  • Use ROUND, ROUNDUP, & ROUNDDOWN
  • Truncate a number using TRUNC
  • Sum cells using SUMIF
  • Use IF and the nested IF function
  • Test for multiple criteria using AND & OR
  • Create, activate, move, resize, & delete an embedded chart
  • Print charts
  • Select, resize, and move a chart element
  • Change the layout of chart elements
  • Format chart elements

What Participants Receive

Each participant receives a guide containing step-by-step instructions and practice exercises.