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

What you will learn in our manual.

• 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