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 employees how to work smarter and faster in Excel when solving your company's problems.

View All Classes
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