Microsoft Excel 2007

Microsoft Excel 2007 – Beginning (6-8 hours)

  • Spreadsheet Basics
  • Excel Basics (Screen, Menu)
  • Navigating Within a Worksheet
  • Changing the View
  • Using Help
  • Entering, Editing, Deleting & Undeleting Data
  • Working with Blocks
  • Adjusting Column Widths & Row Height
  • Creating & Filling Formulas
  • Entering Natural Language Formulas
  • Auto Fill
  • Using the Spell Checker
  • Saving, Opening & Printing Workbooks
  • Setting Print Options
  • Copying & Moving (Drag & Drop)
  • The Office Clipboard
  • Formatting (Alignment, Attributes, Borders)
  • Inserting & Deleting Rows/Columns
  • Using Built-In Functions
  • Customizing Cell Formats
  • Cell Styles
  • The Format Painter
  • Working with Charts
  • Absolute Addressing
  • Document Recovery
  • Using & Creating Templates

Microsoft Excel 2007 – Intermediate (6-8 hours)

  • Find/Replace
  • Using Block Names
  • Working With Dates
  • Advanced Functions
  • Creating a Database
  • Sorting Records
  • AutoFilter & Custom Filters
  • Working with Tables
  • Working with Macros
  • Creating an Array Formula
  • Linking Files
  • Creating a Workspace
  • Protecting Blocks/Worksheets
  • Freezing Panes
  • Splitting the Screen
  • Hiding Columns/Blocks
  • Multiple Worksheets & Tabs
  • Working with Chart Sheets
  • Hyperlinks
  • Sharing Workbooks
  • Tracking Changes
  • Adding Cell Comments
  • Conditional Formatting
  • Formatting Shortcuts
  • Custom Formats

Microsoft Excel 2007 – Advanced (6-8 hours)

  • Creating Outlines
  • Pivot Tables & Pivot Charts
  • Advanced Chart Options
  • Adding Clipart, Graphic Files, AutoShapes
  • Adding Word Art
  • Using the Goal Seeker
  • Creating Scenarios
  • Adding an Outlook Task
  • Consolidating Data
  • Importing & Exporting
  • Customizing the Toolbar
  • Working with Styles
  • Custom Views
  • File Properties
  • Setting Program Options
  • Sending Workbooks
  • Creating Web Pages