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 >
Learn more about our Free Repeats policy
Beginning Excel Onsite for
Business Professionals >
Beginning Excel Training for Business
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 >
Advanced Excel Training for Business
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 >
Microsoft Excel-Aided Business
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 >
Microsoft Excel-Aided Engineering and Science
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 >
Microsoft Excel Dashboard Training
Next Date:
See Schedule
Introduction to Excel VBA Onsite for
Combined Audience >
Introduction to Excel VBA Training
Available Onsite Only
Microsoft Excel VBA Function Design Onsite for Combined Audience >
Microsoft Excel VBA Function Design
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 >

 Excel for Mac Training

US Military, DOD Discounts

Learn More >

EMAGENIT US Military Discounts

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.

Excel Combine Different Excel Features.
> > > >
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.

Excel Conditional Formatting Combine.
> > > >
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.

Excel VBA Programming.
> > > >
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.

EMAGENIT Excel Manual.
> > > >
Our Microsoft Excel manuals cover a wide variety of Microsoft Excel topics. At over 2200 pages, with detailed how to do Excel topics and hundreds of examples, it gives the phrase "wide variety" new meaning.

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.
  • EMAGENIT routinely holds our Excel onsite training in the following cities around are HQ: Thousand Oaks, CA; Newbury Park, CA; Westlake Village, CA; Simi Valley, CA; Oxnard, CA; Ventura, CA; Calabasas, CA; Agoura Hills, CA; Woodland Hills, CA; Malibu; CA; Topanga, CA; Moorpark, CA
  • We also routinely hold our onsites in the greater Santa Barbara, Ventura and Los Angeles counties including cities like: Santa Barbara, CA; Carpentaria, CA; Studio City, CA; Sherman Oaks, CA; Encino, CA; Westwood, CA, Santa Paula, CA; Valencia, CA; Santa Monica, CA and Los Angeles, CA; Pasadena, CA; Glendale, CA; Beverly Hills, CA; Culver City, CA; Marina Del Ray, CA; Santa Clarita, CA; Reseda, CA; Northridge, CA
  • We hold our onsites in Northern CA cities including: San Jose, CA; Mountain View, CA; Livermore, CA; Napa, CA; Healdsburg, CA; Sacramento CA; Stockton, CA; Sunnyvale, CA; San Francisco; Fresno, CA; Santa Rosa, CA
  • We also hold our onsites in San Diego and Orange county cities like: San Diego, CA; Oceanside, CA; Rancho Bernardo, CA; Poway, CA; Huntington Beach, CA; Costa Mesa, CA; Newport Beach, CA
  • As stated above, we hold our onsites across the US and routinely travel to: Dallas, TX; Fort Worth, TX; Greenville, SC; Nashville, TN; Orlando, FL; Ft Walton Beach, FL; Pensacola, FL; Boston, MA; Norfolk, VA; Newport News, VA; Arlington, VA; Philadelphia, PA, Portland, OR; Dearborn, MI; Detroit, MI; Ann Arbor, MI; Flint, MI; Newark, NJ, New York, NY
Facebook Contact Us Newsletter
Need Help? Please call us at 1.866.924.6244

Excel Software Design/Consulting

- Microsoft Excel Software

- Microsoft Excel Consulting

Microsoft Excel Products

- Excel Self-Study Manuals

Copyright © 2002-2019

EMAGENIT All Rights Reserved