Type: Business Professionals

Platform: Windows

Versions: 97-2007

Workshop Manual: Price and Buy

Public Training: Review Our Workshops

Onsite Training: Details

Web Cast Information (New): Review Our Workshops

Workshop and Manual Overview

Microsoft Excel-Aided Business is a 1-5 day "hands-on" Microsoft Excel training workshop for business professionals that covers all the essential Microsoft Excel and Microsoft Excel VBA topics. Covered in the workshop are Microsoft Excel business topics like:

• Microsoft Excel worksheet fundamentals
• Business formula design on the Microsoft Excel worksheet including array and complex numbers operations
• How to use logic and database functions to create "smart" adaptive worksheets
• How to use the conditional formatting and data validation features in Microsoft Excel to monitor system requirements and create project alert displays
• Developing dynamic interlinked system models in Microsoft Excel using single and multi-team workbooks
• Matrix algebra, dynamic system simulation, boundary value problem, integration, differentiation and complex number solution techniques on the Microsoft Excel worksheet
• How to create business charts and generate business reports in Microsoft Excel
• Complete Microsoft Excel VBA and object oriented programming review
• How to use Microsoft Excel VBA to design your own business functions for the worksheet and how to distribute them to teams
• How to use ActiveX controls to create GUI's on the Microsoft Excel worksheet
• How to create event driven Microsoft Excel applications using VBA
• How to create and manage databases in Microsoft Excel and link with external databases using Excel's built-in features and VBA
• How to automatically create business charts using VBA
• How to integrate teams in Microsoft Excel over a network
• Using Microsoft Excel for data analysis tasks
• How to access external databases from Microsoft Excel
• Problem optimization in Microsoft Excel using single and multi-workbook based models
• How to use Microsoft Excel and VBA to control and integrate other programs written in C and VB
• How to design rapid analysis environments in Microsoft Excel
• How to design  wizards using VBA userforms in Excel
• How to provide navigation for your applications in Microsoft Excel
• How to package and provide security for applications in Microsoft Excel (Add-In's, templates and workbooks)
• How to construct verified team tools in Microsoft Excel
• How to construct and use VB ActiveX DLL's with Microsoft Excel
• How to use Microsoft Excel as a command and control center integrating other application data
• How to Use Framework CT Excelerator and Crystal Ball (Coming Soon)

It covers vital Microsoft Excel VBA skills that allow business professionals to exploit the full power of Microsoft Excel.

Microsoft Excel-Aided Business Workshop Particulars

Our Excel-Aided Business workshop is our next generation modular Microsoft Excel integrated training system consisting of 19 educational modules that cover basic to advanced Microsoft Excel business tasks. E.A.B covers Excel 97 and beyond for Windows and Macintosh and can be taught on-site as a 1-5 day modular workshop (your company chooses what it wants) or publicly as a 5-day workshop. E.A.B is taught "hands-on" via SVGA computer projection using integrated Microsoft Excel business examples. E.A.B was developed from consulting and training with customers such as:

• NASA

• Solar Turbines

• Verizon

• The US Air Force

• NORTHROP GRUMMAN

• Delphi Steering

• Rand

• Center for Naval Analysis

• Shell Energy

Workshop Materials 

• In its entirety, Excel-Aided Business contains over 1800 pages of helpful Excel and Visual Basic for Applications tips, strategies and procedures in a user friendly format.
• It illustrates Excel and Visual Basic for Applications topics using state of the art screen shots and 3-D graphics.
• Each workshop participant receives a comprehensive CD-ROM that contains the workshop examples, supplementary examples and reading materials.

Who Should Attend 

• Excel-Aided Business was designed to accommodate the Excel beginner as well as the advanced developer.
• It is intended for all types of business professionals.

EMAGENIT's Public Training Location

Public Location: Thousand Oaks, CA , LAX/Thousand Oaks

Hotel: Thousand Oaks Inn

EMAGENIT is based in Thousand Oaks, California which is in the vicinity of Los Angeles county (LA County), Ventura county, Santa Barbara county and San Diego county. We hold all of our on-site Microsoft Excel VBA courses nation wide. Our public workshops are a short commute for those living in the San Fernando Valley, Santa Clarita, Newbury Park, Camarillo, Calabasas, Sherman Oaks, Reseda, Woodland Hills, Hollywood, Fillmore, Ventura, Moorpark, Simi Valley, Santa Monica and Oxnard areas. For more information about our public workshops, visit our public workshops page our call us at the number above.