Course Outline

Microsoft Excel 2007 - Level 2
Start conquering 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.

Customizing Excel

  • Understanding Excel Options
  • Navigating through the Options categories
  • Customizing the Quick Access Toolbar
  • Showing Mini Toolbars and Screen Tips
  • Enabling Live Preview

Working with Dates

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

Working with Cell Ranges

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

Working with Tables

  • Understanding good table layout concepts
  • Creating a Table
  • Using auto filters and advanced filters
  • Sorting a Table
  • Removing duplicates
  • Resizing a Table
  • Using the Name Manager
  • Formatting tables with Themes and Styles

Outlining and Grouping

  • Creating outline levels manually
  • Creating outline levels automatically
  • Showing and hiding data
  • Working with subtotals

Worksheet Functions

  • Understanding Formula AutoComplete
  • Use SUM to Add Nonadjacent Ranges
  • Using the Insert Function Command
  • Nesting Functions
  • Simple vs. Complex Functions
  • Using the PMT() Function
  • Using the IF() Logical Function
  • Using the AND() Operator within an IF()Statement
  • Nested IF() Statements
  • Using the VLOOKUP() Function

Linking

  • Linking Cells on the Same Worksheet
  • Linking Values between Worksheets
  • Linking Cells in Different Workbooks
  • Changing the Link Source
  • Changing from a Link to a Value
  • Breaking Links

Using Database Functions with Tables

  • Using the DSUM function
  • Using the DCOUNT function
  • Using the SUMIF and SUMIFS functions

Prerequisites:  Microsoft Excel Level 1 or equivalent experience.

Revised 11/28/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