Microsoft Excel and Excel VBA Onsites

Microsoft Excel Onsites and Microsoft Excel VBA Onsites

Our hands-on Microsoft Excel onsites will show your company new innovative ways to use Microsoft Excel and Excel VBA.

  • Our onsite Excel training covers Excel and Excel VBA for Windows and Mac.
  • EMAGENIT is located in Nashville, Tn. We cover the entire United States and Canada.
  • We are in the vicinity of Mt Juliet, Lebanon, Franklin, Murfreesboro, Smyrna, TN.
  • EMAGENIT can supply Windows computers for in person onsite training.
  • We can broadcast our onsites virtually around the world at anytime.
  • We can break up our virtual onsite training to meet your schedule.
  • We only need 3 people for a virtual onsite.
Play Video >

Our Excel Onsite Class Lineup.

Beginning Microsoft Excel
Onsite

Syllabus > Beginning Excel Onsite Training
Play Video

Intermediate Microsoft Excel
Onsite

Syllabus > Intermediate Excel Onsite Training
Play Video

Advanced Microsoft Excel
Onsite

Syllabus > Advanced Excel Onsite Training
Play Video

Microsoft Excel Dashboards
Onsite

Syllabus > Microsoft Excel Dashboard Onsite
Play Video

Beginning Excel VBA
Onsite

Syllabus > Beginning Microsoft Excel VBA Onsite Training
Play Video

Excel VBA Data Processing
Onsite

Syllabus > Excel VBA Data Processing Onsite Training
Play Video

Advanced Excel VBA
Onsite

Syllabus > Advanced Microsoft Excel VBA Onsite Training
Play Video

Microsoft Excel
Engineers / Scientists Onsite

Syllabus > Microsoft Excel Onsite for Engineers / Scientists
Play Video

Microsoft Excel Data Analysis
Engineers / Scientists Onsite

Syllabus > Microsoft Excel Data Analysis Onsite for Engineers / Scientists
Play Video

Excel VBA Fundamentals
Engineers / Scientists Onsite

Syllabus > Excel VBA Fundamentals Onsite for Engineers / Scientists
Play Video

Excel VBA Data Analysis
Engineers / Scientists Onsite

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

Advanced Excel VBA Methods
Engineers / Scientists Onsite

Syllabus > Advanced Excel VBA Methods Onsite for Engineers / Scientists
Play Video

Calling FORTRAN from Excel VBA
Engineers / Scientists Onsite

Syllabus > Calling Fortran DLLs from Excel VBA Onsite for Engineers / Scientists
Play Video
< < < Scroll Table > > >

Free Repeats

Learn More >

Free repeats on our Excel classes

US Military Discounts

Learn More >

EMAGENIT US Military Discounts

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

Need Help? Please call us at 1.805.498.7162

Microsoft Excel Products

- Excel Self-Study Manuals

Copyright © 2002-2021

EMAGENIT All Rights Reserved

Close