Microsoft Excel Onsite Training, Microsoft Excel VBA Onsite Training

For our Microsoft Excel Onsite workshops, we travel to your company and customize a workshop for your needs. Let our 14 years of Excel training experience and Excel macro development guide you to your training goal.

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

 

NASA Award for Microsoft Excel Design

EMAGENIT received an award from NASA  for its software design in Microsoft Excel and VBA for the Mars Rover. We provide training for customers like AMGEN and General Dynamics. Read below to learn more about our training. Click here for our software design.
 

Microsoft Excel Onsite Training for Business

Beginning Microsoft Excel Onsite Training for Business

Duration: 1-day

Included: Complete Excel Aided Business Manual

Covers: Excel 2000-2010

Specifics: Customized to customers needs

Beginning Excel On-Site Training Focus

Our "hands-on" beginning Excel training teaches you not only 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 workshop outline, click the Workshop Outline button below. You can repeat your workshop as many times as you like. Click here for repeat details. Military and government discounts available, call us for details.

What You Learn at a Glance

Learn fundamental Microsoft Excel skills in this onsite workshop like:

  • 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

Intermediate Microsoft Excel Onsite Training for Business

Duration: 1-day

Included: Complete Excel Aided Business Manual

Covers: Excel 2000-2010

Specifics: Customized to customers needs

Intermediate Excel On-Site 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 workshop outline, click the Workshop Outline button below. You can repeat your workshop as many times as you like. Click here for repeat details. Military and government discounts available, call us for details.

What You Learn at a Glance

Learn Microsoft Excel intermediate skills in this onsite workshop like:

  • 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

Duration: 1-day

Included: Complete Excel Aided Business Manual

Covers: Excel 2000-2010

Specifics: Customized to customers needs

Advanced Excel On-Site 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 workshop outline, click the Workshop Outline button below. You can repeat your workshop as many times as you like. Click here for repeat details. Military and government discounts available, call us for details.

What You Learn at a Glance

Learn advanced Microsoft Excel skills in this onsite workshop like:

  • 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

 

Duration: 2-days

Included: Complete Excel Aided Business Manual

Covers: Excel 2000-2010

Specifics: Customized to customers needs

Beginning Excel VBA  On-Site 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 workshop outline, click the Workshop Outline button below. You can repeat your workshop as many times as you like. Click here for repeat details. Military and government discounts available, call us for 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

Advanced Microsoft Excel VBA Onsite Training for Business
Newsletter Contact Us Self-Study Training Help

Duration: 3-days

Included: Complete Excel Aided Business Manual

Covers: Excel 2000-2010

Specifics: Customized to customers needs

Advanced Excel VBA  On-Site 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 workshop outline, click the Workshop Outline button below. You can repeat your workshop as many times as you like. Click here for repeat details. Military and government discounts available, call us for 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

Additional Microsoft Excel Business Onsite Training
 

Microsoft Excel Onsite Training for Engineering & Science

Microsoft Excel Onsite Training for Engineers & Scientists

Duration: 1-day

Included: Complete Excel Aided Engineering Manual

Covers: Excel 2000-2010

Specifics: Customized to customers needs

Microsoft Excel On-Site Training Focus

This onsite workshop focuses on useful formula design in the areas of data processing, analysis and modeling. It discusses formula basics along with advanced array formula design that help engineers and scientists develop sophisticated analytical tools. Also stressed are model construction techniques and the text worksheet functions 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. 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 workshop outline, click the Workshop Outline button below. You can repeat your workshop as many times as you like. Click here for repeat details. Military and government discounts available, call us for details.

Beginning Microsoft Excel VBA Onsite Training for Engineers & Scientists

Duration: 2-days

Included: Complete Excel Aided Engineering Manual

Covers: Excel 2000-2010

Specifics: Customized to customers needs

Beginning Excel VBA On-Site Training Focus

What is VBA? This workshop covers the fundamentals of using VBA programming in the engineering and science world. From loops, variables and logic to controlling Microsoft Excel, Microsoft Word and PowerPoint to data processing. It also covers automated engineering chart construction, beginning dashboard topics, system modeling, custom worksheet functions (UDF's) and numerical analysis approaches.

For a complete workshop outline, click the Workshop Outline button below. You can repeat your workshop as many times as you like. Click here for repeat details. Military and government discounts available, call us for details.

 

 

Duration: 3-days

Included: Complete Excel Aided Engineering Manual

Covers: Excel 2000-2010

Specifics: Customized to customers needs

Advanced Excel VBA On-Site Training Focus

What is VBA? This workshop covers VBA topics like automated engineering chart construction for multi worksheets; advanced control techniques of other applications such as Microsoft Word and Microsoft PowerPoint; advanced engineering dash board construction using charts, pictures, ActiveX controls and drawing shapes; engineering wizard construction using userforms; advanced worksheet layout including navigation; advanced system modeling; team linking; database communication using ADO and DAO and communicating with other computer languages like FORTRAN.

For a complete workshop outline, click the Workshop Outline button below. You can repeat your workshop as many times as you like. Click here for repeat details. Military and government discounts available, call us for details.

 

Microsoft Excel Aided Engineering & Science Onsite Training

Duration: 5-days

Included: Complete Excel Aided Engineering Manual

Covers: Excel 2000-2010

Specifics: Customized to customers needs

Excel Aided Engineering /Science On-Site Training Focus

This all in one Excel and Excel VBA onsite workshop covers basic engineering and science formula design on the worksheet to numerical techniques on the worksheet like linear systems, Runge Kutta, Newton's method, integration, differentiation and boundary value problems. It also covers complex number operations and advanced engineering and science charts. EAE also covers system modeling, design optimization using Solver and integrating engineering teams. Also reviewed is beginning and advanced VBA programming including userform design and how to integrate FORTRAN into your coding solutions.

For a complete workshop outline, click the Workshop Outline button below. You can repeat your workshop as many times as you like. Click here for repeat details. Military and government discounts available, call us for details.

 

Additional Microsoft Excel Engineering & Science Onsite Training

 

  
 

General Attendance Onsite Training

Integrating and Processing Data in Microsoft Excel and VBA Onsite Training

Duration: 3-days

Included: Complete Excel Aided Engineering or Excel Aided Business Manual

Covers: Excel 2000-2010

Specifics: Customized to customers needs

Integrating and Processing Data in Microsoft Excel and VBA Training Focus

In the world of today, data storage has become spread out over various programs, databases and file types. You need one system to talk to another or several others to get the full answer. This data integration however, cannot be performed through the existing software due to expense or lack of capability. Microsoft Excel tools along with Visual Basic for Applications (VBA) can be used to first integrate these data sources automatically then process them. You will find that the combination of both these environments allow data tools to be developed that can for example integrate 3 workbooks, 50 text files, and 50 Access database (an actual problem for EMAGENIT) making them behave as one uniform data source.

For a complete workshop outline, click the Workshop Outline button below. You can repeat your workshop as many times as you like. Click here for repeat details. Military and government discounts available, call us for details.

What You Learn at a Glance

  • What is VBA?

  • What is a query and relational database

  • Design worksheet tables to be queried

  • How to write basic SQL commands

  • How to use Microsoft Query to query text files, Excel workbooks and databases

  • How to read Access tables from Excel

  • How to create advanced worksheet formulas that integrate data

  • Review of key Excel data tools for VBA

  • How to control a range with VBA while accessing and filling in worksheet data

  • How to use key worksheet functions and Excel tools in VBA to search for data

  • Use VBA to control workbooks/worksheets

  • How to control Excel's tools with VBA

  • Review of key looping structures and strategies in VBA that access multi-files

  • How to control dashboard drawing shapes and charts using VBA

  • Use VBA to access Window's file system

  • How to control other programs using VBA

  • How to use VBA to control Microsoft Query

  • How to import, clean and parse text files using VBA

  • Use VBA to control DAO, ADO, OLE DB

  • How to access Windows file management dialog boxes using VBA

  

 

 

 

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