Excel VBA Handbook for Engineers and Scientists Self-Study Manual

Learn how to use Excel VBA to automate calculations, solve problems, enhance models, automate charts, and create time saving data processing tools.

Excel VBA Handbook for Engineers and Scientists

Covers the Excel VBA essentials for building modeling, analysis, and data tools for engineering & science.

How our manual can help you.

Excel VBA Handbook

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

What you will learn in our manual.

Expert Excel Training

$99.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 intermediate Excel VBA topics
Book: Fully illustrated, step-by-step instruction, with over 100 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