Microsoft Excel Classes - Class Guide / Skill Levels

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

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.

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

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.

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

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.

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

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.

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

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.

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

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.