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

Designed to provide a thorough understanding of concepts that assist in designing worksheets for a variety of numerical reporting, budgeting and forecasting tasks. Instruction in terminology, machine use, program parameters, display characteristics, formatting features, mathematical functions, and printing. Gain skills to build, manage, save, retrieve, format, chart and print worksheets.

Course Description: Designed to provide a thorough understanding of concepts that
assist in designing worksheets for a variety of numerical reporting, budgeting and
forecasting tasks. Instruction in terminology, machine use, program parameters, display
characteristics, formatting features, mathematical functions, and printing. Gain skills to
build, manage, save, retrieve, format, chart and print worksheets. Prerequisites:
Fundamentals of PC Use, including Orientation to Windows, o...

Full archival course description>>

Course Description: Topics include enhancing worksheets, advanced formatting
techniques, advanced functions, database management, customizing charts, drawing
pictures, linking. Instructions in moving and copying, cell contents; sorting
mathematical, statistical, and financial functions; date and time arithmetic; report
generation; and built-in graphics support. Prerequisites: Excel Introduction or equivalent
experience.
Objectives: Every student will be able to:
· Manipulat...

Full archival course description>>