Home > Excel Training Options > Onsite Excel Training

Microsoft Excel Onsites and Excel VBA Onsites

Microsoft Excel Onsites and Microsoft Excel VBA Onsites

Our hands-on Microsoft Excel onsites will show your people how to work smarter and faster in Excel.

  • Our onsite training covers Excel and Excel VBA for Windows and Mac.
  • EMAGENIT is located in Nashville, Tn and provides in-person onsites for the US and Canada and virtually for the world.
  • EMAGENIT can supply Windows computers for our in person onsite training.
  • We can broadcast our onsites virtually around the world at anytime.
  • Contact EMAGENIT for pricing details.
Our Onsite Classes:
Beginning Excel
for Business / Industry
Intermediate Excel
for Business / Industry
Advanced Excel
for Business / Industry
Excel Dashboard Design
for Business / Industry
Beginning Excel VBA
for Business / Industry
Excel VBA Data Processing
for Business / Industry
Advanced Excel VBA
for Business / Industry
Microsoft Excel
for Engineers / Scientists
Excel Data Analysis
for Engineers / Scientists
Excel VBA
for Engineers / Scientists
Excel VBA Data Analysis
for Engineers / Scientists
Advanced Excel VBA Design
for Engineers / Scientists
Mixed Langauge Programming
with Excel VBA / Fortran
Learn the key Excel topics and problem solving skills you need to quickly accomplish everyday Excel workplace tasks. Learn to use tables, formulas, functions, and Excel's data tools to quickly perform calculations, analyze data, and create reports. Learn about Excel's advanced querying, formula, and data processing capabilities and use them to build automated calculation and reporting tools. Learn to assemble Excel's pre-made features to create powerful hi-tech dashboards that integrate, analyze, and visualize your data. Learn to build time-saving Excel VBA tools that automate common data processing, calculation, and formatting tasks in seconds. Learn to create powerful data tools in Excel VBA that quickly process, integrate, and report data from multiple sources, files, and folders. Learn to command the advanced abilities of Excel VBA and userforms to create interface driven data processing, analysis, and dashboard tools. Microsoft Excel for Engineers / Scientists Excel Data Analysis for Engineers / Scientists Excel VBA for Engineers / Scientists Excel VBA Data Analysis for Engineers / Scientists Advanced Excel VBA Design for Engineers / Scientists Mixed Language Programming with Excel VBA and Fortran
Free Repeats
Repeat your Excel workshop with us for an entire year for free.
Free Repeats
NASA Project
See how we helped NASA with the Mars Rover using Excel.
NASA
Discounts
We provide discounts to active / retired US Military and DOD.
Discounts
Customers
View our customers like Apple, Boeing, and the US Army.
Customers

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.

Click to enlarge, scroll < > if hidden.

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

Click to enlarge, scroll < > if hidden.

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

Click to enlarge, scroll < > if hidden.

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: general audience 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.

Click to enlarge, scroll < > if hidden.

In our Excel onsites, we can show you how to create PivotTables 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 Charts and slicer are used to display product data by month and day. Formatting is used to break the days down. The Pivot Charts 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 Pivot Charts 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 Pivot Charts.

Our Excel onsites and Excel VBA onsites will show you how to build Excel tools that save 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.

Click to enlarge, scroll < > if hidden.

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. 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. The EAE > our TCEM > manual you receive with our onsite courses cover from beginning Excel topics to Advanced Excel VBA topics with hundreds of examples.

Need Help? Please call us at 1.805.498.7162

Copyright © 2002-2022

EMAGENIT All Rights Reserved