Course Outline

Microsoft Excel - Level 2
Are you ready to begin to conquer the power of Excel? This course can take you from the simple to the complex, greatly increase your productivity and propel you to the next level. Link multiple worksheets to automatically update data in other spreadsheets and use Excel as a database. Filter your data to save valuable time and create complex formulas and functions to take the drudgery out of calculations. 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.

Revised 8/14/2011
Return to Class Schedules             Computer Magic Training Home Page
Computer Magic Training • 4030 Moorpark Avenue • Suite 108 • San Jose, California 95117 • 408-261-2600