Hands-On, Online, Live Excel Courses

Online Since 2005

Microsoft Excel Online Courses: Live, Hands-On
Close

Beginning Microsoft Excel
Online

Syllabus > Beginning Excel Online Training
All Online Dates
Next Class:
See Schedule
Play Video

Intermediate Microsoft Excel
Online

Syllabus > Intermediate Excel Online Training
All Online Dates
Next Class:
See Schedule
Play Video

Advanced Microsoft Excel
Online

Syllabus > Advanced Excel Online Training
All Online Dates
Next Class:
See Schedule
Play Video

Microsoft Excel Dashboards
Online

Syllabus >
Microsoft Excel Dashboard Online Training
All Online Dates
Next Class:
See Schedule
Play Video

Beginning Excel VBA
Online

Syllabus > Beginning Microsoft Excel VBA Online Training
All Online Dates
Next Class:
See Schedule
Play Video

Advanced Excel VBA
Online

Syllabus > Advanced Microsoft Excel VBA Online Training
All Online Dates
Next Class:
See Schedule
Play Video

Microsoft Excel
Engineers / Scientists Online

Syllabus > Microsoft Excel Online Training for Engineers / Scientists
All Online Dates
Next Class:
See Schedule
Play Video

Microsoft Excel Data Analysis
Engineers / Scientists Online

Syllabus > Microsoft Excel Data Analysis Online Training for Engineers / Scientists
All Online Dates
Next Class:
See Schedule
Play Video

Excel VBA Fundamentals
Engineers/Scientists Online

Syllabus > Excel VBA Fundamentals Online Training for Engineers / Scientists
All Online Dates
Next Class:
See Schedule
Play Video

Advanced Excel VBA Methods
Engineers/Scientists Online

Syllabus > Advanced Excel VBA Online Training for Engineers / Scientists
All Online Dates
Next Class:
See Schedule
Play Video

Interfacing Excel VBA Fortran
Engineers/Scientists Online

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

Our live, hands-on, online Microsoft Excel courses are just like sitting in our public classroom. We simulcast them the same day.

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

Questions? 1.805.498.7162   Customers >

Free Repeats

Learn More >

Free repeats on our Excel classes

US Military Discounts

Learn More >

EMAGENIT US Military Discounts

The details about our Microsoft Excel online courses and Microsoft Excel VBA online courses.

  • Our Excel and Excel VBA online courses are broadcast live, hands-on, over the internet in a classroom environment.
  • We use WebEx 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 and Excel VBA online courses which means our class problems come from our attendees and are applied to the outline topics.
  • Consult our Training Schedule and Signup > page for our public training event locations and dates.
  • Complete details about how to take our online courses >

We have 16+ years of experience in Excel and Excel VBA online courses.

Live since 2005, EMAGENIT has been providing live, hands-on, Microsoft Excel and Microsoft Excel VBA online courses for customers like the US Air Force, US Navy, Disney, 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 online courses, we can also tie multiple corporate facilities together for an online session as well.

Excel Formula Construction and Data Processing
< < < Scroll Picture > > >
In our live, hands-on, Excel online 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 and Excel VBA online courses are broadcast live and hands-on, never recorded.

Our Excel  and Excel VBA online courses are broadcast live with our public Excel training events, they are never recorded. That means you will be interacting with an instructor live during the online session and communicating with them directly. Our online courses are 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 online 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 the Excel design methods we have used over the past 23+ years to get the job done. Our 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 live, hands-on, Excel online 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 online courses, we will show you how to create PivotTables and charts automatically and format them.

Our Excel and Excel VBA online courses are dynamic, we work with your problems.

In our Excel and Excel VBA online courses, we work with our attendee's problems. All of our online courses 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 online courses present 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
< < < Scroll Picture > > >
In our live 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 online 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 program steps along with problem design in our Excel and Excel VBA online courses.

In our live Excel and Excel VBA online courses, 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 23+ years' worth of Excel design experience.

Excel Combine Excel Features
< < < Scroll Picture > > >
In our live Excel online 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 online 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 and Excel VBA Online courses are taught by instructors that develop Excel software for a living.

Our live Excel and Excel VBA online courses 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 quirks. That said, our online 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 our live, hands-on, Excel VBA online 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 Excel and Excel VBA online courses show you cutting edge design.

From our most basic Excel online course to our most advanced Excel VBA online course, we will show you how to assemble Excel program elements in cutting edge ways to solve your Excel tasks. Our online courses 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, PivotTables, 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 online courses will show you how to do all of it.

Excel VBA Cutting Edge Design
< < < Scroll Picture > > >
Most of all in our Microsoft Excel online 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 and Excel VBA online courses have a manual based on what we use online.

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