Microsoft Excel Onsites and Microsoft Excel VBA Onsites

Since 1998

Microsoft Excel Onsites and Microsoft Excel VBA Onsites

Business, Science and Engineering

Close

All Available Excel Onsite Classes

Training Dates Also Shown

Beginning Microsoft Excel
for Business Onsite

Syllabus / Signup >
Beginning Excel Onsite for Business
Next Date:
See Schedule
Play Video >

Intermediate Microsoft Excel
for Business Onsite

Syllabus / Signup >
Intermediate Excel Onsite for Business
Next Date:
See Schedule
Play Video >

Advanced Microsoft Excel
for Business Onsite

Syllabus / Signup >
Advanced Excel Onsite for Business
Next Date:
See Schedule
Play Video >

Beginning Excel VBA
for Business Onsite

Syllabus / Signup >
Beginning Microsoft Excel VBA Onsite for Business
Next Date:
See Schedule
Play Video >

Excel VBA Data Processing
for Business Onsite

Syllabus >
Excel VBA Data Processing Onsite for Business
Available Onsite Only
Play Video >

Advanced Excel VBA
for Business Onsite

Syllabus / Signup >
Advanced Microsoft Excel VBA Onsite for Business
Next Date:
See Schedule
Play Video >

Microsoft Excel
for Engineers / Scientists Onsite

Syllabus / Signup >
Microsoft Excel Onsite for Engineers / Scientists
Next Date:
See Schedule
Play Video >

Microsoft Excel Data Analysis
for Engineers / Scientists Onsite

Syllabus >
Microsoft Excel Data Analysis Onsite for Engineers / Scientists
Next Date:
See Schedule
Play Video >

Excel VBA Fundamentals
for Engineers / Scientists Onsite

Syllabus / Signup >
Excel VBA Fundamentals Onsite for Engineers / Scientists
Next Date:
See Schedule
Play Video >

Excel VBA Data Analysis
for Engineers / Scientists Onsite

Syllabus >
Excel VBA Data Analysis Onsite for Engineers / Scientists
Available Onsite Only
Play Video >

Advanced Excel VBA Methods
for Engineers / Scientists Onsite

Syllabus / Signup >
Advanced Excel VBA Methods Onsite for Engineers / Scientists
Next Date:
See Schedule
Play Video >

Calling Fortran DLLs from Excel VBA
for Engineers / Scientists Onsite

Syllabus / Signup >
Calling Fortran DLLs from Excel VBA Onsite for Engineers / Scientists
Next Date:
See Schedule
Play Video >

Microsoft Excel Dashboards
for Combined Audience Onsite

Syllabus / Signup >
Microsoft Excel Dashboard Onsite
Next Date:
See Schedule
Play Video >
>    >    >

Our hands-on Microsoft Excel onsites and Excel VBA onsites can show your company new innovative ways to use Excel in person or live online.

Our customized Microsoft Excel onsites and Excel VBA onsites focus on your company's specific Excel needs and problems. Our onsites can show you how to work faster and smarter in Excel leveraging all of its capabilities.

*EMAGENIT is still conducting our Excel onsite training live online. In states that allow onsites to take place, EMAGENIT is conducting onsite training.

Questions? 1.805.498.7162   Customers >

All Training Dates / Signup

View All >

Excel 2019 Training Dates/Signup

US Military, DOD Discounts

Learn More >

EMAGENIT US Military Discounts

The specifics about our hands-on Excel onsites and Excel VBA onsites. Taught live in person or live online.

  • EMAGENIT travels all over the United States and Canada for our Excel onsites and Excel VBA onsites. We can also travel outside of North America, 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 hands-on Microsoft Excel onsites and Microsoft Excel VBA onsites online around the world at anytime.
  • During an online onsite, attendees can see the instructor's computer and the instructor can see the attendee's computers for problem help with their permission.
  • If teaching an Excel online onsite, we can break the training up to meet your schedule.

Our Excel onsites and Excel VBA onsites cover every Microsoft Excel topic hands-on with industry proven know how.

Our Microsoft Excel onsites cover from beginning Excel to advanced Excel topics including Excel dashboards hands-on. Whether it is formatting a worksheet, building formulas, filtering data, building PivotTables, linking to databases, or using array formulas, we have it covered. Our Microsoft Excel VBA onsites cover from beginning Excel VBA to advanced Excel VBA topics. Our VBA onsites will show how to automate time consuming everyday Excel tasks; build powerful data processing and report generation tools in Excel; fuse and analyze multiple data sources in Excel at once; link to databases, automate dashboards...etc. Our instructors are actual Excel software developers that know what Excel topics you need to know.

Excel Formulas, Worksheet Functions and Data Processing.
In our Excel onsites, 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. When manual Excel methods are not enough, our Excel VBA onsite training can show you how to automate things like formula construction, worksheet formatting, table lookups, database queries and picture/shape manipulation.

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

Our Excel training and Excel VBA training outlines are only the starting point for our onsites. We can tailor an Excel onsite and Excel VBA 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 onsite solution. We never teach from a manual in our Excel and Excel VBA onsites; we think on our feet and will incorporate your company's Excel problems into our onsite training real time if the need arises.

Excel Combine Different Excel Features.
In our Excel onsites, 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 22 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. In our Excel VBA onsites, we will show you how to automate advanced displays using shapes, pictures, worksheet cell formatting, userforms, and ActiveX controls that allow high-end software to be developed like project management tools, dashboards, technical schematics, factory production...etc.

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

As many companies discover in our onsite 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 the real world to solve problems. This means we have seen a lot in a Excel, we have used Excel in a lot of different ways, and know a lot of Excel design strategies and construction methods that come from building high-end Excel software for the past 22 years.

Excel Conditional Formatting Combine.
In our Excel onsites, 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. In our Excel VBA onsites, we can show you how to build the data processing tools that analyze and organize data into usable tables that can then be used for reports. We can also show you how to automate the report above, output it to a different workbook, and email it to 20 people.

We break our Excel onsites and Excel VBA onsites into different professional groups.

Our Excel onsites and Excel VBA onsites are not a one fit for everyone type of training. We break our onsites into two main discipline categories: business and engineering / science. That way each group is free to be themselves in the onsite and use problems from their particular disciplines. To further enhance learning in our Excel onsites and Excel VBA onsites, we will try and group attendees together by skill level and make sure absolute beginners do not end up in intermediate offerings and so forth. If this is not possible due to training constraints, then we can tailor our onsite training to adjust for varying skill levels in the same onsite training as we have done many times.

ExcelPivot Tables, Pivot Charts and External Data.
In our Excel onsites, we can show you how to create PivotTables and PivotCharts. 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 PivotCharts and slicer are used to display product data by month and day. Formatting is used to break the days down. The PivotCharts table is linked to an Access database and can be refreshed. In our Excel VBA onsites, we can show you how to automate PivotTables and PivotCharts at the click of a button. We can also show you how to query workbooks, text files and databases using VBA and merge their data into tables that can then be used by PivotTables and PivotCharts.

Our Excel onsites and Excel VBA onsites will show you how to build Excel tools that saves time and money.

EMAGENIT has seen over and over that building software in Excel takes less time, resources and money than other development efforts in programming environments like C Sharp and VB.Net. Excel software tools in Excel can range from flexible reports that use Excel tables, adaptive formulas, and charts to advanced Excel VBA software that use userforms, talk to multiple data sources, and command multiple software products. Many of our Excel software tools 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 Excel onsites and Excel VBA onsites can show your company our time proven techniques that we use to develop Excel tools cheaply and rapidly. Our onsites can also show you how to build flexible Excel tools of any nature that are upgradeable, adaptable and scalable.

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 22 years of Excel VBA software design 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 for our Excel onsites.

All of our Excel onsites and Excel VBA onsites come with a 2200+ page manual with hundreds of examples. They are called Excel-Aided Engineering/Science > and Excel-Aided Business >. The manuals explain in detail what was covered in our onsite 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 onsite that applies to what is being done.

EMAGENIT Excel Manual.
Our Microsoft Excel manuals cover a wide variety of Microsoft Excel and Microsoft Excel VBA topics. They cover from beginning to advanced topics, have over 2200 pages, have detailed how to do Excel topics, and have hundreds real life of examples.
Contact Us Newsletter
Need Help? Please call us at 1.805.498.7162

Microsoft Excel Products

- Excel Self-Study Manuals

Copyright © 2002-2020

EMAGENIT All Rights Reserved