Excel school training courses in Denver, CO (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>>

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)

At Course Completion:
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.

Outline :
Lesson 1: Creating a Basic Worksheet
Explore ...

Full archival course description>>

Students will learn how to create nested functions, export/import data, perform what-if analyses, use the Goal Seek and Solver utilities and record and run macros. This course is approved courseware for Microsoft Office Specialist certification.