Excel Training, Excel VBA Training, Excel Software Design

Microsoft Excel-Aided Engineering and Science
for All Technical Professionals

Microsoft Excel-Aided Engineering and Science
Onsite Only

Learn to build high end technical tools using advanced formulas, Excel's data tools, ActiveX controls and VBA macros that will solve your tough engineering and science problems.

Our 4-day "hands-on" Microsoft Excel-Aided Engineering and Science workshop shows you the methods and strategies of using Excel and VBA to produce technical tools that do weeks of work in seconds. This workshop takes the most important Excel topics like technical worksheet layout strategies, technical formula design, modeling strategies, numerical analysis, data processing, dashboard construction and Excel VBA macros and condenses them into a compact 4 day course to get you started. Taught by an engineer. Excel for Mac covered.

Microsoft Excel-Aided Engineering and Science:   Focus

Microsoft Excel-Aided Engineering and Science:   Focus

Microsoft Excel along with VBA (macros) has vast potential for the creation of technical tools that save time and money. Most of this potential goes unused however in the technical community. For example, just simple table layout on a worksheet, naming cells and ranges and proper formula design allow sophisticated worksheets and formulas to be constructed that adapt to changing worksheet data. This eliminates having to recreate a project every time you get new data. Also, just the basic understanding of how to apply VBA to control Excel will enable powerful applications to be built that manual formula design alone could not achieve. This workshop takes the most important Excel and VBA topics and condenses them into a 4 day course.


Microsoft Excel-Aided Engineering and Science:   Who Should Attend?

Microsoft Excel-Aided Engineering and Science:   Who Should Attend?

Select this workshop 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...

Microsoft Excel-Aided Engineering and Science:   Outline

Important: We focus our training on what our customers need. This training can be taught many different ways focusing on basically any Excel topic. Below is a rough outline with some of the more popular topics for the workshop. We will custom design the workshop around your needs.



Day-1

Microsoft Excel-Aided Engineering and Science: Free Repeats Policy
  • Basic formula design, formula debugging and cell naming
  • How to nest Microsoft Excel worksheet functions, prelude to advanced formula design
  • How to construct "smart" Microsoft Excel worksheets using Excel's logic, information, and lookup and reference worksheet functions including VLOOKUP, MATCH, OFFSET, SUMIF, COUNTIF, INDEX, INDIRECT, IF, AND, OR, ADDRESS, COLUMN and ROW
  • How to perform text concatenation in Microsoft Excel worksheet formulas, used in advanced formula design and reporting
  • How to use array formulas to build advanced worksheet formulas that determine and adapt to changing information requirements
  • How to use array formulas, ActiveX controls, form controls, logic driven conditional formatting and logic driven data validation to create advanced dashboards on the Microsoft Excel worksheet
  • How to use the text worksheet functions like RIGHT, MID, LEFT SUBSTITUTE, REPLACE, SEARCH and CLEAN to analyze worksheet text
  • How to create and manage databases in Microsoft Excel
  • How to import and parse text files in Excel
  • How to create and use Microsoft Excel pivot tables for reports
  • How to link workbooks and worksheets together including team integration and large scale information transfer


Day-2

  • How to use the VBA Editor and VBA debugger
  • How to use VBA projects, modules and procedures
  • How to use the VBA language including variables, data types, constants, arrays, operators, expressions, loops, logic decisions and calling
  • Overview of commanding Excel using VBA including a discussion of objects, properties and methods
  • How to analyze technical data on single Excel worksheets using loops and logic
  • How to use Excel VBA to load Excel forms on the worksheet using loops, logic along with copy and paste
  • How to use Excel VBA to create charts


Day-3

  • How to analyze data in multiple workbooks and worksheets
  • How to use VBA to summarize technical data
  • How to access the Windows file and folder system to open and close workbooks
  • How to protect your VBA code against errors
  • How to use Excel and VBA to create basic dashboards using ActiveX controls and worksheets
  • How to automate pivot tables with VBA
  • How to create basic report generation tools using Excel VBA, Microsoft Word and PowerPoint
  • How to use the Excel Visual Basic macro recorder to record Excel tasks in VBA and then interpret the code


Day-4

  • How to use graphics, userforms, drawing shapes, ActiveX controls and Excel VBA to create advanced dashboards in Excel
  • How to integrate ActiveX controls and VBA with existing technical models that are formula based
  • Mixed language programming discussion using VBA, FORTRAN, C and VB .Net
  • How to use ADO to query workbooks and text files, large data set importation
  • How to command databases using DAO and ADO in VBA

Microsoft Excel-Aided Engineering and Science: Additional Information

Additional Microsoft Excel-Aided Engineering and Science Training Information

  • Duration: 4-days
  • Our workshops cover Excel versions 2007-2016 including Excel for Mac and discuss differences when necessary.

Included in Our Microsoft Excel-Aided Engineering and Science Training

  • Free Repeats
  • 1800+ page manual filled with key Excel strategies, examples and tips
  • Hands-on training
  • Personal questions answered

Training Formats

Onsite Only

Microsoft Excel Aided Engineering and Science: Question Form

Instructions: Please fill in your contact information.

Name:
Company:
Company Web:
Country:
Phone #:
Ext:
e-mail:
Contact me directly by phone

Please fill out the box below with your workshop questions and EMAGENIT will contact you.

Request Workshop Information (Optional)


Send me on-site workshop information Send me self-study manual information
Send me public seminar workshop information Send me live online webinar information

Privacy Policy



Site Map

Copyright © 2002-2017

EMAGENIT All Rights Reserved