Microsoft Excel Training and Software Solutions for Business, Engineering and Science

Want to find a solution to your Microsoft Excel task? Welcome to EMAGENIT. We have over 12 years of experience specializing in Microsoft Excel and Microsoft Excel VBA training, manuals and software design.  Read below to see how we can help supercharge your Excel skills or your Excel software>>>

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

Key Services

Excel Training Schedule Our 4 Training Options Software Design for Excel NASA Award, Customers Excel Resource Center
-

What is New at EMAGENIT

New Workshop! Our 1-day VBA Essentials workshop (Excel Macros) shows you how to reconcile worksheet data, streamline Excel tasks and build charts using macros. Reduce 2 month tasks to 1 minute. Outline/Enrollment. Webcast (Webinar) Cannot make a workshop? Why not take a webcast from us. Live broadcast over the internet, hands-on and voice, for both East and West Coast time zones. Learn More.
-
Microsoft Excel and Microsoft Excel VBA Workshops

About Our Instructors: Our instructors are actual Excel developers that create solutions for both the business and engineering communities. EMAGENIT has been in business for over 12 years, develops Excel VBA and VB .Net software and has extensive knowledge in areas of data processing, formula design, modeling and VBA (Macro) programming. View our customer list and awards.

Public and Webcast (Webinar) Microsoft Excel Training for Business

Beginning Microsoft Excel Training Intermediate Microsoft Excel Training Advanced Microsoft Excel Training

Pricing, Duration and Enrollment at a Glance

Duration: Public Enroll Webcast Enroll
1-day $190.00 N/A
Dates and times on enrollment page. Repeat this workshop for free as many times as you want (details).

Beginning Excel 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 the workshop, we evaluate our clienteles' knowledge level, their problems and work that directly into our curriculum. Our class sizes are generally 4-7 people insuring personalized instruction.

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 and ... more (click outline above)

 

Pricing, Duration and Enrollment at a Glance

Duration: Public Enroll Webcast Enroll
1-day $190.00 $150.00
Dates and times on enrollment page. What is a webcast? Repeat this workshop for free as many times as you want (details).

Intermediate Excel Training Focus

Our "hands-on" intermediate Excel training focuses on useful formula design, worksheet functions and Excel's data processing capabilities. We teach you how to develop analysis and data processing problems on the worksheet then apply the proper Excel tools to create a solution. In the workshop, we evaluate our clienteles' knowledge level, their problems and work that directly into our curriculum. Our class sizes are generally 4-7 people insuring personalized instruction.

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

  • Using Data Validation and Conditional Formatting

  • Perform table lookups using VLookup and HLookup

  • Build summary/pricing worksheets

  • 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 and ...more (click outline above)

Pricing, Duration and Enrollment at a Glance

Duration: Public Enroll Webcast Enroll
1-day $190.00 $150.00
Dates and times on enrollment page. What is a webcast? Repeat this workshop for free as many times as you want (details).

Advanced Excel Training Focus

Our "hands-on" advanced Excel training focuses on creating sophisticated Excel solutions using advanced formulas, dashboards, database queries, pivot tables, charts and integrating Excel with MS Word and MS PowerPoint. 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 the workshop, we evaluate our clienteles' knowledge level, their problems and work that directly into our curriculum. Our class sizes are generally 4-7 people insuring personalized instruction.

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 and ... more (click outline above)

 

Public and Webcast (Webinar) Microsoft Excel VBA Training for Business (Macros)

Microsoft Excel VBA Essentials Training (Excel Macros) Beginning Microsoft Excel VBA Training (Excel Macros) Advanced Microsoft Excel VBA Training (Excel Macros)

Pricing, Duration and Enrollment at a Glance

Duration: Public Enroll Webcast Enroll
1-day $275.00 $225.00
Dates and times on enrollment page. What is a webcast? Repeat this workshop for free as many times as you want (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 command 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 the Visual Basic Macro Recorder and interpret its recordings  ...more (click outline above)

Pricing, Duration and Enrollment at a Glance

Duration: Public Enroll Webcast Enroll
2-day $695.00 $595.00
Dates and times on enrollment page. What is a webcast? Repeat this workshop for free as many times as you want (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 ...more (click outline above)

Pricing, Duration and Enrollment at a Glance

Duration: Public Enroll Webcast Enroll
3-day $950.00 $850.00
Dates and times on enrollment page. What is a webcast? Repeat this workshop for free as many times as you want (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 ...more (click outline above)

 

Quick Look at Our Public and Webcast Microsoft Excel VBA Training for Engineers and Scientists (Macros)

Beginning Microsoft Excel VBA Training (Excel Macros) Advanced Microsoft Excel VBA Training (Excel Macros)  

Pricing, Duration and Enrollment at a Glance

Duration: Public Enroll Webcast Enroll
2-day $695.00 $595.00
Dates and times on enrollment page. What is a webcast? Repeat this workshop for free as many times as you want (details).

What You Learn at a Glance

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...more (click outline above)

Pricing, Duration and Enrollment at a Glance

Duration: Public Enroll Webcast Enroll
3-day $950.00 $850.00
Dates and times on enrollment page. What is a webcast? Repeat this workshop for free as many times as you want (details).

What You Learn at a Glance

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...more (click outline above)

 

 

 

About Our Company

Why EMAGENIT?

Want to reduce the amount of time you spend in Microsoft Excel? Sure you do. Welcome to EMAGENIT. We specialize in Microsoft Excel and Microsoft Excel VBA training, manuals and software design. EMAGENIT has been training and developing in Microsoft Excel and Microsoft Excel VBA for over 12 years. We know what you want. You want real problems solved. Not just a bunch of examples of what it’s suppose to look like. Our diverse background in both business and engineering allows us to tackle any training or software job. Take a look at some of our customers.

Our Training Approach: Experience, Innovation and Value

EMAGENIT offers the following training solutions: On-Site, Public, Self Study, Web Cast

At EMAGENIT, we have been personalizing our training and problem solving since the very first class. We offer a wide variety of Microsoft Excel and Microsoft Excel Visual Basic Programming workshops to take you from the beginning to Excel power use. Our experience includes developing Microsoft Excel applications for companies like Northrop Grumman, NASA JPL, Caterpillar and the US Navy so whom better to teach you than a company that actually uses what they teach.

Our innovative style of teaching provides you with the best hands on training in the industry. You will be amazed at how much you can learn in such a short amount of time.

Our training programs are taught onsite at your workplace, through a LIVE broadcast webcast or you can come to one of our public courses. Anytime you take a course from us, you can come back any time and retake it free in our public course, an exceptional value.

Our Software, Not Just for Microsoft Excel

We develop software for Microsoft Excel as well as for Windows and other Microsoft products. We use a vast array of tools at EMAGENIT to help your company achieve its software goals. The tools we use include Microsoft Excel, Microsoft Excel VBA and Visual Basic .Net. Using these tools, EMAGENIT can create a unique business and engineering software design for your company that is more flexible than traditionally designed software tools and less expensive to build. We also use FORTRAN DLL, Visual Basic ActiveX, Microsoft Word, Microsoft Access and Microsoft SQL Server in our designs.

 

 

 

 

 

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-2009 EMAGENIT All Rights Reserved