Excel school training courses in Durham, NC (public, in-house or online)

Explore Microsoft Excel 2010 using hands-on, skills-building exercises. View, create, format, and print spreadsheets and workbooks. Develop and update formulas and work with built-in functions. Produce, edit, and customize charts. Textbook included. Basic competency in word processing is recommended

Student will learn to create and run macros, use the VB editor, learn the use of Interface Boxes, variables and Conditional Routines.


Outline :
Lesson 1: Introduction
Applications Interfaces
Options
Setup


Lesson 2: Programming Languages
OOP & The Excel Object Model
Macros vs. Programming


Lesson 3: Creating & Running Macros
Macros in Excel
Using Macros to Learn & Use Code
Using Macros to Learn Objects


Lesson 4: Visual ...

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

In this course, students create and edit basic Microsoft® Office Excel® 2007 worksheets and workbooks.
Who should attend:
This course is designed for people preparing for certification as a Microsoft Office Specialist in Excel, who already have knowledge of Microsoft® Office, Windows® 2000 (or above), and who desire to gain the skills necessary to create, edit, format, and print basic Microsoft Office Excel 2007 worksheets.
At completion:
Upon successful completion of this course...

Full archival course description>>

Student will learn to create and run macros, use the VB editor, learn the use of Interface Boxes, variables and Conditional Routines.
Who should attend:

At completion:

Pre-requisite:

Outline:

Lesson 1: Introduction

Applications Interfaces
Options
Setup

Lesson 2: Programming Languages

OOP & The Excel Object Model
Macros vs. Programming

Lesson 3: Creating & Running Macros

Macros in Excel
Using Macros to Learn & U...

Full archival course description>>