Course Outline

Microsoft Excel Level 2
Success starts with having important business information at your fingertips. Expand your spreadsheet skills by using powerful functions. Work with relative and absolute references. Link multiple worksheets, use range names, and create lists. 6 hours
Reviewing the Basics
  • Touring the Excel workspace
  • Understanding pointer shapes
  • Using Undo and Redo
  • Using Excel's menus and toolbars
  • Activating another cell
  • Making selections within a worksheet
  • Using navigation keys
  • Working with sheet tabs
  • Using AutoSum to add rows and columns

Customizing Toolbars and Menus

  • Displaying more buttons
  • Hiding or displaying toolbars
  • Customizing a toolbar
  • Moving, floating, and docking toolbars

Working with Dates

  • Interpreting two-digit years
  • Date functions
  • Date formatting

Outlining

  • Creating outline levels manually
  • Creating outline levels automatically

Naming Cells

  • Using the Name box to create a range name
  • Naming cells by using existing row and column labels

Worksheet Functions

  • Using the Formula Palette
  • Nesting functions
  • Simple vs. complex functions
  • Using the PMT() function
  • Using the IF() logical function
  • Using the VLOOKUP() function

Linking

  • Linking two cells within a worksheet
  • Linking cells between two worksheets
  • Linking cells between two workbooks

Working with Excel Lists

  • Creating a list
  • Using the Data Form
  • Sorting a list
  • Filtering a list using AutoFilter
  • Counting and summing filtered data
  • Advanced filtering
  • Using Database functions with lists
  • Creating automatic subtotals in a list

Protecting your workbook

  • Requiring a password to open a workbook
  • Specifying which cells can be changed
Prerequisites:  MS Excel Level 1 or equivalent experience.
Return to Class Schedules             Computer Magic Training Home Page
Computer Magic Training • 4030 Moorpark Avenue • Suite 108 • San Jose, California 95117 • 408-261-2600