Learn how to use Excel VBA to automate calculations, solve problems, enhance models, automate charts, and create time saving data processing tools.
Covers the Excel VBA essentials for building modeling, analysis, and data tools for engineering & science.
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.
$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
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 |
Excel Training Services
Excel Classes - Business and Industry
- Beginning Excel for Business and Industry
- Intermediate Excel for Business and Industry
- Advanced Excel for Business and Industry
- Excel Dashboards for Business and Industry
- Beginning Excel VBA for Business and Industry
Excel Classes - Engineers / Scientists
- Microsoft Excel for Engineers for Scientists
- Excel Data Analysis for Engineers and Scientists
- Excel VBA for Engineers and Scientists
- Excel VBA Data Analysis for Engineers and Scientists
- Adv Excel VBA Design for Engineers and Scientists
- Calling Fortran DLLs from Excel VBA
Excel Software Design/Consulting
Microsoft Excel Manuals
- Microsoft Excel Solutions Handbook
- Creating Advanced Excel VBA Apps
- Excel VBA Handbook for Engineers and Scientists
- Excel VBA App Design for Engineers and Scientists
EMAGENIT Company Information
US Military
Copyright © 2002-2023
EMAGENIT All Rights Reserved