Excel school training courses in Dover, DE (public, in-house or online)

Topics include entering and editing data and formulas, modifying worksheets, relative and absolute references, using functions, formatting worksheets, printing and basic charts as well as all of the exciting new features of Excel 2007.

Program Fundamentals

Starting Excel 2010

What’s New in Excel 2010

Understanding the Excel Program Screen

Giving Commands

Using Command Shortcuts

Creating a New Workbook

Opening a Workbook

Previewing and Printing a Worksheet

Saving a Workbook

Closing a Workbook

Using Help

Exiting Excel



Getting Started with Worksheets

Navigating a Worksheet

Entering Labels and Values
Full archival course description>>

Each student will receive:

A printed courseware manual for use during and after class.
Access to a searchable, electronic version of the courseware manual for reference after class (available for 12 months after class.)
Access to a Microsoft Excel 2010 eLearning course for reviewing course topics after class (available for 12 months after class.)
A PC headset for communicating with your instructor and fellow students during your Microsoft Excel 2007 Training Class
A cours...

Full archival course description>>

This course will cover getting started with Excel 2007. In this course, students will focus on manipulating and formatting data and reviewing and printing spreadsheets. The training also teaches Excel 2007 formulas, functions, charts, pictures, themes, styles, advanced formatting, advanced data management, advanced customization and how to analyzing data and to protect and share Excel 2007 workbooks.

1.Visual Basic Editor A.Visual Basic for Applications
B.Object programming
C.The Object Browser

2.Programming basics A.Data basics
B.Scope of variables
C.Scope of procedures

3.Control structures A.Decision structures
B.Loop structures

4.Custom dialog boxes A.User forms
B.Events

5.Debugging and error handling A.Errors
B.Debugging
C.Error handling