Microsoft Excel Online Training and Excel VBA Online Training

Online Since 2005

Microsoft Excel Online Training: Live, Hands-On

Business, Science and Engineering

Next Online Training Dates

Beginning Excel Online Training for
Business Professionals

Syllabus / Signup >
Beginning Excel Online Training for Business
Next Date:
See Schedule

Intermediate Excel Online Training for
Business Professionals

Syllabus / Signup >
Intermediate Excel Online Training for Business
Next Date:
See Schedule

Advanced Excel Online Training for
Business Professionals

Syllabus / Signup >
Advanced Excel Online Training for Business
Next Date:
See Schedule

Beginning Excel VBA Online Training

for Business Professionals

Syllabus / Signup >
Beginning Microsoft Excel VBA Online Training for Business
Next Date:
See Schedule

Advanced Excel VBA Online Training

for Business Professionals

Syllabus / Signup >
Advanced Microsoft Excel VBA Online Training for Business
Next Date:
See Schedule

Microsoft Excel Online Training

for Engineers/Scientists

Syllabus / Signup >
Microsoft Excel Online Training for Engineers / Scientists
Next Date:
See Schedule

Microsoft Excel Data Analysis Online

Training for Engineers/Scientists

Syllabus / Signup >
Microsoft Excel Data Analysis Online Training for Engineers / Scientists
Next Date:
See Schedule

 Excel VBA Fundamentals Online Training for Engineers/Scientists

Syllabus / Signup >
Excel VBA Fundamentals Online Training for Engineers / Scientists
Next Date:
See Schedule

Advanced Excel VBA Online Training

for Engineers/Scientists

Syllabus / Signup >
Advanced Excel VBA Online Training for Engineers / Scientists
Next Date:
See Schedule

Calling Fortran DLLs from Excel VBA Online Training for Engineers/Scientists

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

Excel Dashboards Online Training

 for Combined Audience

Syllabus / Signup >
Microsoft Excel Dashboard Online Training
Next Date:
See Schedule
>    >    >

Our live, instructor led, hands-on, Microsoft Excel online training and Excel VBA online training is just like sitting in our classroom.

When you take our Excel online training or Excel VBA online training, you interact with a real instructor, not a video. Our online training provides real life, hands-on Excel examples that demonstrate the Excel skills and design know how to succeed.

All of our live, instructor led, Excel online training dates are running as scheduled.

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 details about our Microsoft Excel online training and Microsoft Excel VBA online training.

  • Our Excel online training and Excel VBA online training is broadcast live, hands-on, over the internet in a classroom environment.
  • We use GoToMeeting to broadcast our online Excel courses.
  • You need a microphone and a set of speakers for your computer. We can also call you.
  • We do not follow a manual in our Excel online training and Excel VBA online training which means our class problems come from our attendees and are applied to the outline topics.
  • Consult our Training Dates / Signup > page for our public training locations and dates.
  • Complete details about our online training >

We have 15+ years of experience in Excel online training and Excel VBA online training.

Since 2005, EMAGENIT has been providing live, hands-on, instructor led Microsoft Excel online training and Microsoft Excel VBA online training for customers like Disney, Citrix, NASA and Caterpillar. We know how to train you or your company online and interact with you just like sitting in front of you. In addition to public Excel online training, we also tie multiple corporate facilities together in our Excel corporate online training as well.

Excel Formula Construction and Data Processing
In our live, hands-on, Excel online training, we cover how to build formulas and use important worksheet functions like SUMIF, SUMIFS, VLOOKUP, COUNTIF... to crunch data. We also cover how to use names and things like Excel tables that help build your worksheets more quickly and make them easy to maintain when data shifts. In the worksheet example above, a simple SUMIF based formula is using an Excel table and string concatenation to figure out the defect count for each product.

All of our Excel online training and Excel VBA online training is  live broadcast and hands-on, never recorded.

Our Excel online training and Excel VBA online training is broadcast live with our Excel public training events, it is never recorded. That means you will be interacting with an instructor live during the online training and communicating with them directly. Our Excel and Excel VBA online training is always hands-on which means you are not sitting around staring at a computer screen, listening to a boring lecture with nothing to do, that you will not remember. We will keep you busy through the whole training session with Excel tasks involving formulas, formatting, filtering, functions, array formulas, pivot tables, power quires, charts...etc. On the Excel VBA side you will be automating Excel tasks, building data processing and report tools, creating dashboards...etc. We will show you the Excel design methods we have used over the past 22 years to get the job done. Our Excel online training will also show you the formatting and layout tricks that will help your Excel problems look professional and get you noticed.

Excel Charts and Formatting
In our live, hands-on, Excel online training, we cover not only how to build charts but how to format them as well. We will show you the formatting tricks that get you noticed as well as the many uses for charts in Excel that you have not seen yet. Our training will also show you how to combine charts with drawing shapes and pictures to build report quality presentations. In the worksheet example above, pie charts representing different projects and the % hrs worked on each have been formatted for different personnel. The charts link back to Pivot Tables that organize the data. In our Excel VBA online training, we will show you how to create pivot tables and charts automatically and format them.

Our Excel online training and Excel VBA online training is dynamic, we work with your problems.

In our Excel online training and Excel VBA online training, we work with our attendee's problems. All of our online training is taught around our attendee's problems that they bring to class, not using pre-made manual based problems. We think on our feet during our Excel instruction and always find a way to work our course syllabus around the issues that you are facing. Sometimes our attendees do not know exactly what they need for their Excel tasks, no problem. Our Excel online training and Excel VBA online training presents a wide range of Excel topics and strategies that can help our attendees identify what Excel topics they need to know and then focus on it.

Excel Combine Excel Features
In our live Excel online training, we cover not only how to use different Excel features to solve problems, we also teach how to combine them together to produce high-end visual tools. We teach you how to combine formulas, drawing shapes, ActiveX controls, pictures, charts, Pivot Tables, Conditional Formatting, logic and worksheet formatting. We will show you the tricks we have honed from over 22 years of building software for our clients. In the worksheet example above, VLOOKUP formulas retrieve the data for each vehicle from a separate worksheet table, with conditional formatting used to flag each vehicle when service is due. The truck pictures are dynamic and change with the data while an ActiveX control is used to select a sector to view. On the Excel VBA online training side, we will show you how to automatically format worksheets, move data around between workbooks, create shapes and calculate values at the click of a button.

We cover the Excel steps along with Excel problem design in our Excel online training and Excel VBA online training.

In our live Excel online training and Excel VBA online training, we not only lead our attendees through how to use Excel step by step, but also show them how to construct and layout different Excel problem types discussing the design strategies behind them in easy to understand instruction. Since EMAGENIT designs Excel software for large companies, we will show you what works and what Excel methods we use in our Excel software design to get the job done. You can be sure our Excel approaches are not academia based but have been battle tested in the real world and honed by over 22 years' worth of Excel design experience.

Excel Combine Excel Features
In our live Excel online training, we cover how to connect to and shape external data using tools like Power Query and MS Query. We also demonstrate how to use Excel tables to store data and use their references in formulas to make reports that adapt to changing data field lengths. Our training also covers how to construct pivot tables to analyze, organize and view data. In the worksheet example above, Power Query is being used to extract, merge and clean data from different workbook worksheet tables merging them into a single worksheet table. On the Excel VBA online training side, we will show you how to automate data processing; pivot table construction; database queries; and Excel table construction. VBA can be used to automate these Excel elements producing powerful report generation tools that do what commercial software cannot.

Our Excel online training and Excel VBA Online training are taught by instructors that develop Excel software for a living.

Our live Excel online training and Excel VBA online training are taught by instructors that develops high-end Excel based software for a living. What this means is that you are taught by someone who works in Excel for a living, not academia, and knows it strengths as well as its weaknesses and quirks. That said, our Excel online training and Excel VBA online training always presents Excel topics in easy to understand steps, no matter how complex the Excel subject matter. This means you will not be listening to some babbling Excel instructor discussing an Excel topic or Excel VBA topic that doesn't make any sense to you and that you cannot reproduce.

Excel Excel VBA Programming
In our live, hands-on, Excel VBA online training, we cover all aspects of Excel VBA programming. At EMAGENIT, we have been developing software in Excel VBA for over 22 years for customers like the US Navy, Medtronic and NASA so we know how to use it. Let our experience lead you from beginning Excel VBA all the way through the most advanced Excel VBA programming topics you can imagine. In the sample Excel VBA code above,  the worksheet table is sorted, filtered, copied and pasted to a new workbook then subtotaled.

Our Excel online training shows you cutting edge Excel design.

From our most basic Excel online training to our most advanced Excel VBA online training, we will show you how to assemble Excel program elements in cutting edge ways to solve your Excel tasks. Our Excel online training will show you how Excel's program elements work individually and how they work together as a part of a larger Excel problem solution. Excel can be used to build cutting edge report tools, models, dashboards, visual tools, database tools, time cards, project management tools,... using a variety of different Excel elements including formulas, array formulas, Excel tables, pivot tables, power queries, charts, shapes,...etc. Excel VBA can also be used to automate Excel and design amazing Excel tools that rival anything on the market at a fraction of the cost. Our Excel online training and Excel VBA online training will show you how to do all of it.

Excel VBA Cutting Edge Design
Most of all in our Microsoft Excel online training, we show you how to leverage all of Excel's features, graphics and VBA programming capabilities to design the tools that your business needs at a minimal cost and time expenditure. We will show you how to build adaptive, upgradeable, scalable tools. In the example worksheet above, Excel VBA is used to query an order number from an Access database and then the red shape pointer is moved to flag the appropriate bay. An ActiveX control is used to select the order while the order's information is output by VBA to the Order Status area. For more information about what is in the bay, the use clicks the bay shape to pull up a useform.

Our Excel online training and Excel VBA online training has a manual based on what we use online.

Our Excel-Aided Engineering/Science and Excel-Aided Business manuals provide detailed step by step Excel instruction, detailed pictures, tons of information and the know how we use to develop Excel software projects with. You can use it to recreate what we do online after the training. The EAE > or EAB > manual you get with our online training covers from beginning Excel topics to Advanced Excel VBA topics with hundreds of examples.
EMAGENIT Excel Manual
Our Microsoft Excel manuals cover everything we train you on in our classes with step by step visuals and a whole lot more. Clocking in at over 2200 + pages and hundreds of examples, it tends to lean to the whole lot more side.
Facebook 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