Excel 2007 Training

Excel 2007 Training Videos on CD or DVD

Excel 2007 Training Course

Hosted by Debbie Dalrymple
Approx. 6 hrs. of Excel training on CD or DVD

This Excel 2007 training course will help you maximize your understanding of the most popular spreadsheet application in the marketplace today. Excel instructor, Debbie Dalrymple, guides you through the use of everything from basic spreadsheet functions to very advanced techniques ensuring your success and enhanced productivity with step-by-step, easy to understand video lessons and interactive hands-on labs.

 

Excel 2007 Training Series

Part#: mk-exc07 | Contents: Set of 3 CD-ROMs or 3 DVDs or via Online

Format

Reg: $149.00
Sale: $139.00
*No tax except for Maryland (USA) residents.

Shipping: Economy shipping allow 4-7 business days for delivery*

Payment options:

Order securely online or call 1-888-797-4040 (301-589-3349)

All major credit cards (Visa, MasterCard, Amex, and Discover)

PayPal: Pay online quickly with your PayPal account

Company PO's accepted (Net 30); Call for multi-user license

CD-ROM based trainingMultimedia CD-ROM & DVD Based Training:
With CD & DVD based training, the lectures were video taped and then digitized and are presented to you in Full Motion Video, Audio, & Graphics. DVD-ROMs will run only on a computer DVD Drive and will not run on a TV DVD Player. DVD-Video will run on both a computer DVD Drive and a TV DVD Player.

System Requirements: 400 MHz Processor (minimum), CD-ROM Drive (for CDs), DVD Drive (for DVD-ROMs & DVD-Videos) or TV DVD Player (for DVD-Videos), 64 MB RAM, Sound Card. Available Hard Disk Space 200 MB. Windows 98, NT, ME, 2000, XP, Vista, Windows 7, or Apple Mac.

Excel 2007 Trainer: Debbie Dalrymple
Debbie has been doing computer training since 1992. Starting her training career at Computer Learning Center in Washington DC working with DOS and early Windows applications she has transitioned to the latest Windows software that we know today. Throughout the past two decades Debbie has been training students and providing technical support and consulting services in a variety of other industries such as Architecture, Law, Federal Government, Pharmaceutical and the Oil Industry as well as extensive non-profit work.

Course Outline - Excel 2007 Training:

Approx. 6 hrs. of training

EXCEL 2007 BASIC

Creating a Basic Worksheet

  • Explore the User Interface and the Ribbon
  • Customize the Quick Access Toolbar
  • Navigate and Select in Excel
  • Enter Data and Save a Workbook

Performing Calculations

  • Create Basic Formulas
  • Calculate with Functions
  • Copy Formulas and Functions

Modifying a Worksheet

  • Manipulate Data
  • Working with Cells, Columns, and Rows
  • Search for Data in a Worksheet
  • Spell Check a Worksheet

Formatting a Worksheet

  • Modify Fonts
  • Add Borders and Color to Cells
  • Change Column Width and Row Height
  • Apply Number Formats
  • Using Styles

Printing Workbook Contents

  • Print Workbook Contents Using Default Print Options
  • Setting Page Breaks

Managing Large Workbooks

  • Format Worksheet Tabs
  • Manage Worksheets in a Workbook
  • Manage the View of Large Worksheets

EXCEL 2007 INTERMEDIATE

Calculating Data with Advanced Formulas

  • Manage Cell and Range Names
  • Calculating Data Across Worksheets
  • Analyzing Data with Logical and Lookup Functions

Organizing Worksheet and Table Data

  • Creating and Modifying Tables
  • Formatting Tables
  • Sorting or Filtering Worksheet or Table Data
  • Calculating Data in a Table or Worksheet

Presenting Data Using Charts

  • How to Create a Chart
  • Modifying Charts
  • Formatting Charts

Analyzing Data Using PivotTables and PivotCharts

  • Creating a PivotTable Report
  • Analyzing and Modifying a PivotTable

Inserting Graphic Objects

  • Inserting and Modifying Pictures and ClipArt
  • Drawing and Modifying Shapes

Customizing and Enhancing Workbooks and the Excel Environment

  • How to Customize the Excel Environment
  • Customizing Workbooks
  • Managing Themes
  • How to Create and Use Templates

EXCEL 2007 ADVANCED

Streamlining Workflow

  • Creating Macros
  • Adding Macros to the Quick Access Toolbar
  • Editing a Macro
  • Using Conditional Formatting
  • Applying Data Validation to a Worksheet
  • Updating Workbook Properties
  • Modifying Excel Options

Collaborating with Others

  • Protecting Files and Sharing Workbooks
  • Merging Multiple Workbooks
  • Adjusting Macro Settings
  • Restricting Document Access

Auditing Worksheets

  • Tracing Cell Precedents and Dependents
  • Troubleshooting Errors in Formulas
  • Watching and Evaluating Formulas
  • Creating a Data List Outline

Analyzing Data

  • Adding a Trend Line to Charts
  • Create Scenarios and Performing What-If Analysis

Working with Multiple Workbooks

  • Create a Workspace
  • Consolidate Data
  • Managing Linked Cells in Different Workbooks

Importing and Exporting Data

  • Exporting Excel Data
  • Importing a Table from Word
  • Importing a Delimited Text File
Hands-on, Multimedia, and Self-paced Training
Featured Customers
Free Newsletter
Reg. price: $149.00
Sale price: $139.00

Format

Product Details
  • Part#: mk-exc07
  • Contents: Set of 3 CD-ROMs or 3 DVDs or via Online
  • Economy Shipping: Allow 4-7 business days for delivery*
Payment Options
  • Order securely online or call 1-888-797-4040 (301-589-3349)
  • All major credit cards (Visa, MasterCard, Amex, and Discover)
  • PayPal: Pay online quickly with your PayPal account
  • Company PO's accepted (Net 30); Call for multi-user license
  • *No tax except for Maryland (USA) residents.
Guarantees

Content on this page requires a newer version of Adobe Flash Player.

Get Adobe Flash player