Excel school training courses in El Paso, 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>>

Instruction in moving and copying, cell contents, sorting
mathematical, statistical, financial functions, date and
time arithmetic, report generation, and built-in graphics
support. Prerequisite: Knowledge of Windows preferred.

In this course, students will create and edit basic Microsoft® Office Excel® 2010 workbooks.

Objective :
Upon successful completion of this course, students will be able to: - create a basic worksheet using Microsoft® Office Excel® 2010. - perform calculations in an Excel worksheet. - modify an Excel worksheet. - format a worksheet. - print Excel workbook contents. - manage an Excel workbook.

At Course Completion:
Upon successful completion of this course, students will b...

Full archival course description>>

This course teaches the basic functions and features of Excel 2007. After an introduction to spreadsheet terminology and Excel’s window components, students will learn how to use the Help system and navigate worksheets and workbooks. Then they will enter and edit text, values, formulas, and pictures, and they will save workbooks in various formats. Students will also move and copy data, learn about absolute and relative references, and work with ranges, rows, and columns. This course also c...

Full archival course description>>