Home > Excel Training Options > Excel Virtual Learning

Online Microsoft Excel / Excel VBA Virtual Learning

Excel Virtual Learning

Our live hands-on Microsoft Excel / Excel VBA virtual learning is just like sitting in our public classroom.

  • Our virtual learning covers beginning Excel to advanced Excel VBA for Windows and Mac.
  • Our Excel / Excel VBA virtual learning is taught in a classroom style setting.
  • You can bring your questions and problems to training, we love to see them.
  • We do not follow a manual, we use your problems and apply the outline to them.
  • Complete details > about how to take our virtual online courses.
Our Online 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
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
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

We have 16+ years of experience in Excel / Excel VBA virtual learning. We are not new to the game.

Since 2005, EMAGENIT has been providing virtual, hands-on, Microsoft Excel / Excel VBA learning courses for customers like the US Air Force, US Navy, Disney, NASA, and Caterpillar. We know how to train you or your company virtually and how to interact with you directly. In addition to our public virtual courses, we can also tie multiple corporate facilities together for a virtual onsite learning session as well.

Excel Formula Construction and Data Processing

Click to enlarge, scroll < > if hidden.

In our virtual courses, 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 / Excel VBA virtual learning sessions are real time and hands-on, never recorded.

Our Excel / Excel VBA virtual learning sessions are broadcast real time with our public Excel training events. You will be interacting with an instructor live during the virtual online session and talking directly with them. Our virtual courses are always live hands-on which means you are not just watching a lecture. We will keep you busy through the whole virtual session with Excel tasks involving formulas, formatting, filtering, functions, array formulas, PivotTables, 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 our Excel design methods we have used over the past 23+ years to get the job done. Our virtual online courses 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

Click to enlarge, scroll < > if hidden.

In our virtual courses, 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 courses 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 PivotTables that organize the data. In our Excel VBA virtual courses, we will show you how to create PivotTables and charts automatically and format them.

Our Excel / Excel VBA virtual learning sessions are dynamic, we work with your problems.

In our Excel and Excel VBA virtual training, we work with our attendee's problems. All of our virtual online sessions are taught around our attendee's problems that they bring to class, not using pre-made manual 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 virtual courses present a wide range of Excel topics and strategies that can help our attendees identify what topics they need to know and then focus on it.

Excel Combine Excel Features

Click to enlarge, scroll < > if hidden.

In our virtual online courses, 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, PivotTables, Conditional Formatting, logic and worksheet formatting. We will show you the tricks we have honed from over 23+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 virtual courses 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 as well as problem design in our Excel / Excel VBA virtual learning.

In our Excel / Excel VBA virtual learning, 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 show you the 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 and have been battle tested in the real world and honed by over 23+ years' worth of Excel design experience.

Excel Combine Excel Features

Click to enlarge, scroll < > if hidden.

In our virtual courses, 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 courses also cover how to construct PivotTables 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 virtual courses side, we will show you how to automate data processing; PivotTable 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 / Excel VBA virtual courses are taught by instructors that develop Excel software for a living.

Our Excel / Excel VBA virtual learning sessions are taught by instructors that develop 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 little quirks. That said, our virtual courses always present Excel topics in easy to understand steps, no matter how complex the Excel subject matter. This means you will not be listening to an Excel instructor discussing an Excel topic that doesn't make any sense to you and that you cannot reproduce.

Excel Excel VBA Programming

Click to enlarge, scroll < > if hidden.

In virtual courses, we cover all aspects of Excel VBA programming. At EMAGENIT, we have been developing software in Excel VBA for over 23+ 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 online Excel / Excel VBA virtual learning, we show you innovative design and methods.

From our most basic Excel virtual course to our most advanced Excel VBA virtual online course, we show you how to combine Excel program elements in innovative ways to solve your Excel tasks. Our virtual learning shows 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 powerful report tools, models, dashboards, visual tools, database tools, time cards, project management tools,... using a variety of different Excel elements. Excel VBA can also be used to automate Excel and design amazing Excel tools that rival industry standard tools on the market at a fraction of the cost.

Excel VBA Cutting Edge Design

Click to enlarge, scroll < > if hidden.

Most of all in our Microsoft Excel virtual courses, we show you how to leverage all of Excel's features, graphics and VBA programming capabilities to design the tools that your business / organization 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 user clicks the bay shape to pull up a userform.

Our Excel / Excel VBA virtual learning sessions comes with a manual based on what we use in class.

Our Excel 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 virtually after the training. The EAE > or TCEM > manual you receive with our virtual online 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