Microsoft Excel Online Training: Live, Hands-On

Since 1998

Business, Science and Engineering

Next Live Excel Online Training Dates

Beginning Excel for
Business Professionals

Syllabus / Signup >

Beginning Excel Online Training for Business

Next Date:

See Schedule

Intermediate Excel for
Business Professionals

Syllabus / Signup >

Intermediate Excel Online Training for Business

Next Date:

See Schedule

Advanced Excel for
Business Professionals

Syllabus / Signup >

Advanced Excel Online Training for Business

Next Date:

See Schedule

Beginning Excel VBA for
Business Professionals

Syllabus / Signup >

Beginning Microsoft Excel VBA Online Training for Business

Next Date:

See Schedule

Advanced Excel VBA for
Business Professionals

Syllabus / Signup >

Advanced Microsoft Excel VBA Online Training for Business

Next Date:

See Schedule

Microsoft Excel for
Engineers / Scientists

Syllabus / Signup >

Microsoft Excel Online Training for Engineers / Scientists

Next Date:

See Schedule

Microsoft Excel Data Analysis for
Engineers / Scientists

Syllabus / Signup >

Microsoft Excel Data Analysis Online Training for Engineers / Scientists

Next Date:

See Schedule

Excel VBA Fundamentals for
Engineers / Scientists

Syllabus / Signup >

Excel VBA Fundamentals Online Training for Engineers / Scientists

Next Date:

See Schedule

Advanced Excel VBA for
Engineers / Scientists

Syllabus / Signup >

Advanced Excel VBA Online Training for Engineers / Scientists

Next Date:

See Schedule

Calling Fortran DLLs from Excel VBA for
Engineers / Scientists

Syllabus / Signup >

Next Date:

See Schedule

Excel Dashboards for
Combined Audience

Syllabus / Signup >

Microsoft Excel Dashboard Online Training

Next Date:

See Schedule

> > >

Our live, instructor led, hands-on, online Excel training is just like sitting in the classroom with EMAGENIT.

Our online Microsoft Excel and Excel VBA online training contains the real world knowledge that you need to succeed in your job.

Questions? 1.805.498.7162 Customers >

All Training Dates / Signup

View All >

US Military, DOD Discounts

Learn More >

Our live, hands-on, Microsoft Excel online training details.

Our Excel online training is broadcast live, hands-on, over the internet in a class room 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 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 years of experience broadcasting live, hands-on Excel online classes.

Since 2005, EMAGENIT has been providing live, hands-on, online Microsoft Excel training and online Microsoft Excel VBA training for customers like Disney, Citrix, NASA and Caterpillar. We know how to train you over the web and interact with you just like sitting in front of you.

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 online Excel training is instructor led, live broadcast and hands-on.

Our Excel online training is never recorded which means you will be interacting with an instructor live during the training and communicating with them directly. Our online training is always hands-on which means you are not sitting around listening to a boring lecture with nothing to do that you will not remember. We will keep you busy through the whole session.

> > > >

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.

Our live broadcast, online Excel instruction is dynamic, we work with your problems.

We react to your needs online. All of our Excel online training is taught around our customer's problems that they bring to class, not using pre-made manual based problems. We think on our feet during our Excel instruction so we find a way to work our course syllabus around the issues that you are facing.

> > > >

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 20 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.

We cover the Excel steps as well as the strategies in our online Excel training.

In our live broadcast Excel online training, we lead our attendees through the visual Excel steps as well as the design strategies conveying them in easy to understand terminology. We show our attendees what we use to design Excel software with.

> > > >

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.

Our live broadcast Online Excel training is taught by instructors that develop Excel software.

Our live Excel online training is taught by instructors that develop high-end Excel based software. This means you are always guaranteed to get industry real world solutions, not theory based academic ones that are useless. We also insert valuable Excel tips based on what we have learned from 20+ years of Excel software development.

> > > >

In our live, hands-on, Excel online training, we cover all aspects of Excel VBA programming. At EMAGENIT, we have been developing software in Excel VBA for over 20 years for customers like the US Navy and Medtronic 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 webinar training shows you cutting edge Excel design.

From our most basic to our most advanced online Microsoft Excel training, we show you how to assemble Excel program elements in cutting edge ways to solve your problem. We also show you the little details that enable you to not only solve your problem but produce "the look" that your customers will want.

> > > >

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. 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.

Houston, we have an Excel manual.

We have had the privilege of working with NASA so we had to throw that one in. Our Excel engineering/science or business manuals provide detailed step by step 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.