Excel Aided Engineering and Science Manual

Our manual covers all the Excel and VBA topics engineers / scientists need to build powerful model, analysis, optimization, and data processing tools.

• Covers key Excel topics like formulas, functions, charts, filters, Power Query, PivotTables, ActiveX controls, modeling, numerical analysis, and dashboards
• Covers the fundamental to advanced Excel VBA topics needed to build automated models, analysis, data processing, UIs, and database tools
• Over 2200+ pages of industry proven Excel topics
• 100's of real world examples
• Buy a manual now, apply the price towards a class later. They are free with our classes.

Manual specs.

About our manual.

Our all-in-one 2200+ pg Excel manual covers the must know Excel and VBA topics engineers / scientists need to start building powerful Excel tools.

The first half of the manual covers fundamental Excel topics like worksheet operation, cell data entry, worksheet formatting, formulas, worksheet functions, and cell naming. It also covers essential data topics like worksheet table design, Excel tables, charts, sorting and filtering data, PivotTables, and linking Excel with other programs like Word and PowerPoint.

Other must know Excel topics covered include external data integration using Power Query and MS Query, designing reports that adapt to changing data, integrating design teams, creating advanced array formulas, performing design optimization using Solver, system modeling, and creating industrial grade dashboards.

Our Excel discussion also covers solving numerical techniques on the worksheet including linear systems, Runge Kutta, Newton's method, integration, differentiation, and boundary value problems.

The second half of the manual includes everything we know about using Excel VBA in engineering and science. It covers the fundamentals to the most advanced Excel VBA topics we have encountered. It will show you how to automate things like models, analysis problems, charts, data processing, and database tools. The topics are so broad, we refer you to the topics listed below.

Click to enlarge, scroll < > if hidden.

The specifics about the manual.

• Creating, opening, saving workbooks; controlling workbook views; using the Ribbon and Excel help
• Worksheet formatting, formulas, names, array formulas, problem formulation, functions, and numerical analysis methods
• Using Sort, Filter, Advanced Filter, Excel tables, Slicers, and PivotTables for data analysis
• Using ActiveX controls, Conditional Formatting and Data Validation for worksheet UI development
• Using MS Query and Power Query to query, integrate, and filter external workbook and database data
• Creating and building technical charts and chart reports in Excel
• Advanced Microsoft Excel dashboard design
• How to use the VBA Editor Windows, VBA modules, and debug tools
• Complete VBA language, VBA procedure, and Excel automation review
• How to develop models and data processing tools using Excel VBA
• How to design custom worksheet functions in VBA that perform advanced calculations and numerical analysis
• Constructing and controlling system models in Excel VBA
• Performing trade studies and automating Solver in Excel VBA
• Using shapes, pictures, and worksheet cells to design basic UIs to run your VBA code
• Using events, ActiveX controls, userforms, worksheets, events, shapes, charts, and VBA to create advanced Excel UIs
• Commanding databases using VBA, SQL, and DAO
• How to control Word, PowerPoint, and Outlook using VBA
• How to run Fortran DLLs from Excel VBA and worksheet formulas

Price: $145.00