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 pivot tables. 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
Creating Pivot Table Reports

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 worksheets  

Protecting workbooks

  • Requiring a password to open a workbook
  • Specifying which cells can be changed
Prerequisites:  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