Excel Training, Excel VBA Training, Excel Software Design

Microsoft Excel Classes and Microsoft Excel VBA Classes - Guide and Skill Levels

Microsoft Excel Workshops and Microsoft Excel VBA Workshops - Guide and Skill Levels

Business, Engineers and Scientists

Our "hands-on" Microsoft Excel classes and Microsoft Excel VBA classes are taught around real world problems that you face in your everyday work.

Our class guide below is designed to show you what Microsoft Excel class or Microsoft Excel VBA class is right for you. When viewing the guide remember, our classes are divided into two major categories: Microsoft Excel classes and Microsoft Excel VBA classes. Those main categories are then sub divided into three main professional categories: business professionals, engineering and science professionals, and combined audience.

Microsoft Excel Class Skill Levels and Guide

Determine the Type of Microsoft Excel Class You Need:

EMAGENIT offers the following Microsoft Excel class and Microsoft Excel VBA class options:

  • Public Seminar Excel Class: You or your group travel to us at our seminar location and take an Excel class or Excel VBA class.
  • Live Online Webinar Excel Class: We teach our Excel class or Excel VBA class to you or your group live over the web "hands-on". Learn about how we broadcast.
  • Company Onsite Excel Class: EMAGENIT travels to directly to your company to teach an Excel class or Excel VBA class supplying computers if you need them or teaches your company via the web.
  • Self Study: You buy a self-study manual from EMAGENIT and can apply the manual price to an Excel class or Excel VBA class latter on if you desire. No gimmicks, no hidden restrictions, no time limit.

Our Excel Class Schedule page always lists our current public seminar and live webinars and their next scheduled dates. We teach these classes together. For company onsite please visit our Company Onsite page for more details.

See How We Classify Your Profession in Our Excel Classes

EMAGENIT Microsoft Excel classes and Microsoft Excel VBA classes are divided based upon these profession classifications:

  • Business Professional: You work in a non-technical field, you are not in research or creating, building or analyzing high tech things.
  • Engineering and Science Professional: You are an engineer or science major or work as a technician in these areas.
  • Combined Audience: This is a category of class we developed that applies to everybody.

Before proceeding, make a determination of what profession category best represents what you or your group do.

What Type of Excel Class Do You Need?

EMAGENIT has two types of Microsoft Excel classes:

  • General Microsoft Excel Classes: You or your group learn how to write formulas, construct pivot tables, format worksheets, construct array formulas, filter data...etc, basically manually manipulating the Excel environment.
  • Microsoft Excel VBA Classes (Macros):You or your group learn how to write computer code in Visual Basic for Applications (VBA) that automate Microsoft Excel tasks like data processing, automatic chart creation, commanding Microsoft Word and PowerPoint...etc. Generally, any class with VBA or Macros in its title is going to deal with programming. What is VBA?

Determine Your Microsoft Excel Class by Your Profession

Excel Classes for Business

<<< Scroll Left to See Classes

Beginning Microsoft Excel Class for Business Professionals Outline and Signup

Beginning Microsoft Excel Class
for Business Professionals

Next Date
Click Signup

Duration: 1-day

Available: Seminar, Webinar, Onsite, Self-Study

Manual: Self-Study Manual Included

Required Excel Class Skills:

Select this Microsoft Excel class if you or your group have:

  • Never opened Microsoft Excel
  • Never heard of a workbook, worksheet or cell
  • Just typed data in it
  • Have never typed formulas or functions
  • Have never sorted or filtered data
  • Have no idea what we just said

Excel Class Overview:

Our 1-day "hands-on" beginning Microsoft Excel class shows you the essential skills you need to use Microsoft Excel in your daily business activities right away.

Complete Excel Class Outline/Signup

Intermediate Microsoft Excel Class for Business Professionals Outline and Signup

Intermediate Microsoft Excel Class
for Business Professionals

Next Date
Click Signup

Duration: 1-day

Available: Seminar, Webinar, Onsite, Self-Study

Manual: Self-Study Manual Included

Required Excel Class Skills:

Select this Microsoft Excel class if you or your group have:

  • Opened or saved a workbook
  • Learned about worksheets, cells and cell references like A1
  • Copied and pasted worksheet data
  • Performed basic cell formatting tasks
  • Typed data in cells and built basic formulas
  • Used a worksheet function like SUM

Excel Class Overview:

Our 1-day "hands-on" intermediate Microsoft Excel class shows you intermediate Excel skills that apply to analyzing basic business information. Topics include creating useful formulas; using worksheet functions like VLOOKUP,SUMIF,IF...; creating basic Pivot Tables and using Excel's many data processing tools.

Complete Excel Class Outline/Signup

Advanced Microsoft Excel Class for Business Professionals Outline and Signup

Advanced Microsoft Excel Class
for Business Professionals

Next Date
Click Signup

Duration: 1-day

Available: Seminar, Webinar, Onsite, Self-Study

Manual: Self-Study Manual Included

Required Excel Class Skills:

Select this Microsoft Excel class if you or your group have:

  • Formatted a worksheet before
  • Typed in general formulas and used basic worksheet functions like VLOOKUP, IF...
  • Have used conditional formatting and data validation before
  • Used logic before in general and know the relational operators <, >, <=, >=, <>, =
  • Used basic Excel features like Sort, AutoFilter and have built charts

Excel Class Overview:

Our 1-day "hands-on" advanced Microsoft Excel class shows you advanced Excel skills that apply to creating smart adaptive Excel business tools. Topics include creating logical adaptive formulas that analyze complex data; using advanced data features like Pivot Tables, MS Query and text file processing; constructing basic dashboards using ActiveX controls and charts; linking to Word and PowerPoint plus much more.

Complete Class Outline and Signup

Beginning Microsoft Excel VBA Class for Business Outline and Signup

Beginning Microsoft Excel VBA Class
for Business Professionals

Next Date
Click Signup

Duration: 2-days

Available: Seminar,Webinar, Onsite, Self-Study

Manual: Self-Study Manual Included

Required Excel VBA Class Skills:

Select this Microsoft Excel VBA class if you or your group have:

  • Never programmed
  • Just used the macro recorder
  • Not programmed in over a year
  • Programmed but not used objects before
  • Used Microsoft Excel and know its operational capabilities and its tools
  • Built basic worksheet formulas (=A1+A2) and used worksheet functions like SUM

Excel Class Overview:

Our 2-day "hands-on" beginning Microsoft Excel VBA class shows you the essential Excel VBA programming skills that you need to immediately develop useful powerful data processing and analytical tools that your business needs now.

Complete Excel Class Outline/Signup

Advanced Microsoft Excel VBA Class for Business Outline and Signup

Advanced Microsoft Excel VBA Class
for Business Professionals

Next Date
Click Signup

Duration: 3-days

Available: Seminar, Webinar, Onsite, Self-Study

Manual: Self-Study Manual Included

Required Excel VBA Class Skills:

Select this Microsoft Excel VBA class if you or your group have:

  • Used the Excel VBA language before
  • Used variables, loops and logic before and know they operate
  • Used objects, properties and methods before in code to control a program
  • Used Excel drawing shapes and built charts manually
  • Built basic worksheet formulas (=A1+A2) and used worksheet functions like SUM, Match, COUNTIF, COUNTA...
  • A desire to understand VBA from a nuts and bolts perspective

Excel Class Overview:

Our 3-day "hands-on" advanced Microsoft Excel VBA class shows you how to build advanced data processing tools, analysis tools and dashboard displays using Microsoft Excel VBA that will solve the most difficult business tasks.

Complete Excel Class Outline

Microsoft Excel-Aided Business Class Outline

Microsoft Excel Aided Business Class
for Business Professionals

Onsite, Self-Study Only

Duration: 4-days

Available: Onsite, Self-Study

Manual: Self-Study Manual Included

Required Excel Class Skills:

Select this Microsoft Excel VBA class if you or your group have:

  • Opened or saved a workbook
  • Learned about worksheets, cells and cell references like A1
  • Copied and pasted worksheet data
  • Performed basic cell formatting tasks
  • Typed data in cells and built basic formulas
  • Used a worksheet function like SUM, COUNTIF...

Excel Class Overview:

Our 4-day "hands-on" Microsoft Excel and Microsoft Excel VBA class shows you the steps and strategies behind using Microsoft Excel and VBA to produce business tools that do days of work in seconds. This class takes key Excel topics like advanced formula design, key worksheet functions, Excel's data processing features, pivot tables, charts, dashboards and VBA macros and condenses them into one course.

Complete Excel Class Outline

Excel Classes for Engineers and Scientists

<<< Scroll Left to See Classes

Advanced Microsoft Excel Class for Engineers and Scientists Outline and Signup

Advanced Microsoft Excel Class
for Engineers and Scientists

Next Date
Click Signup

Duration: 1-day

Available: Seminar, Webinar, Onsite, Self-Study

Manual: Self-Study Manual Included

Required Excel Class Skills:

Select this Microsoft Excel class if you or your group have:

  • Formatted a worksheet
  • Typed in general formulas and used basic worksheet functions like IF
  • Built a table before and performed drag and fill operations on formulas
  • Used logic before in general and know the relational operators <, >, <=, >=, <>, =

Excel Class Overview:

Our 1-day "hands-on" advanced Microsoft Excel class shows you how to organize, name and store large amounts of data on worksheets; build advanced modeling and data formulas that can think and adapt; create advanced Excel array formulas that solve tough data and model problems; build advanced visual displays; process data using advanced formulas and Excel's statistical tools; link with external databases and text files; and construct advanced pivot tables. It also provides an introduction to VBA macros. Taught by an engineer.

Complete Excel Class Outline/Signup

Beginning Microsoft Excel VBA Class for Engineers and Scientists Outline and Signup

Beginning Microsoft Excel VBA Class
for Engineers and Scientists

Next Date
Click Signup

Duration: 2-days

Available: Seminar, Webinar, Onsite, Self-Study

Manual: Self-Study Manual Included

Required Excel VBA Class Skills:

Select this Microsoft Excel VBA class if you or your group have:

  • Never programmed or just used the macro recorder
  • Not programmed in over a year
  • Programmed but have not used objects before
  • Used Microsoft Excel and know its operational capabilities and its tools
  • Built basic worksheet formulas (=A1+A2) and used worksheet functions like SUM

Excel VBA Class Overview:

Based on our Excel VBA software design experiences, our 2-day "hands-on" beginning Excel VBA  class shows from an engineering and science view how to use VBA to control key Excel features, format and process technical data, perform sophisticated calculations, create technical charts, create custom worksheet functions, manage large models and information, create report generation tools and much more. Taught by an engineer.

Complete Excel Class Outline/Signup

Advanced Microsoft Excel VBA Class for Engineers and Scientists Outline and Signup

Advanced Microsoft Excel VBA Class
for Engineers and Scientists

Next Date
Click Signup

Duration: 3-days

Available: Seminar, Webinar, Onsite, Self-Study

Manual: Self Study Manual Included

Required Excel VBA Class Skills:

Select this Microsoft Excel class if you or your group have:

  • Used the Excel VBA language before
  • Used variables, loops and logic before and know they operate
  • Used objects, properties and methods before in code to control a program
  • Used Excel drawing shapes and built charts
  • Used worksheet functions like SUM, Match, COUNTIF, COUNTA...

Excel VBA Class Overview:

Based off our toughest Excel VBA customer software projects, our 3-day "hands-on" advanced Excel VBA class shows you from an engineering and science perspective how to use VBA to create advanced data analysis tools, advanced technical models, advanced database tools, dashboards using ActiveX controls and userforms, interface with other programming languages like VB.Net and FORTRAN and control other programs like Word and PowerPoint. Taught by an engineer.

Complete Excel Class Outline/Signup

Microsoft Excel-Aided Engineeirng Class Outline

Microsoft Excel Aided-Engineering and Science
for Engineers and Scientists

Onsite, Self-Study Only

Duration: 4-days

Available: Onsite, Self-Study

Manual: Self Study Manual Included

Required Excel VBA Class Skills:

Select this Microsoft Excel VBA class if you or your group have:

  • Opened or saved a workbook
  • Learned about worksheets, cells and cell references like A1
  • Copied and pasted worksheet data
  • Performed basic cell formatting tasks
  • Typed data in cells and built basic formulas
  • Used worksheet functions like SUM..

Excel VBA Class Overview:

Our 4-day hands-on Microsoft Excel and Microsoft Excel VBA class shows you through engineering and science examples the methods and strategies of using Excel and VBA to produce technical tools that do weeks of work in seconds. This class takes the most important Excel topics, worksheet formatting, interface design advanced formula design, Excel's data features, technical dashboards and VBA macros and condenses them into a compact 4 day class. Taught by an engineer.

Complete Excel Class Outline

FORTRAN DLL and Excel VBA Class Outline

FORTRAN DLL and Excel VBA
for Engineers and Scientists

Onsite, Self-Study Only

Duration: 3-days

Available: Onsite, Self-Study

Manual: Self Study Manual Included

Required Excel VBA Class Skills:

Select this Microsoft Excel VBA class if you or your group have:

  • Opened or saved a workbook
  • Have used worksheets, cells and formulas
  • Copied and pasted worksheet data
  • Performed basic cell formatting tasks
  • Used a worksheet function like SUM,...
  • Have used FORTRAN before

Excel VBA Class Overview:

Our 3-day "hands-on" FORTRAN DLL and Excel VBA class shows you how to link FORTRAN code with the power of Excel VBA. Discussed is how to use Microsoft Excel VBA as a front and rear end information processor for your FORTRAN programs and includes a full Excel VBA language review stressing data processing. Our class also shows you how to layout visual interfaces in Excel that communicate with your FORTRAN code. Also discussed is how to create FORTRAN DLLs from legacy FORTRAN source code and mix the two languages together to form a solution. Taught by an engineer.

Complete Excel Class Outline

Excel Classes for Combined Audience

<<< Scroll Left to See Classes

Microsoft Excel Dashboards Class Outline and Signup

Microsoft Excel Dashboards Class
for Combined Audience

Next Date
Click Signup

Duration: 3-days

Available: Seminar, Webinar, Onsite, Self-Study (B), Self-Study (ES)

Manual: Self-Study Manual Included

Required Excel Class Skills:

Select this Microsoft Excel class if you or your group have:

  • Constructed general worksheet formulas (=A1+A2) and have used worksheet functions before like SUM
  • Used Microsoft Excel's data processing tools before
  • Formatted a worksheet
  • Built basic charts
  • A desire to push Microsoft Excel to the limit

Excel Class Overview:

Our 3-day "hands-on" Excel Dashboards class shows you the complete mechanics of how to create advanced Microsoft Excel dashboards. The dashboard types covered include various status displays, project management displays, time lines, chart gauges, various summary style charts, various maps, color coding worksheets, pivot charts and any other dashboard you can dream up. It shows how to use all of Microsoft Excel's capabilities to construct these sophisticated dashboards and most importantly how to assemble them. It also demonstrates how to build custom worksheet functions using VBA which provide the ultimate formula construction.

Complete Excel Class Outline/Signup

Introduction to Excel VBA Class Outline

Introduction to Microsoft Excel VBA Class
for Combined Audience

Onsite, Self-Study Only

Duration: 1-day

Available: Onsite, Self-Study (B), Self-Study (ES)

Manual: Self-Study Manual Included

Required Excel VBA Class Skills:

Select this Microsoft Excel VBA class if you or your group have:

  • Never programmed or just used the macro recorder
  • Not programmed in over a year
  • Programmed but have not used objects before
  • Used Microsoft Excel and know its operational capabilities and its tools
  • Built basic worksheet formulas (=A1+A2) and used worksheet functions like SUM

Overview:

Our1-day "hands-on" Excel class shows you how to create Excel VBA macros that reduce your repetitive Excel tasks from hours to seconds. Our class shows you how to use the VBA language to command common Excel tasks like formatting, copying, pasting, inserting, deleting, sorting, data entry, and data filtering (AutoFilter, Advanced Filter). It also provides a basic review of programming including how to use variables, loops and logic in your code. It also discusses VBA procedure types, how to debug your code, how to perform calculations in your code and the strategy of using logic in programming.

Complete Excel Class Outline/Signup

Microsoft Excel VBA Data Mining Outline

Microsoft Excel VBA Data Mining Class
for Combined Audience

Onsite, Self-Study Only

Duration: 3-days

Available: Onsite, Self-Study (B), Self-Study (ES)

Manual: Self-Study Manual Included

-

Required Excel VBA Class Skills:

Select this Microsoft Excel class if you or your group have:

  • Have never programmed or just used the macro recorder
  • Used Microsoft Excel's data features and know them operationally
  • Formatted worksheets and know Excel's formatting capabilities
  • Have used Excel's worksheet functions like SUMIF, COUNTIF, Match..

Excel VBA Class Overview:

Our 3-day "hands-on" Excel VBA class shows you how to turn Excel into an advanced data processing system. Our class shows you how to use VBA to automate Excel's data processing features in unique ways. It discusses how to use loops and logic to reconcile data in multiple workbooks from multiple worksheets from multiple folders. Our class also demonstrates how to distribute data  into different table formats and templates. It also discusses how to use Excel's text file features and worksheet functions with VBA to data mine hard to read text files. Our class also shows how to generate reports in multiple workbooks/worksheets automatically laying them out and creating folders for them.

Complete Excel Class Outline

Microsoft Excel VBA Function Design Class Outline

Microsoft Excel VBA Function Design Class
for Combined Audience

Onsite, Self-Study Only

Duration: 2-days

Available: Onsite, Self-Study (B), Self-Study (ES)

Manual: Self-Study Manual Included

-

Required Excel VBA Class Skills:

Required Excel Skills: Select this Microsoft Excel VBA class if you or your group have:

  • Have never programmed or just used the macro recorder
  • Have built formulas and know how to name cells
  • Formatted worksheets and know Excel's formatting capabilities
  • Have used Excel's worksheet functions like SUMIF, COUNTIF, MATCH..

Excel VBA Class Overview:

Our 2-day "hands-on"  Microsoft Excel VBA class shows you how to develop your own custom worksheet functions using Visual Basic for Applications or VBA. Custom VBA worksheet functions (UDFs) can be used to replace worksheet formulas on the worksheet that take up space and file size. They can also do complicated tasks that regular formulas just cannot do. From data processing to modeling, they are the ultimate calculation building block to learn.

Complete Class Outline

Microsoft Excel Class Navigation

Microsoft Excel Webinar Classes

Excel Webinars

Microsoft Excel Seminar Classes

Excel Seminars

Microsoft Excel Company Onsite Classes

Excel Onsites

Microsoft Excel Self Study Manuals

Excel Manuals



Site Map

Copyright © 2002-2017

EMAGENIT All Rights Reserved