Online Microsoft Excel / Excel VBA Virtual Learning

Excel Virtual Learning

Our 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.
  • Bring your questions and problems to the training. We love to see them.
  • We do not follow a manual, we use your problems and apply the outline to them.
  • Consult our Training Schedule and Signup > page for our virtual training dates.
  • Complete details > about how to take our virtual online courses.
Play Video >

Our virtual Excel / Excel VBA classes.

Beginning Microsoft Excel
Virtual (Everybody)

Syllabus > Beginning Excel Virtual Training
All Virtual Dates
Play Video

Intermediate Microsoft Excel
Virtual (Everybody)

Syllabus > Intermediate Excel Online Training
All Online Dates
Play Video

Advanced Microsoft Excel
Virtual (Everybody)

Syllabus > Advanced Excel Online Training
All Online Dates
Play Video

Microsoft Excel Dashboards
Virtual (Everybody)

Syllabus >
Microsoft Excel Dashboard Online Training
All Online Dates
Play Video

Beginning Excel VBA
Virtual (Everybody)

Syllabus > Beginning Microsoft Excel VBA Online Training
All Online Dates
Play Video

Advanced Excel VBA
Virtual (Everybody)

Syllabus > Advanced Microsoft Excel VBA Online Training
All Online Dates
Play Video

Microsoft Excel
Engineers / Scientists Virtual

Syllabus > Microsoft Excel Online Training for Engineers / Scientists
All Online Dates
Play Video

Microsoft Excel Data Analysis
Engineers / Scientists Virtual

Syllabus > Microsoft Excel Data Analysis Online Training for Engineers / Scientists
All Online Dates
Play Video

Excel VBA Fundamentals
Engineers/Scientists Virtual

Syllabus > Excel VBA Fundamentals Online Training for Engineers / Scientists
All Online Dates
Play Video

Advanced Excel VBA Methods
Engineers/Scientists Virtual

Syllabus > Advanced Excel VBA Online Training for Engineers / Scientists
All Online Dates
Play Video

Calling Fortran from Excel VBA
Engineers/Scientists Virtual

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

Free Repeats

Learn More >

Free repeats on our Excel classes

US Military Discounts

Learn More >

EMAGENIT US Military Discounts

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
< < < Scroll Picture > > >
In our hands-on Excel 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
< < < Scroll Picture > > >
In our real time hands-on Excel 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
< < < Scroll Picture > > >
In our virtual Excel 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
< < < Scroll Picture > > >
In our Excel 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
< < < Scroll Picture > > >
In Excel VBA 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 cutting edge 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 cutting edge 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 cutting edge 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
< < < Scroll Picture > > >
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

Microsoft Excel Products

- Excel Self-Study Manuals

Copyright © 2002-2021

EMAGENIT All Rights Reserved

Close