Excel VBA Handbook for Engineers and Scientists Self-Study Manual

Our self-study manual covers what you need to know to start using Excel VBA to solve engineering and science problems. It provides an in-depth review of the VBA Editor and VBA language along with how to debug your code and use the different types of VBA modules.

Important engineering / science topics covered include problem layout, automating calculations, modeling, and custom worksheet function design (UDFs). Also discussed are chart automation, data processing, automating reports and table lookups, and building UIs to run your programs.

The manual also covers in detail how to control key Excel components like workbooks, worksheets, ranges, charts, formats, formulas, shapes...with VBA. It also covers how to automate key Excel data features like PivotTables, Sort, AutoFilter, and Excel Tables.

• Complete review of the VBA language, VBA Editor, modules, and the Editor debug tools
• Tracking objects and using properties and methods in your VBA code
• Using VBA to control workbooks, worksheets, ranges, formulas, fonts, borders, cell colors...
• Performing calculations in VBA using operators, VBA functions, and Excel worksheet functions
• Model layout and control using Excel VBA
• Automated report generation using Excel tables, Auto Filter, Sort, Remove Duplicates...
• Processing and calculating data on single and multiple worksheets using Excel VBA
• Creating and filling worksheet tables and reports using Excel VBA
• Using VBA to copy / paste, insert, delete, and format tables, columns, rows, and cells
• Automating charts and technical diagrams with Excel VBA
• How to build and run custom worksheet functions (UDFs) from formulas
• Creating UIs to run your VBA code and models