Excel VBA App Design for Engineers and Scientists Self-Study Manual

Learn how to build advanced UI driven Excel VBA tools that calculate and model problems; analyze and visualize data; and integrate data from different sources and databases.

Excel VBA App Design for Engineers and Scientists

Covers the advanced Excel VBA topics needed to design GUI driven engineering & science tools.

How our manual can help you.

Excel VBA App Design

Our self-study manual shows you how to create advanced analysis, modeling, and data reporting tools for engineering and science. It covers the Excel VBA fundamentals like controlling key Excel elements; formatting tables; controlling Excel's data tools, processing data; and automated chart construction.

It also covers advanced VBA topics like analyzing non-standard data tables; commanding userforms, the Ribbon, and ActiveX controls; developing event driven apps, controlling Windows folders and files; and controlling databases and text files.

Our manual also discusses unique topics like large scale modeling; automating Solver; and automating technical diagrams in Excel. It also discusses how to package your tools in different Excel type files.

  • Complete VBA Editor, Module, Debugger and language review
  • Creating expressions to command objects and perform calculations in VBA
  • Methods for tracking multiple Excel objects at once in your code
  • Using Excel VBA to control various Excel components, data tools, and formatting tools
  • Advanced chart automation and reporting with Excel VBA
  • Analyzing data in various table configurations (standard, stacked, broken...) with Excel VBA
  • Using Excel VBA to control and manage system models, trade studies, and automate Solver
  • Creating worksheet functions (UDFs) that perform calculations, numerical methods...
  • Creating advanced GUIs (userforms, ActiveX, events, Ribbon ...) to control your Excel Apps
  • Controlling databases and text files with ADO, SQL, and VBA
  • Controlling the Windows file system with VBA
  • Packaging and distributing your Excel VBA apps in workbook files and Add-Ins

What you will learn in our manual.

Expert Excel Training

$119.00

Buy the manual now and apply its price to a class later. Just type your transaction # in the comments when purchasing a class.

Coming in October

Manual specifications and download.

For:Engineers and Scientists
Format:ADOBE PDF and Excel Files as zip file download
Details:Covers beginning to advanced Excel VBA topics
Book:Fully illustrated, step-by-step instruction, with over 150 fully documented Excel VBA examples
Platform: Windows 7 and above
Download:Sent within 3 hrs after purchase Mon-Fri 8:00 AM - 7:00 PM CT
Versions: Excel 2013 for Windows and above

Associated classes.

Need Help? Please call us at 1.629.207.9662

Copyright © 2002-2023

EMAGENIT All Rights Reserved