Microsoft Excel and Microsoft Excel VBA Public and Webcast Workshop Schedule and Enrollment

In our Microsoft Excel Public and Webcast workshops, we can train you in Thousand Oaks, CA or over the web via a live broadcast. All of our workshops are "hands-on" and we customize the workshop to the needs of the attendees. You can find the location, pricing and enrollment buttons below in each class section>>>

Call us at:   1.805.498.7162     1.805.558.9277--

Learn about how we can help your company or yourself achieve your Microsoft Excel training or self-study goals Visit our free Microsoft Excel and Microsoft Excel VBA resource center Learn how we can help save your company money with our innovative software solutions Visit out VBA code center for code that can save your company money Learn about our Excel Add-In software that can save your company time and money View our customer list from our 12 years in business Phone numbers, request form and email address Learn about EMAGENIT View our training schedule for Microsoft Excel and Microsoft Excel VBA

Public and Webinar Workshop Index

General Excel Training VBA (Macro) Training for Business VBA (Macro) Training for Engineers/Scientists

Beginning Microsoft Excel

Beginning Excel VBA (Macros)

Beginning Excel VBA (Macros)

Intermediate Microsoft Excel

Advanced Excel VBA (Macros)

Advanced Excel VBA (Macros)

Advanced Microsoft Excel    

Microsoft Excel for Engineers and Scientists

 

 
 

 Business Workshops

Beginning Microsoft Excel Training for Business (1-day)

Our "basic" Microsoft Excel business workshop shows you the fundamentals of Excel like entering data, formatting, copying and pasting, basic formula construction, auto summing and more. It not only teaches you the basics of Microsoft Excel but the thinking and mechanics of how to apply it to your everyday problems.

Questions? Call us at:   1.805.498.7162     1.805.558.9277--

Beginning Excel Training Focus

Our "hands-on" beginning Excel training shows you the fundamentals of Excel like entering data, formatting, copying and pasting, basic formula construction, auto summing and more. It not only teaches you the basics of Microsoft Excel but the thinking and mechanics of how to apply it to your everyday problems. In all of our workshops, we evaluate our clienteles' knowledge level, their problems and adjust our curriculum to their specific needs. For a complete outline, click the Workshop Outline button below.

Workshop Details

  • About EMAGENIT. Our Customers.

  • Personal examples: Covered in-class

  • Excel Versions: 2000-2010

  • Type: Business Professionals

  • Platform: Windows or Mac

  • Training Materials: Included, 1800+ page manual including our Excel Add-Ins

  • Training Method: Hands-on, interactive

  • Repeat this workshop for free as many times as you want. View offer details

What You Learn at a Glance

  • Basic data entry

  • Number formatting

  • Basic formula construction

  • How to use SUM, Max and Min

  • Coping and pasting

  • Sorting and filtering data

  • Basic worksheet formatting like bolding, aligning, row/column adjustments

Self-Study Manual Purchase (Manual Included with Workshop)

Our Microsoft Excel manuals support business, engineering and science professionals depending on the version ordered. We design our Excel self study and Excel Visual Basic self study manuals around real world problems facing business professionals, engineers and scientists.

Beginning Microsoft Excel Training for Business Public Meeting Signup
Dates Enroll View Cart Location Cost Facility Time
03/05/12  
 
 Thousand Oaks, CA $190.00 Thousand Oaks Inn, Directions/Thousand Oaks Info 8:30 A.M.-4:00 P.M. PST
04/02/12  
 
 Thousand Oaks, CA $190.00 Thousand Oaks Inn, Directions/Thousand Oaks Info 8:30 A.M.-4:00 P.M. PST
05/09/12  
 
 Thousand Oaks, CA $190.00 Thousand Oaks Inn, Directions/Thousand Oaks Info 8:30 A.M.-4:00 P.M. PST

EMAGENIT staff will contact you within one business day of enrollment. If you have any questions, please call us at 1.805.498.7162. Also, military and government discounts available. Contact us directly for more details.

 

 

 

Intermediate Microsoft Excel Training for Business (1-day)

Our "data processing and formulas" Microsoft Excel workshop that shows you how to build power formulas using VLOOKUP, IF, SUMIF..etc, build pivot tables, process text files, process and analyze worksheet data, link to Word and PowerPoint and more.

Questions? Call us at:   1.805.498.7162     1.805.558.9277--

Intermediate Excel Training Focus

Our "hands-on" intermediate Excel training focuses on useful formula design for data processing and modeling, using Excel's built-in range features like Data Validation, useful worksheet functions like VLookup and applying Excel's built-in data processing tools and worksheet functions to analyze and clean text files and worksheet tables. We teach you how to develop analysis and data processing problems on the worksheet then how to determine the proper Excel tools to create a unique solution. In all of our workshops, we evaluate our clienteles' knowledge level, their problems and adjust our curriculum to their specific needs. For a complete outline, click the Workshop Outline button below.

Workshop Details

  • About EMAGENIT. Our Customers.

  • Personal examples: Covered in-class

  • Excel Versions: 2000-2010

  • Type: Business Professionals

  • Platform: Windows or Mac

  • Training Materials: Included, 1800+ page manual including our Excel Add-Ins

  • Training Method: Hands-on, interactive

  • Repeat this workshop for free as many times as you want. View offer details

What You Learn at a Glance

  • Filtering data using Auto Filter and  Advanced Filter

  • Working with text files using Text Wizard and Text to Columns

  • Cleaning and restoring text in files using the Left, Right, Mid, Substitute, Clean and Trim worksheet functions

  • Using Data Validation and Conditional Formatting

  • Perform table lookups using VLookup and HLookup, Match, Index and Indirect

  • Build summary/pricing worksheets

  • Build pricing sheets that can toggle between pricing tables

  • Build array formulas using VLookup, HLookup, CountIf, Match and SumIf...etc

  • Use logic in formulas (IF, And, Or)

  • Name cells and ranges

  • Create dynamic ranges in formulas that adjust to data

  • Link Excel to Word and PowerPoint for reports

  • Build basic pivot tables

Self-Study Manual Purchase (Manual Included with Workshop)

Our Microsoft Excel manuals support business, engineering and science professionals depending on the version ordered. We design our Excel self study and Excel Visual Basic self study manuals around real world problems facing business professionals, engineers and scientists.

Intermediate Microsoft Excel Training for Business Public Meeting Signup

Dates Enroll View Cart Location Cost Facility Time
03/06/12  
 
 Thousand Oaks, CA $190.00 Thousand Oaks Inn, Directions/Thousand Oaks Info 8:30 A.M.-4:00 P.M. PST
04/03/12  
 
 Thousand Oaks, CA $190.00 Thousand Oaks Inn, Directions/Thousand Oaks Info 8:30 A.M.-4:00 P.M. PST
05/10/12  
 
 Thousand Oaks, CA $190.00 Thousand Oaks Inn, Directions/Thousand Oaks Info 8:30 A.M.-4:00 P.M. PST

EMAGENIT staff will contact you within one business day of enrollment. If you have any questions, please call us at 1.805.498.7162. Also, military and government discounts available. Contact us directly for more details.

Intermediate Microsoft Excel Training for Business West Coast Webcast Signup (PST)
Dates Enroll View Cart Location Cost Facility Time
03/06/12  
 
Webcast Simulcast $150.00 What is a Webcast? 8:30 A.M.-4:00 P.M. PST
04/03/12  
 
Webcast Simulcast $150.00 What is a Webcast? 8:30 A.M.-4:00 P.M. PST
05/10/12  
 
Webcast Simulcast $150.00 What is a Webcast? 8:30 A.M.-4:00 P.M. PST

EMAGENIT staff will contact you within one business day of enrollment. If you have any questions, please call us at 1.805.498.7162. Also, military and government discounts available. Contact us directly for more details.

 

 

 

Advanced Microsoft Excel Training for Business (1-day)

Our "advanced solutions" Microsoft Excel workshop that focuses on creating sophisticated Excel analysis and data processing  tools using advanced formulas, ActiveX controls, dashboards, database queries, pivot tables, charts and integrating Excel with  Word / PowerPoint. It also provides an introduction to macros (VBA). We teach you how to develop these advanced solutions on the worksheet then how to assemble the proper Excel tools in ways you have never thought of before.

Questions? Call us at:   1.805.498.7162     1.805.558.9277--

Advanced Excel Training Focus

Our "hands-on" advanced Excel training that focuses on creating sophisticated Excel  analysis and data processing  tools using advanced formulas, ActiveX controls, dashboards, database queries, pivot tables, charts and integrating Excel with MS Word and MS PowerPoint. We teach you how to develop these advanced solutions on the worksheet then how to assemble the proper Excel tools in ways you have never thought of before. It also provides an introduction to macros (VBA). In the workshop, we teach our clients how to develop a complete Excel strategy for a complex problem. In all of our workshops, we evaluate our clienteles' knowledge level, their problems and adjust our curriculum to their specific needs. For a complete outline, click the Workshop Outline button below.

Workshop Details

  • About EMAGENIT. Our Customers.

  • Personal examples: Covered in-class

  • Excel Versions: 2000-2010

  • Type: Business Professionals

  • Platform: Windows or Mac

  • Training Materials: Included, 1800+ page manual including our Excel Add-Ins

  • Training Method: Hands-on, interactive

  • Repeat this workshop for free as many times as you want. View offer details

What You Learn at a Glance

  • Building forms using ActiveX controls

  • Advanced formula construction

  • Building dashboards using array formulas, charts and drawing shapes

  • Querying databases

  • Advanced data filtering

  • Advance pivot table construction

  • Linking Excel with other programs like Word

  • Macro recording

Self-Study Manual Purchase (Manual Included with Workshop)

Our Microsoft Excel manuals support business, engineering and science professionals depending on the version ordered. We design our Excel self study and Excel Visual Basic self study manuals around real world problems facing business professionals, engineers and scientists.

Advanced Microsoft Excel Training for Business Public Meeting Signup

Dates Enroll View Cart Location Cost Facility Time
03/07/12  
 
 Thousand Oaks, CA $190.00 Thousand Oaks Inn, Directions/Thousand Oaks Info 8:30 A.M.-4:00 P.M. PST
04/04/12  
 
 Thousand Oaks, CA $190.00 Thousand Oaks Inn, Directions/Thousand Oaks Info 8:30 A.M.-4:00 P.M. PST
05/11/12  
 
 Thousand Oaks, CA $190.00 Thousand Oaks Inn, Directions/Thousand Oaks Info 8:30 A.M.-4:00 P.M. PST

EMAGENIT staff will contact you within one business day of enrollment. If you have any questions, please call us at 1.805.498.7162. Also, military and government discounts available. Contact us directly for more details.

Advanced Microsoft Excel Training for Business West Coast Webcast Signup (PST)
Dates Enroll View Cart Location Cost Facility Time
03/07/12  
 
Webcast Simulcast $150.00 What is a Webcast? 8:30 A.M.-4:00 P.M. PST
04/04/12  
 
Webcast Simulcast $150.00 What is a Webcast? 8:30 A.M.-4:00 P.M. PST
05/11/12  
 
Webcast Simulcast $150.00 What is a Webcast? 8:30 A.M.-4:00 P.M. PST

EMAGENIT staff will contact you within one business day of enrollment. If you have any questions, please call us at 1.805.498.7162. Also, military and government discounts available. Contact us directly for more details.

 

 

 

Beginning Microsoft Excel VBA Training for Business (2-days)

Our "workhorse" Microsoft Excel VBA workshop for business that shows you the basics of using VBA to command Excel, process and reconcile data, create charts, build dashboards, command Word and PowerPoint and more.

Questions? Call us at:   1.805.498.7162     1.805.558.9277--

Beginning Excel VBA Training Focus

Microsoft Visual Basic for Applications (VBA, macros) can be used in conjunction with Microsoft Excel to construct automated business tools. VBA, a general purpose programming language, comes standard with Excel or Office. Using Microsoft Visual Basic with Excel, powerful business analysis tools can be developed quickly and with minimum cost. VBA can be used for business tasks like report generation, creating dashboards, communicating with business databases, analyzing business data, reconciling data, automating worksheet construction, business model calculations, creating charts, the list is endless. This workshop covers the fundamentals of using VBA programming and as well as how to apply it in real world situations. For a complete outline, click the Workshop Outline button below.

Workshop Details

  • About EMAGENIT. Our Customers.

  • Personal examples: Covered in-class

  • Excel Versions: 2000-2010

  • Type: Business Professionals

  • Platform: Windows

  • Training Materials: Included, 1800+ page manual including our Excel Add-Ins

  • Training Method: Hands-on, taught by an actual software developer

  • Repeat this workshop for free as many times as you want. View offer details

What You Learn at a Glance

  • What is VBA?

  • How to use the Visual Basic (VBA) Editor and its debugging tools

  • Complete review of the VBA language (Subs, Functions, variables, arrays, loops, logic...etc)

  • How to command Microsoft Excel using VBA. Also discussed is how control Word and PowerPoint

  • How to use Microsoft Excel VBA to analyze data on single and multi worksheets

  • How to use Excel VBA to perform calculations on data

  • How to create summary sheets using VBA

  • How to create basic dashboards in Microsoft Excel using VBA

  • How to create and format single and multiple charts using VBA

  • Using VBA to create report generation tools in Microsoft Word and Microsoft PowerPoint using Excel VBA

  • How to use Excel VBA to build your own custom worksheet functions

  • How to use the Visual Basic Macro Recorder and interpret its recordings

  • How to download data from the web using VBA

  • How to automate the data analysis tool pack add-in using VBA

 

Self-Study Manual Purchase (Manual Included with Workshop)

Our Microsoft Excel manuals support business, engineering and science professionals depending on the version ordered. We design our Excel self study and Excel Visual Basic self study manuals around real world problems facing business professionals, engineers and scientists.

Beginning Microsoft Excel VBA Training for Business Public Meeting Signup

Dates Enroll View Cart Location Cost Facility Time
02/13/12-02/14/12  
 
 Thousand Oaks, CA $695.00 Thousand Oaks Inn, Directions/Thousand Oaks Info 8:30 A.M.-4:00 P.M. PST
03/15/12-03/16/12  
 
 Thousand Oaks, CA $695.00 Thousand Oaks Inn, Directions/Thousand Oaks Info 8:30 A.M.-4:00 P.M. PST
04/16/12-04/17/12  
 
 Thousand Oaks, CA $695.00 Thousand Oaks Inn, Directions/Thousand Oaks Info 8:30 A.M.-4:00 P.M. PST

EMAGENIT staff will contact you within one business day of enrollment. If you have any questions, please call us at 1.805.498.7162. Also, military and government discounts available. Contact us directly for more details.

Beginning Microsoft Excel VBA Training for Business West Coast Webcast Signup (PST)

Dates Enroll View Cart Location Cost Facility Time
02/13/12-02/14/12  
 
Webcast Simulcast $595.00 What is a Webcast? 8:30 A.M.-4:00 P.M. PST
03/15/12-03/16/12  
 
Webcast Simulcast $595.00 What is a Webcast? 8:30 A.M.-4:00 P.M. PST
04/16/12-04/17/12  
 
Webcast Simulcast $595.00 What is a Webcast? 8:30 A.M.-4:00 P.M. PST

EMAGENIT staff will contact you within one business day of enrollment. If you have any questions, please call us at 1.805.498.7162. Also, military and government discounts available. Contact us directly for more details.

 

 

 

Advanced Microsoft Excel VBA Training for Business (3-days)

Our "premier" Microsoft Excel VBA workshop for business that shows you how to construct complex dashboard driven analysis and data integration business tools in Excel. It shows not only how to use Excel for this task but how to use VBA to tie into other programs, databases and computer languages as well.

Questions? Call us at:   1.805.498.7162     1.805.558.9277--

Newsletter Contact Us Self-Study Training Help

Advanced Excel VBA Training Focus

The capability exists within Microsoft Excel and VBA to construct complex dashboard driven analysis and data processing business tools. These business tools can go far beyond simple macros becoming actual applications. Excel has a vast array of automated features like graphics, ActiveX controls, worksheets, userforms and cell ranges that when combined together allow these dashboard driven programs to be created. When you tie other programs and computer languages to Excel through VBA like Word, PowerPoint, Access, SQL Server, Lotus Notes, C and VB .Net, Excel VBA can tap into these environments obtaining the functionality it does not have. This workshop focuses on using all of these elements to construct sophisticated data processing and analysis programs in Microsoft Excel. For a complete outline, click the Workshop Outline button below.

 

Workshop Details

  • About EMAGENIT. Our Customers.

  • Personal examples: Covered in-class

  • Excel Versions: 2000-2010

  • Type: Business Professionals

  • Platform: Windows

  • Training Materials: Included, 1800+ page manual including our Excel Add-Ins

  • Training Method: Hands-on, taught by an actual software developer

  • Repeat this workshop for free as many times as you want. View offer details

 

What You Learn at a Glance
  • What is VBA?

  • An advanced review of the Excel VBA language

  • Advanced VBA data processing techniques for multi worksheets and multi workbooks

  • Advanced summary worksheet construction in Excel using Excel VBA

  • Advanced techniques for scanning Windows folders for workbooks and then opening them using VBA

  • How to read text files using VBA.

  • Advanced VBA programming techniques for creating multiple charts from multiple data sheets

  • How to create advanced business user interfaces on worksheets using ActiveX controls, VBA and graphics

  • Advanced excel dashboard construction

  • How to create and use userforms in VBA (wizards)

  • How to create event driven programs using VBA

  • Advanced VBA error protection techniques

  • How to create custom toolbars and menus to run your VBA code

  • How to communicate with databases using DAO and ADO in VBA and how to download data from the web using VBA

  • Advanced VBA techniques for communicating with other languages and programs

Self-Study Manual Purchase (Manual Included with Workshop)

Our Microsoft Excel manuals support business, engineering and science professionals depending on the version ordered. We design our Excel self study and Excel Visual Basic self study manuals around real world problems facing business professionals, engineers and scientists.

Advanced Microsoft Excel VBA Training for Business Public Meeting Signup

Dates Enroll View Cart Location Cost Facility Time
02/15/12-02/17/12  
 
 Thousand Oaks, CA $950.00 Thousand Oaks Inn, Directions/Thousand Oaks Info 8:30 A.M.-4:00 P.M. PST
04/18/12-04/20/12  
 
 Thousand Oaks, CA $950.00 Thousand Oaks Inn, Directions/Thousand Oaks Info 8:30 A.M.-4:00 P.M. PST

EMAGENIT staff will contact you within one business day of enrollment. If you have any questions, please call us at 1.805.498.7162. Also, military and government discounts available. Contact us directly for more details.

Advanced Microsoft Excel VBA Training for Business

West Coast Webcast Signup (PST)

Dates Enroll View Cart Location Cost Facility Time
02/15/12-02/17/12  
 
Webcast Simulcast $850.00 What is a Webcast? 8:30 A.M.-4:00 P.M. PST
04/18/12-04/20/12  
 
Webcast Simulcast $850.00 What is a Webcast? 8:30 A.M.-4:00 P.M. PST

EMAGENIT staff will contact you within one business day of enrollment. If you have any questions, please call us at 1.805.498.7162. Also, military and government discounts available. Contact us directly for more details.

 

 

 

Engineering & Science Workshops

Microsoft Excel Training for Engineers & Scientists (1-day)

Our "power formula" Excel workshop for engineers and scientists that shows you how to create powerful formulas using VLOOKUP, IF, OFFSET, MATCH, INDIRECT... that analyze data and perform sophisticated analysis. Also discussed is custom worksheet function design using VBA, modeling, numerical analysis techniques, pivot table construction, dashboard design and linking to Word and PowerPoint. This workshop is taught by an engineer.

Questions? Call us at:   1.805.498.7162     1.805.558.9277--

Microsoft Excel Training Focus

Our "hands-on" Microsoft Excel training for both engineers and scientists focuses on useful formula design in the areas of data processing, analysis and modeling. Our workshop discusses formula basics along with advanced array formula design that help engineers and scientists develop sophisticated analytical tools. Included in our discussion are important worksheet functions like VLOOKUP, IF, INDEX, COUNTA, COUNTIF, AND, OR, OFFSET, ADDRESS, COLUMNS, ROWS and MATCH. Stressed are construction techniques that allow formulas to automatically adapt to and seek out their information needs. Also stressed are model construction techniques that allow large amounts of information to be maintained and transferred between worksheets and workbooks. The text worksheet functions are also covered that allow data to be parsed (split) and cleaned before being analyzed, a huge problem in data processing.

In addition to formula construction, how to create your own custom worksheet functions in VBA is also discussed. These functions can far out perform any formula created on the worksheet and are the key to creating powerful analysis routines for the worksheet. How to construct interfaces using ActiveX, data validation and conditional formatting is also covered in the workshop. Rounding out the discussion is how to build reports in Excel using pivot tables and linking Excel with Word and PowerPoint.

For a complete outline, click the Workshop Outline button below.

 

Workshop Details

  • About EMAGENIT. Our Customers.

  • Personal examples: Covered in-class

  • Excel Versions: 2000-2010

  • Type: Engineers and Scientists

  • Platform: Windows

  • Training Materials: Included, 1800+ page manual including our Excel Add-Ins

  • Training Method: Hands-on, taught by an engineer / software developer

  • Repeat this workshop for free as many times as you want. View offer details

What You Learn at a Glance
  • Formula Basics: Basic formula design, formula debugging and cell name review

  • Dashboards: How to use ActiveX controls, form controls, conditional formatting and data validation to create advanced interfaces on the Microsoft Excel worksheet

  • Smart Worksheets: How to construct "smart" Microsoft Excel worksheets using Excel's logic, information, and lookup and reference worksheet functions including VLOOKUP, MATCH, OFFSET, COUNTIF, INDEX, INDIRECT, IF, AND, Or, ADDRESS, COLUMN, ROW

  • Array Formulas: How to use array formulas to build advanced worksheet formulas that determine and adapt to changing information requirements

  • Text Functions: How to use the text worksheet functions like RIGHT, MID, LEFT SUBSTITUTE, REPLACE, SEARCH and CLEAN to prepare data to be analyzed

  • Databases / Lists: How to create and manage databases in Microsoft Excel

  • Text Wizard and Text to Columns: How to import and parse data files in Excel

  • Custom Worksheet Functions (VBA): How to create custom worksheet functions using VBA that replace mega formulas on the worksheet and allow numerical techniques to be employed on the worksheet

  • Pivot Tables: How to create and use Microsoft Excel pivot tables for reports

  • Linking Workbooks: How to link workbooks and worksheets together including team integration and large scale information transfer

  • Link Excel to Word and PowerPoint: How to link Microsoft Excel to Word and PowerPoint for report generation

Self-Study Manual Purchase (Manual Included with Workshop)

Our Microsoft Excel manuals support business, engineering and science professionals depending on the version ordered. We design our Excel self study and Excel Visual Basic self study manuals around real world problems facing business professionals, engineers and scientists.

Microsoft Excel Training for Engineers & Scientists Public Meeting Signup

Dates Enroll View Cart Location Cost Facility Time
Jan. Closed  
 
 Thousand Oaks, CA $190.00 Thousand Oaks Inn, Directions/Thousand Oaks Info 8:30 A.M.-4:00 P.M. PST
03/09/12  
 
 Thousand Oaks, CA $190.00 Thousand Oaks Inn, Directions/Thousand Oaks Info 8:30 A.M.-4:00 P.M. PST

EMAGENIT staff will contact you within one business day of enrollment. If you have any questions, please call us at 1.805.498.7162. Also, military and government discounts available. Contact us directly for more details.

Microsoft Excel Training for Engineers & Scientists West Coast Webcast Signup (PST)

Dates Enroll View Cart Location Cost Facility Time
Jan. Closed  
 
 Webcast Simulcast $150.00 What is a Webcast? 8:30 A.M.-4:00 P.M. PST
03/09/12  
 
 Webcast Simulcast $150.00 What is a Webcast? 8:30 A.M.-4:00 P.M. PST

EMAGENIT staff will contact you within one business day of enrollment. If you have any questions, please call us at 1.805.498.7162. Also, military and government discounts available. Contact us directly for more details.

 

 

Beginning Microsoft Excel VBA Training for Engineers & Scientists (2-days)

Our "workhorse" Microsoft Excel VBA workshop for engineering and science that shows you the basics of using VBA to command Excel, process and reconcile data, create charts, create functions, build powerful models, build dashboards and command Word and PowerPoint. This workshop is taught by an engineer.

Questions? Call us at:   1.805.498.7162     1.805.558.9277--

Beginning Excel VBA Training Focus

Visual Basic for Applications (VBA) can be used in conjunction with Microsoft Excel to construct automated engineering and science tools. VBA, a general purpose programming language, comes standard with Excel or Office. Using VBA with Excel, engineers and scientists can develop analysis tools quickly with minimum cost. VBA can be used for engineering and scientific tasks like analyzing data, automating chart construction, building report generation tools, communicating with databases, constructing dashboards, system models the list is endless. This workshop discusses the basics of using Excel VBA in the engineering and science disciplines. For a complete outline, click the Workshop Outline button below.

 

Workshop Details

  • About EMAGENIT. Our Customers.

  • Personal examples: Covered in-class

  • Excel Versions: 2000-2010

  • Type: Engineers and Scientists

  • Platform: Windows

  • Training Materials: Included, 1800+ page manual including our Excel Add-Ins

  • Training Method: Hands-on, taught by an engineer / software developer

  • Repeat this workshop for free as many times as you want. View offer details

What You Learn at a Glance
  • What is VBA?

  • How engineers and scientists can use the Microsoft Excel Visual Basic Editor's debugging tools for their purposes

  • How to use Visual Basic for Applications (VBA) for engineering and scientific purposes

  • How to use the VBA language including variables, loops, logic, arrays, functions...etc

  • How to control key Microsoft Excel program elements using VBA (Visual Basic)

  • How engineers and scientists cans use VBA to analyze engineering and scientific data on the Microsoft Excel worksheet

  • Basic dashboards design for engineers and scientists using Excel and VBA

  • How engineers and scientists can construct their own worksheet functions (UDF's) using Excel Visual Basic (numerical analysis techniques discussion included)

  • How engineers and scientists can automate chart construction using Excel VBA

  • How to use the Macro Recorder to record engineering and scientific tasks in Microsoft Excel

Self-Study Manual Purchase (Manual Included with Workshop)

Our Microsoft Excel manuals support business, engineering and science professionals depending on the version ordered. We design our Excel self study and Excel Visual Basic self study manuals around real world problems facing business professionals, engineers and scientists.

Beginning Microsoft Excel VBA Training for Engineers & Scientists Public Meeting Signup

Dates Enroll View Cart Location Cost Facility Time
02/06/12-02/07/12  
 
 Thousand Oaks, CA $695.00 Thousand Oaks Inn, Directions/Thousand Oaks Info 8:30 A.M.-4:00 P.M. PST
04/30/12-05/01/12  
 
 Thousand Oaks, CA $695.00 Thousand Oaks Inn, Directions/Thousand Oaks Info 8:30 A.M.-4:00 P.M. PST

EMAGENIT staff will contact you within one business day of enrollment. If you have any questions, please call us at 1.805.498.7162. Also, military and government discounts available. Contact us directly for more details.

Beginning Microsoft Excel VBA Training for Engineers & Scientists West Coast Webcast Signup (PST)

Dates Enroll View Cart Location Cost Facility Time
02/06/12-02/07/12  
 
 Webcast Simulcast $595.00 What is a Webcast? 8:30 A.M.-4:00 P.M. PST
04/30/12-05/01/12  
 
 Webcast Simulcast $595.00 What is a Webcast? 8:30 A.M.-4:00 P.M. PST

EMAGENIT staff will contact you within one business day of enrollment. If you have any questions, please call us at 1.805.498.7162. Also, military and government discounts available. Contact us directly for more details.

 

 

 

Advanced Microsoft Excel VBA Training for Engineers & Scientists (3-days)

Our "premier" Microsoft Excel VBA workshop for engineers and scientists that shows you how to construct complex dashboard driven analysis and data integration tools in Excel. It shows not only how to use Excel for this task but how to use VBA to tie into other programs, databases and computer languages as well including FORTRAN. This workshop is taught by an engineer.

Questions? Call us at:   1.805.498.7162     1.805.558.9277--

Advanced Excel VBA Training Focus

The capability exists within Microsoft Excel VBA to construct sophisticated engineering and scientific tools that integrate seamlessly with the Microsoft Excel environment. Using advanced Microsoft Excel VBA programming techniques, sophisticated applications can be constructed in Microsoft Excel that command, organize and analyze engineering and scientific data, automatically chart engineering and scientific data, generate reports, talk to other applications integrating their data, perform engineering and scientific modeling, integrate FORTRAN routines... the list is endless. Many companies are turning to constructing engineering and scientific applications in Excel due to the lower cost, lower development time and because of Excel's exceptional abilities. This workshop discusses the advanced uses of Excel VBA in the engineering and science disciplines.

 

Workshop Details

  • About EMAGENIT. Our Customers.

  • Personal examples: Covered in-class

  • Excel Versions: 2000-2010

  • Type: Engineers and Scientists

  • Platform: Windows

  • Training Materials: Included, 1800+ page manual including our Excel Add-Ins

  • Training Method: Hands-on, taught by an engineer / software developer

  • Repeat this workshop for free as many times as you want. View offer details

What You Learn at a Glance
  • What is VBA?

  • Advanced data analysis techniques for engineers and scientists using VBA and Excel

  • Advanced Excel VBA programming techniques for automated chart construction in Microsoft Excel

  • Advanced dashboards using Excel and VBA for engineers and scientists

  • Advanced interface construction using ActiveX controls and userforms

  • Advanced Microsoft Excel VBA programming techniques for creating event driven engineering and scientific applications in Microsoft Excel

  • Advanced VBA error trap construction for engineers and scientists

  • How to create Excel menu bars and toolbars

  • Advanced Excel VBA programming tips for communicating with FORTRAN, VB ActiveX DLLs, PERL and C

  • System modeling discussion including how to use Solver with VBA

  • Advanced VBA programming strategies for communicating with engineering and science oriented databases

Self-Study Manual Purchase (Manual Included with Workshop)

Our Microsoft Excel manuals support business, engineering and science professionals depending on the version ordered. We design our Excel self study and Excel Visual Basic self study manuals around real world problems facing business professionals, engineers and scientists.

Advanced Microsoft Excel VBA Training for Engineers & Scientists Public Meeting Signup

Dates Enroll View Cart Location Cost Facility Time
02/08/12-02/10/12  
 
 Thousand Oaks, CA $950.00 Thousand Oaks Inn, Directions/Thousand Oaks Info 8:30 A.M.-4:00 P.M. PST
05/02/12-05/04/12  
 
 Thousand Oaks, CA $950.00 Thousand Oaks Inn, Directions/Thousand Oaks Info 8:30 A.M.-4:00 P.M. PST

EMAGENIT staff will contact you within one business day of enrollment. If you have any questions, please call us at 1.805.498.7162. Also, military and government discounts available. Contact us directly for more details.

Advanced Microsoft Excel VBA Training for Engineers & Scientists West Coast Webcast Signup (PST)

Dates Enroll View Cart Location Cost Facility Time
02/08/12-02/10/12  
 
Webcast Simulcast $850.00 What is a Webcast? 8:30 A.M.-4:00 P.M. PST
05/02/12-05/04/12  
 
Webcast Simulcast $850.00 What is a Webcast? 8:30 A.M.-4:00 P.M. PST

EMAGENIT staff will contact you within one business day of enrollment. If you have any questions, please call us at 1.805.498.7162. Also, military and government discounts available. Contact us directly for more details.

 

 

 

 

 

Additional Pages

Microsoft Excel Classes  Microsoft Excel VBA Courses  Microsoft Excel Training  Microsoft Excel Macros  Microsoft Excel VBA Consulting  Microsoft Excel Add-Ins

Copyright © 2002-2011 EMAGENIT All Rights Reserved