Excel school training courses in Dallas, TX (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>>

You Will Learn How To

Summarize data with Excel by incorporating formulas, formatting, and charts and graphs
Efficiently navigate and manipulate multiple spreadsheets in a workbook
Optimize your worksheets using templates, graphs and formulas
Design simple-to-complex formulas by nesting Excel functions
Present data visually using Excel tables and charts
Import, fine-tune and share Excel data in your workgroup

Course Benefits

In today’s workplace, Mi...

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

This course is the second in a three-course series that satisfies the requirements for the Microsoft Office Specialist (MOS) certification. This course gives you an opportunity to work with some more advanced features of Excel 2002, including templates; sorting and filtering; importing and exporting; advanced formulas; analysis tools; and collaboration.

Goals/Objectives

· Use Excel templates and user-defined templates to create templates and workbooks.

· ...

Full archival course description>>