Microsoft Excel 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, integrate and filter data. Taught by an engineer.

Select this Microsoft Excel class if you or your group:

• Know how to open a workbook
• Know what a worksheet and cell are
• Have formatted a worksheet
• Have typed in a formula before
• Have a basic knowledge of how Excel works

Our 1-day hands-on Microsoft Excel class shows you how to create engineering and science related formulas and debug them; name cells and ranges and use them; transmit large amounts of information between worksheets and workbooks; construct worksheet and Excel tables to store data; build modeling, analysis and data formulas including logic and lookup; build technical displays; process text; create charts and construct Pivot Tables. It also provides an introduction to VBA macros and custom VBA worksheet functions. 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 Excel VBA fundamentals class starts off with a complete review of how to use the VBA language and the debugger. After covering the programming basics, it shows how to use VBA to: control key engineering and science features in Excel; format and process technical data on single and multiple worksheets; automate technical charts; create powerful UDF worksheet functions for modeling and data analysis; and build report generation tools that can link with Word and PowerPoint. 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 Excel VBA data analysis class starts off with a critical review of the VBA language components that are used in data processing focusing on logic, arrays and loops. It then shows how to use VBA to: lock onto various worksheet ranges, automate Excel's data tools; create analysis tools that process data in multiple workbooks and folders; fuse data from multiple sources like databases, web pages and text files; process data in unconventional table layouts; and command Excel's visual elements and charts to display 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 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; integrate and calculate advanced models; create advanced database tools; create advanced dashboard / visual tools using events, ActiveX controls and userforms; interface with other programming languages like VB.Net; and control other programs like Outlook, PowerPoint and web pages. 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 training 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.

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.