Microsoft Excel Classes - Class Guide / Skill Levels

Since 1998

Microsoft Excel Classes - Class Guide / Skill Levels

Business, Science and Engineering

Microsoft Excel classes like no others.

We cover the essential, must know, Microsoft Excel strategies and topics that you need to succeed in business, engineering and science.

Questions? 1.805.498.7162   Customers >

Training Dates / Signup

View All >

Excel 2019 Training Dates/Signup

US Military, DOD Discounts

Learn More >

EMAGENIT US Military Discounts

Business Classes

Beginning Microsoft Excel for Business Class
Outline / Signup >
Beginning Microsoft Excel Class for Business
Next Date:
See Schedule

Duration: 1-day

Type: General Excel Class

Format: Public >, Live Online >, Onsite >

Self Study Manual: Microsoft Excel Business Essentials >

Required Excel Skills

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

  • Performed basic computer operations like typing and using the mouse
  • Never opened Microsoft Excel or have just seen it
  • Never heard of a workbook, worksheet, cell, or cell reference
  • Just typed data in a cell
  • Never typed formulas
  • Never copied, sorted, or filtered data
  • Have no idea what we just said

Excel Class Overview

Our 1-day hands-on Excel class will show you the basics of Excel like workbook and worksheet control, worksheet formatting, problem layout, data entry, copying / pasting, sorting, basic charts, basic formula design and much more.

Intermediate Microsoft Excel for Business Class
Outline / Signup >
Intermediate Microsoft Excel Class for Business
Next Date:
See Schedule

Duration: 1-day

Type: General Excel Class

Format: Public >, Live Online >, Onsite >

Self Study Manual: Microsoft Excel Business Essentials >

Required Excel Skills

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

  • Have opened and saved a workbook file
  • Know the basics about worksheets, cells and using cell references like A1
  • Have copied and pasted worksheet data
  • Have performed basic cell formatting tasks like coloring a cell, bolding, aligning...
  • Have typed data in worksheet cells and built basic formulas like =A1+A2
  • Have used a worksheet function like =Sum(A1:A10) in a formula or have seen it before

Excel Class Overview

Our 1-day hands-on Excel class shows you how to use formulas, tables, Excel tables, names, key worksheet functions, filters, charts, and basic pivot tables to quickly analyze and report business data. It also shows you how to quickly link and update Excel data in Word and PowerPoint reports.

Advanced Microsoft Excel for Business Class
Outline / Signup >
Advanced Excel Class for Business
Next Date:
See Schedule

Duration: 1-day

Type: General Excel Class

Format: Public >, Live Online >, Onsite >

Self Study Manual: Microsoft Excel Business Essentials >

Required Excel Skills

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

  • Formatted a worksheet using colors, fonts, borders, alignments, number formats...
  • Typed in formulas and used worksheet functions like VLOOKUP, IF, MAX, MIN, COUNTIF...
  • Built a worksheet table before and performed drag and fill operations on formulas
  • Used logic before in formulas and know the relational operators <, >, <=, >=, <>, =
  • Used basic Excel data tools before like Sort and AutoFilter
  • Built and formatted charts
  • Built basic PivotTables and PivotCharts

Excel Class Overview

Our 1-day hands-on Excel class shows how to make powerful adaptive business data tools by combining Excel's data shaping and integration tools, advanced formulas, array formulas, charts, ActiveX controls, Conditional Formatting, and PivotTables. It also includes an introduction to Excel VBA macros.

Beginning Microsoft Excel VBA for Business Class
Outline / Signup >
Beginning Microsoft Excel VBA Class for Business
Next Date:
See Schedule

Duration: 2-days

Type: Excel VBA Macro Class

Format: Public >, Live Online >, Onsite >

Self Study Manual: Beginning / Intermediate Microsoft Excel VBA for Business >

Required Excel VBA 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 VBA 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.

Excel VBA Data Processing for Business Class
Outline >
Excel VBA Data Processing for Business
Onsite Only

Duration: 2-days

Type: Excel VBA Macro Class

Format: Onsite >

Self Study Manual: Beginning / Intermediate Microsoft Excel VBA for Business >

Required Excel VBA Skills

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

  • Written a procedure in VBA
  • Used variables, loops, functions, declarations,... in some capacity in VBA
  • Used and written basic logic in VBA
  • Used Microsoft Excel's data tools manually and know them operationally
  • Formatted worksheets and know Excel's basic formatting capabilities
  • Have used Excel's worksheet functions like MATCH, COUNTIF, SUMIF, VLOOKUP...

Excel VBA Class Overview

Our 2-day hands-on  Excel VBA data processing for business shows you how to create useful data analysis, data fusion and data visualization tools using Microsoft Excel and VBA.

Advanced Microsoft Excel VBA for Business Class
Outline / Signup >
Advanced Microsoft Excel VBA Class for Business
Next Date:
See Schedule

Duration: 3-days

Type: Excel VBA Macro Class

Format: Public >, Live Online >, Onsite >

Self Study Manual: Advanced Microsoft Excel VBA for Business >

Required Excel VBA 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 VBA Class Overview

Our 3-day hands-on advanced Excel VBA training shows you how to build advanced data processing, data fusion, charting, and dashboard display tools using VBA along with userforms, ActiveX controls, shapes, worksheets, charts, events, PivotTables, and databases.

Engineering / Science Classes

Microsoft Excel Data Analysis for Engineers / Scientists Class
Outline / Signup >
Microsoft Excel Data Analysis for Engineers / Scientists
Next Date:
See Schedule

Duration: 1-day

Type: General Excel Class

Format: Public >, Live Online >, Onsite >

Self Study Manual: Microsoft Excel Aided Engineering and Science >

Required Excel Skills

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

  • Used Excel's Ribbon interface, dialog boxes, and shortcut menus
  • Opened and saved a workbook file
  • Typed in a worksheet cell before
  • Copied and pasted data in Excel
  • Created a simple worksheet formula like =A1+A2

Excel Class Overview

Our 1-day hands-on Excel data class focuses on: using key worksheet functions, formulas, and array formulas to process data; maximizing the use of Excel's data features, cell flagging tools, and charts to view data; and using PivotTables and Power Query to process and integrate worksheet data. Taught by an engineer.

Microsoft Excel for Engineers / Scientists Class
Outline / Signup >
Microsoft Excel Class for Engineers and Scientists
Next Date:
See Schedule

Duration: 1-day

Type: General Excel Class

Format: Public >, Live Online >, Onsite >

Self Study Manual: Microsoft Excel-Aided Engineering and Science >

Required Excel Skills

Select this Microsoft Excel class if you or your group:

  • Controlled workbooks, worksheets, and entered worksheet data
  • Copied and pasted worksheet data
  • Performed basic cell formatting tasks like coloring a cell, bolding, aligning,...
  • Used cell and range references like A1 or A1:A10 in formulas
  • Built formulas like =.5*0.002377 *A1^2
  • Used basic worksheet functions like SUM, MAX, MIN,..

Excel VBA Class Overview

Our 1-day hands-on Excel class shows you how to use Excel to create powerful models; perform analysis; assemble problem interfaces; create adaptive technical displays; solve numerical techniques; and create custom VBA worksheet functions to solve tough calculations. Taught by an engineer.

Excel VBA Fundamentals for Engineers / Scientists Class
Outline / Signup >
Excel VBA Fundamentals for Engineers / Scientists Class
Next Date:
See Schedule

Duration: 2-days

Type: Excel VBA Macro Class

Format: Public >, Live Online >, Onsite >

Self Study Manual: Excel VBA Fundamentals for Engineers and Scientists >

Required Excel VBA Skills

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

  • Never programmed or not programmed in over a year
  • Just used the macro recorder for VBA code
  • Programmed but have not used objects before or minimally
  • Used Microsoft Excel and know its operational capabilities
  • Built basic worksheet formulas (=A1+A2) and used worksheet functions like SUM
  • Used Excel data processing tools like Sort, Autofilter, Advanced Filter, Group, and Remove Duplicates
  • Built charts manually

Excel VBA Class Overview

Our 2-day hands-on Excel VBA class will show you the fundamentals of Excel VBA programming emphasizing how to use Excel VBA: to track and process data stored on single and multiple worksheets; to assemble, manage, and calculate model / analysis problems; to automate key Excel data tools; and to automate chart construction. Taught by an engineer.

Excel VBA Data Analysis for Engineers / Scientists Class
Outline >
Excel VBA Data Analysis Class for Engineers / Scientists
Onsite Only

Duration: 2-days

Type: Excel VBA Macro Class

Format: Onsite >

Self Study Manual: Excel VBA Fundamentals for Engineers and Scientists >

Required Excel VBA Skills

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

  • Used variables, loops, functions, declarations,... in a basic capacity in VBA
  • Used and written basic logic in VBA
  • Used Excel objects, properties, and methods in a basic capacity in VBA
  • Used Microsoft Excel's data tools manually and know them operationally
  • Formatted worksheets manually and know Excel's basic formatting capabilities
  • Build charts and drawing shapes manually before in Excel
  • Used Excel's worksheet functions like MATCH, COUNTIF, SUMIF, VLOOKUP...

Excel VBA Class Overview

Our 2-day hands-on Excel VBA data class shows you how to combine VBA with the worksheet, text files, databases, Excel's data tools, charts, shapes, pictures and Windows folder system to create tools that process, organize, visualize, store, and fuse engineering and science data. Taught by an engineer.

Advanced Excel VBA Methods for Engineers / Scientists Class
Outline / Signup >
Advanced Excel VBA Methods for Engineers / Scientists Class
Next Date:
See Schedule

Duration: 3-days

Type: Excel VBA Macro Class

Format: Public >, Live Online >, Onsite >

Self Study Manual: Advanced Excel VBA Methods for Engineering and Science >

Required Excel VBA 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 Excel objects, properties and methods before in VBA code
  • Used Excel drawing shapes and built charts manually
  • Used worksheet functions like SUM, Match, COUNTIF, COUNTA...
  • Used Excel's data processing tools like Autofilter, Sort, Remove Duplicates, and PivotTables

Excel VBA Class Overview

Our 3-day hands-on advanced Excel VBA class shows you how to combine VBA with Excel worksheets, shapes, charts, userforms, ActiveX controls, events, Excel's data tools, and databases to build adaptive UI driven data, modeling and analysis tools. Taught by an engineer.

Calling Fortran DLLs from Excel VBA for Engineers / Scientists Class
Outline / Signup >
Calling Fortran DLLs from Excel VBA Class Outline
Next Date:
See Schedule

Duration: 3-days

Type: Excel VBA Macro / FORTRAN Class

Format: Onsite >

Self Study Manual: Calling Fortran DLLs from Excel VBA >

Required Excel VBA Skills

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

  • Operated Excel's basic data processing tools like AutoFilter, Sort,...
  • Used worksheet functions before and know they operate
  • Copied and pasted worksheet data
  • Typed data in cells and built formulas
  • Created charts and used drawing shapes
  • Used VBA before in a basic manner
  • Basic programming experience like loops, logic and variables
  • Used Fortran before or have been exposed to it. Syntax will be reviewed

Excel Class Overview

Our 3-day hands-on Fortran / Excel VBA class shows you how to call Fortran DLL's from Excel VBA combining the speed and numerical abilities of Fortran with the interface, drawing and reporting capabilities of Microsoft Excel VBA. Taught by an engineer.

Combined Audience Classes

Microsoft Excel Dashboards for Combined Audience Class
Outline / Signup >
Microsoft Excel Dashboard Class
Next Date:
See Schedule

Duration: 3-days

Type: General Excel Class

Format: Public >, Live Online >, Onsite >

Self Study Manual: Microsoft Excel Aided Engineering and Science >

Self Study Manual: Microsoft Excel-Aided Business >

Required Excel Skills

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

  • Constructed general worksheet formulas like =A1+A2
  • Used cell references and range references like A1 or A1:A10
  • Used worksheet functions like SUM, MAX, MIN...before
  • Used Microsoft Excel's data tools before
  • Formatted a worksheet before
  • Built charts and drawing shapes
  • A desire to push Microsoft Excel to the absolute limit

Excel Class Overview

Our 3-day hands-on Excel Dashboard class shows you how to build adaptive dashboards from: worksheets, formulas, functions, array formulas, shapes, pictures, charts, PivotTables, ActiveX controls, Conditional Formatting, Data Validation, Power Query... that let you import, process, visualize, and integrate your data.

About our Microsoft Excel class and skills guide.

Our class guide above displays all of our Microsoft Excel classes side by side so you can see which one is right for you. Our classes fall into 2 main categories: general Excel training (non-VBA macro) and Excel VBA macro training. Our Excel classes are also divided into three disciplines: business; engineering/science; and combined audience. Our guide also discusses the skill requirements for each of our classes.

Excel Classes Formulas, Conditional Formatting and VBA Programming.
In our Excel classes, we cover topics from 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 Microsoft Excel classes and Microsoft Excel VBA classes are taught around the real world problems that you bring to class, not from a rigid manual that you just read and do problems from.

Connecting to External Data Sources.
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 cover all types of Excel solutions and math levels in our Excel classes.

EMAGENIT does not only teach the application of Excel towards practical business problems including data processing, we are also comfortable teaching high end business, engineering and science 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.
In our Excel classes, we can show you how to layout and construct high end business, engineering and science 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.

An Excel manual that actually contains useful examples.

All of our Microsoft Excel classes include a 2200+ page business or engineering / science manual that you will be able to use after class to reproduce what you did while training.

EMAGENIT Excel Manual.
Our Microsoft Excel manuals cover everything you need to know to get yourself up and running in Excel. At over 2200 + pages, one could say it actually contains a little more than what you just need to know.
Contact Us Newsletter
Need Help? Please call us at 1.805.498.7162

Microsoft Excel Products

- Excel Self-Study Manuals

Copyright © 2002-2020

EMAGENIT All Rights Reserved