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

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