Microsoft Excel Onsites & Excel VBA Onsites

Since 1998

Microsoft Excel Company Onsites and Microsoft Excel VBA Company Onsites

Business, Science and Engineering

Available Microsoft Excel Onsite Classes

Next event dates also shown.

2019 Public Events
Schedule / Signup >

Upcoming 2018 Excel Public Events Schedule

Learn About Our Free Repeats For Our Excel Training >

Learn more about our Free Repeats policy

We Can Broadcast Your Onsite Online Live to You >

Beginning Excel Onsite for
Business Professionals >

Next Date:

See Schedule

Intermediate Excel Onsite for
Business Professionals >

Intermediate Excel Training for Business

Next Date:

See Schedule

Advanced Excel Onsite for
Business Professionals >

Next Date:

See Schedule

Beginning Excel VBA Onsite for
Business Professionals >

Beginning Microsoft Excel VBA Training for Business

Next Date:

See Schedule

Intermediate Excel VBA Onsite for
Business Professionals >

Intermediate Microsoft Excel VBA Training for Business

Available Onsite Only

Advanced Excel VBA Onsite for
Business Professionals >

Advanced Microsoft Excel VBA Training for Business

Next Date:

See Schedule

Microsoft Excel-Aided
Business Onsite >

Available Onsite Only

Microsoft Excel Data Analysis Onsite for
Engineers / Scientists >

Microsoft Excel Data Analysis for Engineers / Scientists

Available Onsite Only

Microsoft Excel Essentials Onsite for
Engineers / Scientists >

Microsoft Excel Essentials Training for Engineers / Scientists

Next Date:

See Schedule

Beginning Excel VBA Onsite for
Engineers / Scientists >

Beginning Excel VBA Training for Engineers / Scientists

Next Date:

See Schedule

Intermediate Excel VBA Onsite for
Engineers / Scientists >

Intermediate Excel VBA Training for Engineers / Scientists

Available Onsite Only

Advanced Excel VBA Onsite for
Engineers / Scientists >

Advanced Excel VBA Training for Engineers / Scientists

Next Date:

See Schedule

Microsoft Excel-Aided
Engineering and Science Onsite >

Available Onsite Only

Interfacing FORTRAN with Excel VBA Onsite for Engineers / Scientists >

Interfacing FORTRAN with Excel VBA for Engineers / Scientists

Available Onsite Only

Microsoft Excel Dashboards Onsite for
Combined Audience >

Next Date:

See Schedule

Introduction to Excel VBA Onsite for
Combined Audience >

Available Onsite Only

Microsoft Excel VBA Function Design Onsite for Combined Audience >

Available Onsite Only

> > > >

Innovative Microsoft Excel onsite training.

Our hands-on customized Microsoft Excel onsite training focuses on your company's specific Microsoft Excel needs.

Questions? 1.866.924.6244 Customers >

We cover Excel for Mac.

Learn More >

US Military, DOD Discounts

Learn More >

We cover every Microsoft Excel topic hands-on with industry proven know how.

Our Excel onsite training covers from beginning Excel to advanced Excel VBA macro topics hands-on. Whether it is formatting a worksheet, building formulas, filtering data, building Pivot Tables, linking to databases, or building VBA macros, we have it covered. Our instructors are actual Excel software developers that know what Excel topics you really need.

Excel Formulas, Worksheet Functions and Data Processing.

> > > >

In our Excel onsite training, we cover the little things as well as the big things that you need to know when constructing formulas and processing data. We cover the beginning worksheet functions like SUM as well as important worksheet functions like IF, INDIRECT and VLOOKUP. Our training also covers the subtle important things that are often overlooked like names, Excel tables and string concatenation ( i.e. &'s). We also cover how to lay things out on the worksheet and format it for rapid reporting and modeling. In the example worksheet above, a simple IF/VLOOKUP formula tracks the order # in an Excel table on another worksheet that is linked to a database while Conditional Formatting is used to switch the transit graphic status. Bing maps is used to display the current location.

We customize our Excel company onsites and think on our feet.

Our Excel training outlines are only the starting point for our Excel onsites. We can tailor an Excel onsite for your company that follows a particular outline with and customized problems or we can mix and match different parts of our outlines to tailor a unique Excel onsite solution. We never teach from a manual script in our Excel onsites, we think on our feet and will incorporate your company's Excel problems into our onsite training real time if necessary.

> > > >

In our Excel onsite training, we go way beyond normal Excel training, we can show you how to combine Excel features to produce stunning visual displays that help convey the state of your data. We will teach you how to use formulas, charts, Conditional Formatting, worksheet formatting, drawing shapes and pictures separately then combine them to produce a desired result. We have over 20 years of experience designing software in Excel for customers like Lockheed Martin and Caterpillar. In the worksheet example above, pie charts and drawing shapes are used to build the gauges while Conditional Formatting is used to color the red/ green status. ActiveX controls are used to select the product, month and year to view in the charts.

Our Excel onsites cover the Excel details that others leave out.

As many companies discover in our training, we cover more Excel topics that your company will use in 2 hrs than most Excel training companies cover in a day. We have been told this repeatedly. That is because our Excel instructors are actual Excel software developers and know what Excel topics are used in industry. This means we have seen a lot, we have manipulated Excel a lot, and know a lot of Excel tricks that come from building software and "blowing up" Excel a couple of 100 times over the years.

> > > >

In our Excel onsite training, we can show you how to use things like Data Validation and Conditional Formatting in unique ways to produce various management tools like coloring the cells red in the simple inventory tool above. Using Conditional Formatting, we can also show you how to use it to just flag your data. Oh yes, we also cover the logic. In the example worksheet above, VLOOKUP and IF formulas are used to distribute the inventory data from an Excel table throughout the dashboard while Conditional Formatting is used to color the short values red.

We break our onsites into different professional groups.

Our Excel onsite training is not a one fit for everyone deal. We break our Excel classes into two main discipline categories: business and engineering / science. That way each group is free to be themselves without boring and confusing the other side.

ExcelPivot Tables, Pivot Charts and External Data.

> > > >

In our Excel onsite training, we can show you how to create Pivot Tables and Pivot Charts. We can also show you how to shape and process your data using Power Query or using Microsoft Query and tying your data to external data sources like other workbooks, text files, databases. In the worksheet example above, a Pivot Chart and slicer are used to display product data by month and day. Formatting is used to break the days down. The Pivot Chart table is linked to an Access database and can be refreshed.

Our Excel onsite training will show you how to build Excel software that saves time and money.

EMAGENIT has seen over and over that building software in Excel takes less time, resources and money than other approaches. Many of our Excel projects for companies that were meant to be stop gap measures while the magical all-in-one piece of software was being built have eventually became the main software used while the other effort failed. Our onsite Excel training can show your company our time proven techniques that we use to develop Excel software cheaply and rapidly.

> > > >

In our Excel onsite training, we also show you how to use Excel VBA to create powerful reporting, modeling and dashboard tools for a fraction of the cost of existing software. We teach you the programing strategies that you need to succeed like processing100 workbooks of data. Our training can take you from beginning to the most advanced VBA programming topics using our 20 + years of Excel VBA experience. In the sample Excel VBA code above, AutoFilter is used to filter the data by shift then the data is copied and pasted to a new workbook and worksheet. The total hours is then summed.

A detailed manual with loads of examples and lots of visuals.

All of our Excel onsites come with a 2200+ page Excel engineering/science or business manual. The manual explains in detail what was covered in our training so you can review the strategies and methods step-by-step after the class. We will direct you to the manual sections of interest during the training.

The details about our Microsoft Excel onsites.

EMAGENIT travels all over the USA for our hands-on Excel onsites. We also travel outside the USA, contact EMAGENIT for details.
We can supply computers for your staff to use for any version of Microsoft Excel for Windows. We do not supply computers for Excel for Mac although we can train on a Mac.
We can broadcast our Microsoft Excel and Microsoft Excel VBA onsite training directly to your company via the internet around the world at anytime.
During an onsite webinar, attendees can see the instructor's computer and the instructor can see the attendee's computers for instruction with their permission.
If teaching an Excel onsite webinar, we can break the training up to meet your schedule.