Microsoft Excel-Aided Engineering Outline

Our 4-day "complete guide" to Microsoft Excel and Microsoft Excel VBA 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, technical formula design, Excel' data features, dashboards and macros and condenses them into a compact 4 day course. Taught by an engineer , 1800+ page manual included , hands-on training , Mac users welcome

Free Workshop Repeats

All of our workshops come with free repeats. We believe learning is an iterative process and not just a one time event. Details

EMAGENIT Customers and Awards

At EMAGENIT, we have trained customers like:

Boeing, General Dynamics, BMW Design Group, Shell Energy, Northrop Grumman, Caterpillar (View More)

We have also trained organizations like NASA, The US Army, Navy, Air Force and Marines and develop custom Excel software for the likes of Caterpillar and NASA (Award). Our diverse training background and software projects ensure you get the best Excel training drawn from real world experience not academia. We show you what you actually need to succeed.

Why Not Go Online For Your Training

Our live "hands-on" webinars enable us to train you and your company employees at different sites all over the country at once without having to collect them in one room. You can sign up for the webinar below. View Our Webinar Details Page

About Our Workshop

Microsoft Excel-Aided Engineering 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.

Workshop Availability

Available: Company Onsite, Self-Study Manual

Our Microsoft Excel Training and Beginning Excel VBA Training covers the same basic material as this workshop but broken apart. If you have any questions, please contact us 1.805.498.7162 or 1.805.558.9277.

Workshop Training Outline

In this Microsoft Excel VBA 4-day "hands-on" workshop you will learn:

Day-1:

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

Intended Audience

Excel-Aided Engineering is designed to accommodate all levels of Excel users.
It is intended for all types of engineering and science professionals.

Self-Study Manual

The Self-Study button will lead you to our manual page where you can get the manual pricing and the manual outline. The manual comes with the class.

Site Map