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--

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.