Home > Microsoft Excel Classes

Live Hands-On Microsoft Excel Classes

Microsoft Excel Classes

Knowledge packed classes that show how to leverage Excel to rapidly solve your problems.

  • We cover all skill ranges from beginning Excel to advanced Excel VBA.
  • We custom tailor our training to our audience and their specific Excel problems.
  • We divide our classes into two audience types: business / industry > and engineering / science >.
  • We offer our classes online, public-in-person, and onsite with repeats >.
Black Friday Sale
Business and Industry
Beginning Excel for Business and Industry

Beginning Excel
for Business and Industry

Learn the key Excel topics and problem solving skills you need to quickly accomplish everyday Excel workplace tasks.
More >

Duration: 1-day

Training Options: Public, Virtual, Onsite

Intermediate Excel for Business and Industry

Intermediate Excel
for Business and Industry

Learn to use tables, formulas, functions, and Excel's data tools to quickly perform calculations, analyze data, and create reports.
More >

Duration: 1-day

Training Options: Public, Virtual, Onsite

Advanced Excel for Business and Industry

Advanced Excel
for Business and Industry

Learn about Excel's advanced querying, formula, and data capabilities and use them to build automated calculation and reporting tools.
More >

Duration: 1-day

Training Options: Public, Virtual, Onsite

Excel Dashboards for Business and Industry

Excel Dashboard Design
for Business and Industry

Learn to assemble Excel's "pre-made" features to create powerful hi-tech dashboards that integrate, analyze, and visualize your data.
More >

Duration: 3-day

Training Options: Public, Virtual, Onsite

Beginning Excel VBA for Business and Industry

Beginning Excel VBA
for Business and Industry

Learn to build time-saving Excel VBA tools that automate common data processing, calculation, and formatting tasks in seconds.
More >

Duration: 2-day

Training Options: Public, Virtual, Onsite

Excel VBA Data Processing for Business and Industry

Excel VBA Data Processing
for Business and Industry

Learn to create powerful data tools in Excel VBA that quickly process, integrate, and report data from multiple sources, files, and folders.
More >

Duration: 2-day

Training Options: Public, Virtual, Onsite

Advanced Excel VBA for Business and Industry

Advanced Excel VBA
for Business and Industry

Learn to command the advanced abilities of Excel VBA and userforms to create interface driven data processing, analysis, and dashboard tools.
More >

Duration: 3-day

Training Options: Public, Virtual, Onsite

Engineers and Scientists
Microsoft Excel for Engineers and Scientists

Microsoft Excel
for Engineers and Scientists

Learn to harness Excel's powerful calculation, charting, display, and UI abilities to rapidly build modeling and analysis tools.
More >

Duration: 1-day

Training Options: Public, Virtual, Onsite

Microsoft Excel Data Analysis for Engineers and Scientists

Excel Data Analysis
for Engineers and Scientists

Learn to combine Excel's external querying abilities, functions, and data tools to integrate / analyze data and build automated reports.
More >

Duration: 1-day

Training Options: Public, Virtual, Onsite

Excel VBA for Engineers and Scientists

Excel VBA
for Engineers and Scientists

Learn the fundamentals of using Excel VBA to automate calculations, perform data processing, model, and create rapid reporting tools.
More >

Duration: 2-day

Training Options: Public, Virtual, Onsite

Excel VBA Data Analysis for Engineers and Scientists

Excel VBA Data Analysis
for Engineers and Scientists

Learn to design scalable Excel VBA data tools that analyze, format, integrate, and report data from multiple sources, files, and folders.
More >

Duration: 2-day

Training Options: Public, Virtual, Onsite

Advanced Excel VBA Design for Engineers and Scientists

Advanced Excel VBA Design
for Engineers and Scientists

Learn about Excel and VBA's extensive UI capabilities and create powerful interface driven data processing, modeling, and analysis apps.
More >

Duration: 3-day

Training Options: Public, Virtual, Onsite

Interfacing Excel VBA with Fortran for Engineers / Scientists  Outline

Multi-Language Programming
with Excel VBA / Fortran

Learn to combine the interface and data abilities of Excel VBA with the speed of Fortran DLLs to create powerful modeling and analysis tools.
More >

Duration: 3-day

Training Options: Onsite

Microsoft Excel classes that cover from basic to advanced topics.

Our Excel classes cover basic topics like formatting, data entry, and formula construction to advanced Excel VBA topics like multi-workbook data processing, modeling, and UI design. If it is possible to build in Excel, we can show you how to do it.

Excel Classes Formulas, Conditional Formatting and VBA Programming.

Click to enlarge, scroll < > if hidden.

In our Excel classes, we cover topics from simple formula design, to coloring cells with logic using Conditional Formatting, to creating charts, to using controls and shapes, to using Excel VBA macros to automate Excel tasks. We will show you how to put it all together to build the Excel tools you need. You will also be surprised at how a little bit of Excel knowledge goes a long way.

We do not teach our hands-on Excel classes from a manual.

Our hands-on, instructor led classes are taught around the real world problems that you face, not from a rigid manual that you just read and do problems from.

We always integrate the problems that you bring with you to class in our instruction so you get the most out of the training.

If we can not cover a problem in class due to complexity or length, we will cover the topics that apply to the problem and crank out an example after the class for you.

Connecting to External Data Sources.

Click to enlarge, scroll < > if hidden.

In our Excel classes, we will teach you how to dynamically connect to external data sources like Microsoft Access and update that data at the click of a button. We can show you how to build things like dashboards that use linked pictures that display other worksheet ranges and dynamically update when their associated ranges do. We also show you how to use "off the shelf" components in Excel to rapidly build things.

We cover all types of Excel solutions and math levels in our Excel classes.

We not only teach the application of Excel towards practical problems including data processing, we are also comfortable teaching high-tech problems in Excel and their math as well.

EMAGENIT was founded by an engineer so we enjoy these types of problems when we encounter them and do not shy away from them. From practical Excel solutions to the most advanced math, we have you covered.

Advanced Engineering and Science Problems and Formulas.

Click to enlarge, scroll < > if hidden.

In our Excel classes, we can show you how to layout and construct high end technical problems in Excel like the simple ideal ramjet problem pictured above. We can not only show you how to solve problems on the worksheet using advanced formulas, we can also show you how to use Excel VBA macros integrated with VB.NET, CSharp, Fortran,... to solve the really tough stuff.
Need Help? Please call us at 1.805.498.7162

Copyright © 2002-2022

EMAGENIT All Rights Reserved