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

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

Our 1-day Excel data analysis for engineers and scientists training will show you how to effectively use Excel to process engineering and scientific data. Key topics include using cell and range names to track data, using key functions like VLOOKUP, MATCH, COUNTIF, SUMIF and IF in data analysis; using array formulas to process data; organizing and storing data on the worksheet; analyzing worksheet data with various Excel data tools; building charts; cleaning worksheet data and working with text files; and linking Excel to other programs like Word and PowerPoint for reporting purposes. Also discussed is how to use pivot tables and Power Query to pre-process and filter data. Taught by an engineer.

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

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.

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

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.

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

Our 2-days hands-on Intermediate Excel VBA class shows you how to create innovative data analysis, data fusion and data visualization tools for engineering and science. 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 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...

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.

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 worksheet functions like SUM..

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.

Select this Microsoft Excel 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

Our 3-day hands-on FORTRAN 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.