Covers the Excel VBA essentials for building modeling, analysis, and data tools for engineering & science.
Our manual covers how to use Excel VBA to automate calculations, build reports, analyze data, model and much more.
![]() |
![]() |
![]() |
![]() |
![]() |
![]() |
![]() |
Our manual covers how to use the VBA language and the essential Excel VBA topics needed for solving engineering and science problems. It explains in detail the VBA fundamentals you need to know to start writing high powered macros.
VBA topics covered include how to use data types, variables, constants, arrays, operators, expressions, loops, logic, and functions in your code. Also covered is a complete review of the VBA Editor, how to debug your code, and how to use the different types of VBA modules. There is also an in depth discussion about Excel objects, properties, and methods and how to type and use them in your code.
The manual also covers how to use VBA to control key Excel components like workbooks, worksheets, ranges, charts, formats, formulas, shapes...etc. It also covers how to automate key Excel data features like PivotTables, Sort, AutoFilter, Excel Tables...etc.
Important VBA engineering and science topics covered include problem formulation on the worksheet, automating calculations, modeling, data processing, report table construction, custom worksheet functions (UDFs), and building UIs to run your programs. It uses real engineering and science examples that show you how to start building Excel VBA macros right away.
$75.00
Buy the manual now and apply its price to a class later. Just let us know when purchasing a class.
It's a 1000+ page manual, there's a lot of topics!
For: | Engineers and Scientists |
Format: | ADOBE PDF and Excel Files as zip file download |
Details: | Covers beginning to intermediate Excel VBA topics |
Book: | 1000 + pages with examples |
Platform: | Windows 7 and above |
Sent: | Sent within 3 hr 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