Excel school training courses in Allentown, PA (public, in-house or online)

Upon successful completion of this course, students will be able to:
enhance productivity and efficiency by streamlining your workflow.
collaborate with others using workbooks.
audit worksheets.
analyze data.
work with multiple workbooks.
import and export data.
use Excel with the web.
structure workbooks with XML.

Course Content

Lesson 1: Streamlining Workflow
Topic 1A: Create a Macro
Macros
The Record Macro Dialog Box
How to Create a Macro
T...

Full archival course description>>

Getting Started
Introducing Visual Basic for Applications
Recording a Macro
Running a Macro
Editing a Macro in the Visual Basic Editor
Understanding the Development Environment
Using Visual Basic Help
Closing the Visual Basic Editor

Working with Procedures and Functions
Understanding Modules
Creating a Standard Module
Understanding Procedures
Creating a Sub Procedure
Calling Procedures
Using the Immediate Window to Call Procedures
Creating a Funct...

Full archival course description>>

In this course, students create and edit basic Microsoft® Office Excel® 2007 worksheets and workbooks. (Second Edition)

Objective :
Upon successful completion of this course, students will be able to: - Explore the Microsoft® Office Excel® 2007 environment and create a basic worksheet. - Perform calculations. - Modify a worksheet. - Format a worksheet. - Print workbook contents. - Manage large workbooks.

At Course Completion:
Upon successful completion of this course, stu...

Full archival course description>>

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>>