Microsoft Excel Public Training, Microsoft Excel VBA Public Training, Excel Macro Public Training

In our Microsoft Excel Public workshops, you will learn "hands-on" from an experienced Excel developer. Our workshops are never "canned" and the class curriculum adjusted based on the needs of the attendees. Read below and see how to supercharge your Excel skills and enroll>>>

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

EMAGENIT NASA Award for Excel

EMAGENIT received an award for its involvement with NASA JPL in helping redesign and integrate their conceptual Rover mission software in Microsoft Excel. Click the picture above for more detail about our Rover involvement. To learn more about the NASA mission to mars click here.

Awards & Customers

Why Use EMAGENIT?

  • We have been developing software in Microsoft Excel for over 12 years.

  • Our Excel self study and Excel Visual Basic self study manuals are not your generic Excel books

  • We offer a wide variety of Microsoft Excel workshops and Microsoft Excel Visual Basic workshops for beginning through Excel power users

  • We develop Microsoft Excel applications for companies like Northrop Grumman, NASA JPL and Caterpillar so whom better to learn from than a company that actually uses it

  • We cover Excel 97 and beyond

*Military and government discounts available. Contact us directly for more details at 805.498.7162.
 

About Our Microsoft Excel Public Training

  • EMAGENIT has been providing Microsoft Excel training for over 12 years.

  • Our instructors not only train, they build solutions in Microsoft Excel.

  • EMAGENIT provides Beginning Excel public training

  • EMAGENIT provides Intermediate Excel public Training

  • EMAGENIT provides Advanced Excel public Training

Our beginning, intermediate, advanced Excel public workshops are designed for business professionals looking to make the most out of their daily Excel use. Our training is presented using "hands-on" examples and covers both Mac and Windows users. Our instructors use MacBook Pros (intel-based dual core) running Windows as well as Mac OS X operating systems for dual instruction issues. Our public workshop schedule for our Microsoft Excel training is presented to the right.
 

About Our Microsoft Excel VBA Public Training

  • Our instructors not only train, they build software for Excel using VBA and Visual Basic .Net as well.

  • EMAGENIT provides Beginning Microsoft Excel VBA training (Excel Macros are designed using VBA)

  • EMAGENIT provides Advanced Microsoft Excel VBA training (Excel Macros are designed using VBA)

Our Microsoft Excel VBA training workshops are for business professionals, engineers and scientists. Our macro training covers the basics to the most advanced topics and is taught "hands-on". Our instructors use MacBook Pros (intel-based dual core) running Windows as well as Mac OS X operating systems for dual instruction issues. Our public workshop schedule for our VBA Excel Macro training is presented to the right.
 

What is Included in the Price?

  • Our full Excel manual, over 1600 pages of examples and text.

  • Our entire Microsoft Excel add-in software suite.

  • You can repeat the workshop at no extra charge and no time limit. We welcome repeat visits.
 

Public Training Locations
Our public workshops are held in Thousand Oaks (TO), 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 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.
 

Pricing and Discounts

EMAGENIT offers discounts for companies sending 3 or more attendees to our VBA classes. Military and government discounts are also available. Contact us for more details.
 

Payment Options
EMAGENIT accepts Visa, MasterCard, Discover Card, American Express company check or money order.

Excel & Excel VBA Public Workshop Schedule for Business

Beginning Microsoft Excel Public Training for Business

Duration: 1-day

Materials: 1600+ Page Manual Included

Beginning Excel Public 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. Dates, times and pricing on enrollment page. View enrollment page now. Repeat this workshop for free as many times as you want. View offer details. Military and government discounts available, call us for details.

What You Learn at a Glance

Learn fundamental Microsoft Excel skills in this public 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 Public Training for Business

*Outline/Enroll button below

Duration: 1-day

Materials: 1600+ Page Manual Included

Intermediate Excel Public 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. Dates, times and pricing on enrollment page.  View enrollment page now. Repeat this workshop for free as many times as you want. View offer details. Military and government discounts available, call us for details.

What You Learn at a Glance

Learn Microsoft Excel intermediate skills in this public 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

 

 

Advanced Microsoft Excel Public Training for Business

*Outline/Enroll button below

Duration: 1-day

Materials: 1600+ Page Manual Included

Advanced Excel Public 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. Dates, times and pricing on enrollment page.  View enrollment page now. Repeat this workshop for free as many times as you want. View offer details. Military and government discounts available, call us for details.

What You Learn at a Glance

Learn advanced Microsoft Excel skills in this public 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

 

 

Microsoft Excel VBA Essentials Public Training for Business

*Outline/Enroll button below

Duration: 1-day

Materials: 1600+ Page Manual Included

Excel VBA Essentials Public Training Focus

Microsoft Visual Basic for Applications (VBA, macros) can be used in conjunction with Microsoft Excel to automate common everyday Excel tasks and to construct automated data processing tools. VBA, a general purpose programming language, comes standard with Excel or Office. This public workshop covers the fundamentals of using VBA programming and as well as how to apply it to common Excel and data processing tasks.

For a complete workshop outline, click the Workshop Outline button below. Dates, times and pricing on enrollment page.  View enrollment page now. Repeat this workshop for free as many times as you want. View offer 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

  • Excel macro language review (Subs, Functions, variables, arrays, loops, logic...etc)

  • How to streamline tasks in Microsoft Excel using VBA

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

  • How to use Excel visual basic (VBA) to perform calculations on data

  • How to create summary sheets (reconcile data) using VBA

  • How to create charts using 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

 

 

Beginning Microsoft Excel VBA Public Training for Business

*Outline/Enroll button below

Duration: 2-days

Materials: 1600+ Page Manual Included

Beginning Excel VBA Public 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 public 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. Dates, times and pricing on enrollment page.  View enrollment page now. Repeat this workshop for free as many times as you want. View offer 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 Public Training for Business

*Outline/Enroll button below

Duration: 3-days

Materials: 1600+ Page Manual Included

Advanced Excel VBA Public 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 public 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. Dates, times and pricing on enrollment page.  View enrollment page now. Repeat this workshop for free as many times as you want. View offer 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

 

 

 
 

Excel VBA Public Workshops for Engineers & Scientists

Beginning Microsoft Excel VBA Public Training for Engineers & Scientists

*Outline/Enroll button below

Duration: 2-days

Materials: 1600+ Page Manual Included

Beginning Excel VBA Public Training Focus

What is VBA? This public 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. It uses real engineering and science examples that lets you start building useable macros in Excel right away.

For a complete workshop outline, click the Workshop Outline button below. Dates, times and pricing on enrollment page.  View enrollment page now. Repeat this workshop for free as many times as you want. View offer details. Military and government discounts available, call us for details.

 

 

Advanced Microsoft Excel VBA Public Training for Engineers & Scientists

*Outline/Enroll button below

Duration: 3-days

Materials: 1600+ Page Manual

Advanced Excel VBA Public Training Focus

What is VBA? This public workshop covers advanced engineering and science VBA topics such as 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. It uses real world examples that lets you take your Excel applications to the top level

For a complete workshop outline, click the Workshop Outline button below. Dates, times and pricing on enrollment page.  View enrollment page now. Repeat this workshop for free as many times as you want. View offer details. Military and government discounts available, call us for 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-2010 EMAGENIT All Rights Reserved