Microsoft Excel Webinars & Excel VBA Webinars - Online Training

Since 1998

Excel Online Training and Excel VBA Online Training

Business, Science and Engineering

Talk to your instructor, hands-on, small class size, online Excel webinar training.

Our instructor led, live, hands-on, online Microsoft Excel and Excel VBA webinar training contains the real world knowledge that you need to succeed.

Questions? 1.805.498.7162 Customers >

We cover Excel for Mac.

Learn More >

US Military, DOD Discounts

Learn More >

We have years of Excel online webinar training experience.

Since 2005, EMAGENIT has been providing 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 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 webinar training is live 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 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 Excel online webinar 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 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 webinars.

In our 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 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 Online Excel webinar training is Taught by instructors that develop Excel software.

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